Does anyone know if there is a way to execute actions of the Excel plugin via VBA? I am putting together a sheet to help our team with data entry where using data pages is just too inefficient (there are too many records to manually enter every item and every link). So basically I use the sheet to create the parent items, user imports that, then refresh the updated tables via the Excel plugin to get the new GUIDs, and from there all the rest of the data/links are created and then the user can import them.
It works pretty effectively except for the fact that each table must be selected one by one manually to refresh the Caspio data in Excel. I would love to be able to automate that.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
NickO
Does anyone know if there is a way to execute actions of the Excel plugin via VBA? I am putting together a sheet to help our team with data entry where using data pages is just too inefficient (there are too many records to manually enter every item and every link). So basically I use the sheet to create the parent items, user imports that, then refresh the updated tables via the Excel plugin to get the new GUIDs, and from there all the rest of the data/links are created and then the user can import them.
It works pretty effectively except for the fact that each table must be selected one by one manually to refresh the Caspio data in Excel. I would love to be able to automate that.
Thanks in advance
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.