How to connect the unloading of data from forms on the website to the Excel data tab

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Natabell
    New Member
    • Apr 2020
    • 1

    How to connect the unloading of data from forms on the website to the Excel data tab

    How to connect the unloading of data from forms on the website to the Excel data tables?

    Now:
    There is a landing page with a customer data collection form. Data is collected in google table.
    In this case, this is the task:
    The data that is collected is transmitted to machinery for cutting furniture parts. Now a person needs to manually transfer them to a table for the requirements of this machine. It is necessary to bring the process to automation.

    That is, it is necessary that the table ultimately be in a specific format and with the data of each user separately, while this table should be automatically sent to the mail each time it is filled in again. Ultimately, a table of a certain format should be sent to the mail separately from each user who completed the form.

    Is it possible to translate it into reality? If so, with what?
    Now the landing page is created on the tilde, we want to transfer it to WordPress.
  • lewish95
    New Member
    • Mar 2020
    • 33

    #2
    The following code shows two simple examples of using a message box

    ' https://excelmacromastery.com/
    Sub BasicMessage()

    ' Basic message
    MsgBox "There is no data on this worksheet "
    ' Basic message with "Error" as title
    MsgBox "There is no data on this worksheet ", , "Error"

    End Sub


    In the next example, we ask the user to click Yes or No and print a message displaying which button was clicked

    ' https://excelmacromastery.com/
    Sub MessagesYesNoWi thResponse()

    ' Display Yes/No buttons and get response
    If MsgBox("Do you wish to continue? ", vbYesNo) = vbYes Then
    Debug.Print "The user clicked Yes"
    Else
    Debug.Print "The user clicked No"
    End If

    End Sub


    In the final example we ask the user to click Yes, No or Cancel

    ' https://excelmacromastery.com/
    Sub MessagesYesNoCa ncel()

    ' Display Yes/No buttons and get response
    Dim vbResult As VbMsgBoxResult

    vbResult = MsgBox("Do you wish to continue? ", vbYesNoCancel)

    If vbResult = vbYes Then
    Debug.Print "The user clicked Yes"
    ElseIf vbResult = vbNo Then
    Debug.Print "The user clicked No"
    Else
    Debug.Print "The user clicked Cancel"
    End If

    End Sub

    Comment

    Working...