How to save a macro (.bas) into Excel 2013, roaming profile

Hello,

I am trying to import a macro that was exported as a .bas file, into Excel 2013.  Our company uses Citrix so there is no "C" drive to save the macro into the XLSTART folder as I've read.  I can add the macro when I first open Excel 2013 by using the Developer tab/VBA to import it, but the next time I open Excel 2013, it's no longer there. It doesn't give me any option to save the macro when I'm in VBA.  How do I, or where can I save this macro so I don't have to import it each time I open Excel? 

Thanks!

August 19th, 2015 9:55am

Put it in your Personal.xlsb file, then press the save icon at the top of the VBE window.

If you don't have a Personal.xlsb, record a macro and choose the option to Store macro in   Personal Macro Workbook, and Excel will create the file for you.

Free Windows Admin Tool Kit Click here and download it now
August 19th, 2015 11:26am

Put it in your Personal.xlsb file, then press the save icon at the top of the VBE window.

If you don't have a Personal.xlsb, record a macro and choose the option to Store macro in   Personal Macro Workbook, and Excel will create the file for you.

August 19th, 2015 3:24pm

Hi klinem,

As Bernie Deitrick said you can store you macros in Personal.xlsb Workbook. Thats a hidden workbook stored on your computer, which opens every time you open Excel. But this feature isnt available in Office on a Windows RT PC.

I suggest you refer to this article about how to work with Personal.xlsb Workbook:
https://support.office.com/en-ca/article/Create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su

Free Windows Admin Tool Kit Click here and download it now
August 19th, 2015 9:45pm

Thank You very much.  I was able to create the Personal.xlsb and can now import, create and save macros.  I appreciate your help!

September 1st, 2015 6:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics