Scott.Cobra
Member
Is there a limitation to pabbly that it can not connect to a macro enabled excel file??
-
Instructions to Ask a Question
For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.
We offer seven comprehensive applications designed to help you efficiently manage and grow your business:
- Pabbly Connect
- Pabbly Subscription Billing
- Pabbly Email Marketing
- Pabbly Form Builder
- Pabbly Email Verification
- Pabbly Hook
- Pabbly Chatflow
Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.
🚀 Exclusive Lifetime Offers 🚀
We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:
- 🔥 Pabbly Connect — Lifetime Access for $249 — View Offer
- 🔥 Pabbly Subscription Billing — Lifetime Access for $249 — View Offer
- 🔥 Pabbly Chatflow — Lifetime Access for $249 — View Offer
Make a one-time investment and enjoy the advantages of robust business management tools for years to come.
-
Excel can not fine macro enabled workbook??
- Thread starter Scott.Cobra
- Start date
P
Pabblymember11
Guest
Hey @Scott.Cobra
Could you please elaborate on your concern briefly with the help of a short recorded video? So that we can look into it and can guide you accordingly.
Could you please elaborate on your concern briefly with the help of a short recorded video? So that we can look into it and can guide you accordingly.
Scott.Cobra
Member
I am not sure a video will show it but here is a screen shot.
In the same one drive folder as Copper Chopper Data Logger.xlsx there is a file called Copper Chopper Data Logger.xlsm and nonmatter what I have done the xlsm file will not show up on this drop down.
I do have a secondary issue with this work flow also. When I made the workflow and press the save & Send test request I get the first line of date just like the video. However after waiting the 8 hours (24 actually) no additional data is transferred from my excel sheet to my google sheet.
In the same one drive folder as Copper Chopper Data Logger.xlsx there is a file called Copper Chopper Data Logger.xlsm and nonmatter what I have done the xlsm file will not show up on this drop down.
I do have a secondary issue with this work flow also. When I made the workflow and press the save & Send test request I get the first line of date just like the video. However after waiting the 8 hours (24 actually) no additional data is transferred from my excel sheet to my google sheet.
P
PabblyMember4
Guest
Hey @Scott.Cobra
Please allow us time till Monday to check the issue and we will keep you updated on the status of it.
Please allow us time till Monday to check the issue and we will keep you updated on the status of it.
P
Pabblymember11
Guest
Hey @Scott.Cobra
Since the MS Excel trigger event only list the workbook which is of xlsx type.
So, as a solution, we would recommend using the "Search File in Drive" action step once to receive the Id of the workflow from your One Drive and that WorkBook Id you can pass it on the Trigger events' workbook field.
Since the MS Excel trigger event only list the workbook which is of xlsx type.
So, as a solution, we would recommend using the "Search File in Drive" action step once to receive the Id of the workflow from your One Drive and that WorkBook Id you can pass it on the Trigger events' workbook field.
I Was having this issue as well. This was able to help me find it. I was able to map it. but I had that on the final save and test.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Bad Request</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Bad Request - Invalid URL</h2>
<hr><p>HTTP Error 400. The request URL is invalid.</p>
</BODY></HTML>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Bad Request</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Bad Request - Invalid URL</h2>
<hr><p>HTTP Error 400. The request URL is invalid.</p>
</BODY></HTML>
P
Pabblymember11
Guest
Hey @dperron01
It seems like you might have made some changes in your MS Excel worksheet and because of that it is causing such an issue.
Kindly reconnect it once and then configure the action step accordingly.
It seems like you might have made some changes in your MS Excel worksheet and because of that it is causing such an issue.
Kindly reconnect it once and then configure the action step accordingly.
