Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
in Microsoft 365 by 2 2 3
edited by

I have a workbook, in Sheet 1 all actions, 

In Sheets 2 I go and store the results, 

I use some  Macros, this was the argument in the VBA code

With Sheets("Sheet2")

Now  I copied Sheets too in Google drive and shred the file  and would like to replace Sheet 2 with the file saved in the cloud (google drive)

Any suggestions to run VBA Macros on google drive?

1 Answer

1 like 0 dislike
by 54 119 241

Can I run Macros in Excel that hosted on Google Drive?

Unfortunately, Google Drive can't read the macros created in Excel.

Can I run Macros in Excel that hosted on Onedrive?

Unfortunately, You can't execute Macros in Excel that hosted on Onedrive.

Can I run Macros in Excel Online?

Unfortunately, You can't run or change Macros in Excel Online.

You cannot create or run macros with VBA in Excel for the office for the web, but you can open and edit VBA-enabled spreadsheets without removing (or corrupting) the VBA contained in the file. read more at Office for the web service description

If you don’t ask, the answer is always NO!