I have uploaded an xlsm file to google drive. When opening it uses google sheets, and when downloading it converts it to xlsx (no vba modules). Is there another way to get my code back? (The original file on my computer is gone).
1 Answers
Apologies, self answer.
In Google Drive Settings there is a toggle box to 'Convert uploaded files to google docs editor format'. This was ticked and so I lost the code as soon as I uploaded.
I have since tested it and without that tickbox ticked, the file remains in xlsm format, even if you open it in google sheets.
Also that tickbox is not ticked by default, so you really have to put some effort in to lose all of your code like I did.
Related