I have a VBA Excel application and a Caspio database. I want to trigger some VBA code to seamlessly download selected fields from the Caspio database and place the fields into pre-defined columns of my spreadsheet. Can Zapier do this for me?
Hey there,
You can filter by an Expert that has more experience with your specific apps but no way to publish a scope at the moment.
That said, I was looking at some of your initial question and it sounds like you’re looking for Caspio to be the initial trigger. In which case these are the available triggers:

I know you mentioned none of these seemed to fit what you’re needing, which I totally understand. If you need something a bit more custom, an Expert is going to be the best resource as Zapier doesn’t currently offer this type of service.
This is also a great article my teammate Danvers wrote on working through if and how Zapier can help with current workflows. :
I hope some of this helps!
Hi
Cheers, Ron
Hi
I’m jumping in to see if I can help!
Your desired workflow could still be possible with the help of one of our Certified Zapier Experts. You can easily connect with them by visiting this link: https://zapier.com/experts
Hi
Thanks again, Ron
Hi
I’m not really sure if it is possible but I suggest giving it a try by creating the Zap and then test it.
Here’ are the available triggers in the Microsoft Excel app:
Here’s the available action step in the Caspio Cloud Database:
Hopefully this helps!
Hi
Best regards, Ron
Hi
Jumping in to see if I can help!
I understand you want to create a Zap, and the trigger is the Excel sheet. What action app are you going to use? Is the name of the app, Caspio?
Here are helpful articles you can check:
Hi Charie and thanks for taking the time to help me.
I have an excel spreadsheet which has considerable VBA coding. I’m not a Zapier user yet but will be if I can achieve the objective. Here’s the process I’m trying to automate
- From the spreadsheet I want to click on an icon as the trigger point.
- The VBA code has the URL, Login and Password credentials to the Caspio database. Currently I can’t connect to the database directly using VBA so I’m hoping that Zapier can do the following points.
- Seamlessly connect to the database.
- Extract a number of non-contiguous fields from the database and paste them into pre-defined columns of my spreadsheet. This can’t be a block of data because the fields in the database are of a different order to the spreadsheet columns
- Terminate the connection
To summarise… When the icon in the spreadsheet is selected I want Zapier to connect to the database in my Caspio account and perform a data extract, placing the field data into specific columns within my spreadsheet.
I genuinely hope I’ve conveyed this in a way you’ll understand.
The name of the Caspio app is “Assets55 Survey” and the table is “Survey_Collection_Table”. The Excel spreadsheet is “FMR_Manager.xlsm” and is Office 365 based.
Thanks again Charie and I look forward to your response.
Hi
Thanks for reaching out to the Community!
To ensure I understand, could you elaborate more on the issue? If you can phrase it in the “When A happens in Service X, B should happen in Service Y” format, that’ll help me make sure I give you the best suggestion possible.
Also, could you give me the exact name of the apps?
I want to ensure we’re on the same page so I can point you in the right direction.
Looking forward to your response!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.