Hi Aj8,
Excel 2016 also makes it easy to acquire data from a variety of different data sources, including Microsoft Access database files, web pages on the Internet, text files, and other data sources such as database tables on SQL Servers and Analysis Services, XML data files, and data tables from online connections to Microsoft Windows Azure DataMarket and OData Data feeds.
A brief search on the Microsoft support site led to a page that suggested (to my reading) the Developer tab would be the place to look for this, if it exists. I have some doubt concerning that, as any reference to XML, other than saving files in an XML format, was in articles that did not include Excel 2016 for Mac in the 'applies to' list.
Should a more knowledgable answer not appear here, I'd suggest you might have a better chance at the Microsoft Community site. (Although it appears MS has folded the Office for Mac community into the larger 'Office' community.)
Regards,
Barry
Dec 5, 2016 11:51 PM
In some situations, you may want to modify the Excel Ribbon automatically when a workbook or add-in is opened. Doing so makes it easy for the user to access your macro. It also eliminates the need for the user to modify the Ribbon manually by using the Excel Options dialog box.
You can make automatic changes to the Ribbon with Excel 2007 and later versions, but it’s not a simple task. Modifying the Ribbon involves writing XML code in a text editor, copying that XML file into the workbook file, editing a bunch of XML files (which also are stashed away inside the Excel file, which in reality is nothing more than a zipped container of individual files), and then writing VBA procedures to handle the clicking of the controls you put in the XML file.
Fortunately, software is available to assist you with customizing the Ribbon — but you still need to be on familiar terms with XML.
Follow these steps exactly:
- Create a new Excel workbook.
- Save the workbook, and name it ribbon modification.xlsm.
- Close the workbook.
- Launch the Custom UI Editor for Microsoft Office.If you don’t have this software, you need to find it and install it. Refer to the nearby sidebar “Get the software.”
- In the Custom UI Editor, choose File → Open and find the workbook you saved in Step 2.
- Choose Insert → Office 2007 Custom UI Part.Choose this command even if you’re using Excel 2010, Excel 2013, or Excel 2016.
- Type the following code in the code panel (named customUI.xml) displayed in the Custom UI Editor:
- Click the Validate button on the toolbar.If the code has any syntax errors, you get a message that describes the problem. If any errors are identified, you must correct them.
- Click the Generate Callback button.The Custom UI Editor creates a VBA Sub procedure that is executed when the button is clicked. This procedure is not actually inserted into the workbook, so you need to copy it for later use (or memorize it, if you have a good memory).The VBA callback procedure that is executed by clicking the Ribbon button.
- Go back to the customUI.xml module and choose File → Save (or click the Save icon on the toolbar).
- Close the file by choosing the File → Close command.
- Open the workbook in Excel, and click the Home tab.3 three 2012 tamil movie hindi dubbed. You should see the new Ribbon group and Ribbon button. But it doesn’t work yet.
- Press Alt+F11 to activate the VBE.
- Insert a new VBA module; paste (or type) the callback procedure that was generated in Step 9; and add a MsgBox statement, so you’ll know whether the procedure is actually being executed.The procedure is
- Press Alt+F11 to jump back to Excel, and click the new button on the Ribbon.Sylenth1 price. If all goes well, you see the MsgBox.Proof that adding a new Ribbon command using XML is actually possible.
In the Custom UI Editor, when you choose Insert → Office 2007 Custom UI Part, you insert a UI part for Excel 2007. The Custom UI Editor also has an option to insert a UI part for Excel 2010 (the software I used has not been updated for Office 2013 or Office 2016). For maximum compatibility, use the Excel 2007 Custom UI Part.
You probably realize that modifying the Ribbon using XML is not exactly intuitive. Even with a good tool to help (such as the Custom UI Editor), you still need to understand XML. If that sounds appealing to you, search the web or find a book devoted exclusively to customizing the Ribbon interface in Microsoft Office.