Cannot create, save an excel macro enabled workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2231368%22%20slang%3D%22en-US%22%3ECannot%20create%2C%20save%20an%20excel%20macro%20enabled%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2231368%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20new%20installation%20of%20Office%20365%20on%20a%20Windows%2010%20desktop.%20I%20have%20tried%20to%20copy%20some%20Excel%20macro-enabled%20workbooks%20from%20my%20laptop%20to%20my%20desktop.%20Every%20which%20way.%20I%20can%20manually%20create%20a%20new%20.xlsm%20by%20adding%20some%20VBA%20and%20saving%20as%20.xlsm%2C%20but%20I%20cannot%20download%20the%20.xlsm%20(OneDrive%20or%20Google%20Drive)%20or%20import%20project%20files%20(.bas%2C%20.frm%2C%20etc.)%20to%20a%20.xlsx%20and%20then%20save%20as%20.xlsm.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20had%20this%20problem%20and%20found%20a%20solution%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerry%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2235587%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20create%2C%20save%20an%20excel%20macro%20enabled%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2235587%22%20slang%3D%22en-US%22%3ECan%20you%20be%20more%20specific%20please%2C%20what%20exactly%20happens%20(or%20fails)%20if%20you%3A%3CBR%20%2F%3E-%20Open%20an%20xlsm%20file%20from%20OneDrive%3CBR%20%2F%3E-%20Try%20to%20import%20a%20bas%20file%20into%20a%20VBA%20project%3CBR%20%2F%3E-%20Other%20things%20that%20might%20not%20work%3C%2FLINGO-BODY%3E
New Contributor

I have a new installation of Office 365 on a Windows 10 desktop. I have tried to copy some Excel macro-enabled workbooks from my laptop to my desktop. Every which way. I can manually create a new .xlsm by adding some VBA and saving as .xlsm, but I cannot download the .xlsm (OneDrive or Google Drive) or import project files (.bas, .frm, etc.) to a .xlsx and then save as .xlsm.

 

Has anyone had this problem and found a solution?

 

Perry

3 Replies
Can you be more specific please, what exactly happens (or fails) if you:
- Open an xlsm file from OneDrive
- Try to import a bas file into a VBA project
- Other things that might not work

@Jan Karel Pieterse 

My latest attempt was to copy and paste the code in a .bas file to notepad and then copy into a new module. And still, when I save, the .xlsm disappears and Excel is rendered useless until a restart.

Does it happen with just any VBA, or with particular code?