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? Hi klinem, As Bernie Deitrick said you can store you macros in Personal.xlsb Workbook. That’s a hidden workbook stored on your computer, which opens every time you open Excel.
How To Import A .bas File In Excel For Mac 2016
But this feature isn’t available in Office on a Windows RT PC. I suggest you refer to this article about how to work with Personal.xlsb Workbook: Hope it's helpful. Regards, Emi Zhang TechNet Community Support It's recommended to download and install, which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact.
I wrote some macro's in excel for mac 2011 and/or regular excel, and saved them as.bas files. However company policy pushed excel for mac 2016, and since then I can no longer import previously written VBA code, saved as.bas file, into my workbook.
To import a BAS file and add it to a workbook project, select the Developer tab and click on the Visual Basic button to open the VB editor. On the VB editor, click File and then click Import File to display the Import File dialog box. Navigate to the appropriate folder and select the file to be imported. You can use it to import modules/userforms to other Excel files or to update the code. The Export macro will export every module(.bas),class module(.cls).
Hi klinem, As Bernie Deitrick said you can store you macros in Personal.xlsb Workbook. That’s a hidden workbook stored on your computer, which opens every time you open Excel. But this feature isn’t available in Office on a Windows RT PC.
I suggest you refer to this article about how to work with Personal.xlsb Workbook: Hope it's helpful. Regards, Emi Zhang TechNet Community Support It's recommended to download and install, which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs. Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact.