Excel file with macro in Google Drive
Bailly
-
Anonymous user -
Anonymous user -
Hello,
I would like to share an
Excel file on Google Drive. It is a file containing a macro that runs when the file is saved, written in the workbook with the BeforeSave option.
Once in Google Drive, the file opens with Google Sheets and the code is gone.
So, my question is: How can we enable and run an Excel macro from a shared file?
Thank you.
I would like to share an
Excel file on Google Drive. It is a file containing a macro that runs when the file is saved, written in the workbook with the BeforeSave option.
Once in Google Drive, the file opens with Google Sheets and the code is gone.
So, my question is: How can we enable and run an Excel macro from a shared file?
Thank you.
3 réponses
Hello
Unfortunately, the macros included in Excel files rely on VBA (Visual Basic for Application, owned by Microsoft) and are not supported by Google.
See you later
--
If this answer helped you: a little thank you is nice. If it's resolved: the green button at the top is better ;-)
Let him who has never opened a user manual throw the first mouse.
Unfortunately, the macros included in Excel files rely on VBA (Visual Basic for Application, owned by Microsoft) and are not supported by Google.
See you later
--
If this answer helped you: a little thank you is nice. If it's resolved: the green button at the top is better ;-)
Let him who has never opened a user manual throw the first mouse.
Thank you for this information which, although it doesn't solve my problem, at least stops me from stubbornly insisting on the subject :)
Hello
Yes, everyone has their own sauce...
The Microsoft language is VBA and Google’s is GAS (Google Application Script).
Google offers a VBA -> GAS converter but it’s not exactly what you're looking for...
Oops! But it’s reserved for Google’s paid access since it's in the Google Workspace Marketplace
Cheers!
If this answer helped you: a little thank you is nice. If it’s resolved: the green button at the top is better ;-)
Let him who has never opened a user manual throw the first mouse.
Yes, everyone has their own sauce...
The Microsoft language is VBA and Google’s is GAS (Google Application Script).
Google offers a VBA -> GAS converter but it’s not exactly what you're looking for...
Oops! But it’s reserved for Google’s paid access since it's in the Google Workspace Marketplace
Cheers!
If this answer helped you: a little thank you is nice. If it’s resolved: the green button at the top is better ;-)
Let him who has never opened a user manual throw the first mouse.