jim_1234567890
asked on
Creating an install script for a new button & macro
I have created three different macros - one for Word, Excel & Outlook.
I have created a specialized button to launch each one of these macros in the respective application.
In word it is in the normal.dot and in Excel it is in the personal.xls.
I wanted to add these macros and the launching button to all the computers (200+) - they are all over the place and some not connected via the network.
So I wanted to create a little script or program that would install these macros into there word, excel & outlook with out destroying what they may already have there. This way I could go around to each computer and double click on the setup/install file and presto the macros and buttons are set up. Currently the best way I have is to go to each computer, open each application and copy and paste the code, save, setup the button to active that macro, save, etc. This takes time and leaves room for human errors.
What is the best way to create an install script for macros across the various applications? I would assume a windows script or something to that effect. Unlike word and excel I do not see a 'record new macro' option for windows.
What ideas you have?
I have created a specialized button to launch each one of these macros in the respective application.
In word it is in the normal.dot and in Excel it is in the personal.xls.
I wanted to add these macros and the launching button to all the computers (200+) - they are all over the place and some not connected via the network.
So I wanted to create a little script or program that would install these macros into there word, excel & outlook with out destroying what they may already have there. This way I could go around to each computer and double click on the setup/install file and presto the macros and buttons are set up. Currently the best way I have is to go to each computer, open each application and copy and paste the code, save, setup the button to active that macro, save, etc. This takes time and leaves room for human errors.
What is the best way to create an install script for macros across the various applications? I would assume a windows script or something to that effect. Unlike word and excel I do not see a 'record new macro' option for windows.
What ideas you have?
jim_1234567890,
Speaking as Office Page Editor, it's not be so much a question of no one being interested as it is that most of the experts participating in the Office TA tend to be stronger in one application than the others. To provide a good answer for all three applications requires an unusual combination of strengths. You would probably have better luck posting the same question in each of the three sub-categories. If you want to take this approach, then post a zero point question in Community Support https://www.experts-exchange.com/Community_Support/ referencing this question and asking for a refund.
At first glance, what you are asking for comes dangerously close to behaving like a virus. Rather than fight all the self-defense mechanisms that may be in place, it might be better to send an e-mail to each of the users with files that they need to open to do the installation.
Speaking as an Excel expert, a related question was posted here: https://www.experts-exchange.com/questions/20672242/Embed-an-Excel-file-in-another-Excel-file-OR-Self-Destruct-Macro.html
Excel workbooks stored in the XLStart folder will automatically open when Excel launches. So rather than mess with someone's Personal.xls, you could create a new workbook with a unique name (e.g. jim_1234567890 macros.xls) which is saved with a hidden window. It would then open with Excel, but not be visible. And all its macros and functions would be available for use. In Excel 97, the XLStart folder is a subdirectory in the Office folder in Program Files. In Excel 2000 and later, the XLStart directory is located in C:\Documents and Settings\your name\Application Data\Microsoft\Excel\XLSta
Nice discussion on the same general topic for Word in this PAQ: https://www.experts-exchange.com/questions/20034287/How-do-make-styles-Global-without-using-Normal-dot.html
Brad
Speaking as Office Page Editor, it's not be so much a question of no one being interested as it is that most of the experts participating in the Office TA tend to be stronger in one application than the others. To provide a good answer for all three applications requires an unusual combination of strengths. You would probably have better luck posting the same question in each of the three sub-categories. If you want to take this approach, then post a zero point question in Community Support https://www.experts-exchange.com/Community_Support/ referencing this question and asking for a refund.
At first glance, what you are asking for comes dangerously close to behaving like a virus. Rather than fight all the self-defense mechanisms that may be in place, it might be better to send an e-mail to each of the users with files that they need to open to do the installation.
Speaking as an Excel expert, a related question was posted here: https://www.experts-exchange.com/questions/20672242/Embed-an-Excel-file-in-another-Excel-file-OR-Self-Destruct-Macro.html
Excel workbooks stored in the XLStart folder will automatically open when Excel launches. So rather than mess with someone's Personal.xls, you could create a new workbook with a unique name (e.g. jim_1234567890 macros.xls) which is saved with a hidden window. It would then open with Excel, but not be visible. And all its macros and functions would be available for use. In Excel 97, the XLStart folder is a subdirectory in the Office folder in Program Files. In Excel 2000 and later, the XLStart directory is located in C:\Documents and Settings\your name\Application Data\Microsoft\Excel\XLSta
Nice discussion on the same general topic for Word in this PAQ: https://www.experts-exchange.com/questions/20034287/How-do-make-styles-Global-without-using-Normal-dot.html
Brad
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi jim_1234567890,
Not into writing viruses myself, but wanting to provide an easy way to install a button in Outlook for my users, I'd love to see your code. Would you mind sharing it with me?
<<e-mail address removed per EE policy--byundt, Microsoft Office Zone Advisor>>
Thanks!
Taco
Not into writing viruses myself, but wanting to provide an easy way to install a button in Outlook for my users, I'd love to see your code. Would you mind sharing it with me?
<<e-mail address removed per EE policy--byundt, Microsoft Office Zone Advisor>>
Thanks!
Taco
ASKER
No one interested.
I will up the points a bit.
I will restate what I am looking for:
A method to automatically install new macros into Word, excel, & outlook with out affecting any other macros installed. Add a custom button to launch each of the macros in the respective application. I wanted this all in one install package to make distribution easy.