By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,067 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,067 IT Pros & Developers. It's quick & easy.

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

P: 1
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.
Apr 4 '20 #1
Share this Question
Share on Google+
1 Reply


P: 37
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 MessagesYesNoWithResponse()

' 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 MessagesYesNoCancel()

' 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
Apr 4 '20 #2

Post your reply

Sign in to post your reply or Sign up for a free account.