Tips • To save the spreadsheet with the macro you imported, click 'File' and 'Save As' to open the Save As dialog window. Click the 'Save As Type' drop-down menu and select “Excel Macro-Enabled Workbook (*.xlsm)” as the document file type before clicking 'Save.' You must save Excel documents in this format if they contain macros that you want to run later. • Microsoft suggests returning to the Trust Center window and clicking the “Enable all macros (not recommended, potentially dangerous code can run)” radio button to unselect it and after importing your macro code. ![]() Doing this will help protect your computer by preventing macros from running automatically. This could happen, for instance, if you download a spreadsheet from an unknown source that contains a malicious Excel macro. • You can also share a macro by emailing it to others or posting it on the Web. People can follow the steps you used to import the macro code into their spreadsheets. ![]() Mar 02, 2018 I have Office 365 for Mac and I'm trying to import an XML file, but can figure out how to do it. On the MS support website it says: If you're using Excel with an Office 365 subscription, click Data > Get Data > From File > From XML. But I don't have this option. Under Data I have: From HTML, From Text and New Database Query.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |