Sign in to join the conversation:
All: this is to share/record a way to push the submit button in a smartsheet webform using vba. I share this because I spent way more time trying different options posted on different websites than I would like to admit.
Dim IE As Object
Set IE = CreateObject("InternetExplorer.application")
IE.navigate "www.smartsheet.com/formurl"
IE.Document.querySelector("button[type=submit]").Click
Hi L@123, thanks for sharing. I wonder if you are sharing the information from smartsheet to a VBA form. If so I wonder what other steps I must take into account.
Best regards
Mau
I am moving information from a microsoft application such as access or excel to a smartsheet form, then automatically submitting the form with a method that requires very little programming knowledge. In order to utilize this, you update the url with a query string to autofill the individual fields (https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values) then submit.
If you wish to transfer data from smartsheet to a microsoft application, the reverse of what I am doing, an ODBC connection is the way to go. They have a decent tutorial on how to do this. (http://smartsheet-platform.github.io/odbc-docs/#overview)
I know this is a problem with EU region as well, but wanted to know when regions other than north america will get support for apps like zapier. Everywhere I have read it is always the app developers saying they are waiting on smartsheets. I have tried cloning the connection app on the websites like zapier and maker and…
Hi - my organization has been using Smartsheet for several years and we're looking to automate wherever possible for consistency and efficiency. Whenever a new project starts, the PMO creates a timeline (save as new) from a template that's specific for that project type. The PMO manually updates the default value in a few…
I've a sheets where the columns names are the following (without the quotes) : "Expiration Date " "Expiration Date " So, the first one has a space at the end and the second one hasn't. Previously that was supported by smartsheet API AND the user interface, although it's not possible anymore. What's funny : Most features on…
