Thanksamillion
New Member
- Joined
- Mar 5, 2012
- Messages
- 10
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o> </o>
<o></o>
I am trying to create a custom Ribbon Tab for Excel, for the purpose of storing all my Macros. I have created the XML code for the ribbon modifications, saved in a text file. Both this text file and the workbook containing my macros are saved in a SharePoint folder. <o></o>
<o></o>
I need to build a macro that takes the Excel file, .xlsm, converts it into a Excel Add-in, .xlam, and stores the Add-in in a file path location on the hard drive. Next it needs to take the Text document stored in the same location and copy it into two separate Folder locations on the hard drive. I keep getting stuck creating the wrong VBA syntax to do this. Any Help would be greatly appreciated. <o></o>
<o></o>
-Thanksamillion<o></o>
fficeffice" /><o></o><o
> </o><o
></o>I am trying to create a custom Ribbon Tab for Excel, for the purpose of storing all my Macros. I have created the XML code for the ribbon modifications, saved in a text file. Both this text file and the workbook containing my macros are saved in a SharePoint folder. <o
></o><o
></o>I need to build a macro that takes the Excel file, .xlsm, converts it into a Excel Add-in, .xlam, and stores the Add-in in a file path location on the hard drive. Next it needs to take the Text document stored in the same location and copy it into two separate Folder locations on the hard drive. I keep getting stuck creating the wrong VBA syntax to do this. Any Help would be greatly appreciated. <o
></o><o
></o>-Thanksamillion<o
></o>
