|
Advice needed: "Portable" macros?
So on roughly a weekly basis a couple employees create an export of some data to a new excel spreadsheet. I then have some macros that they need to run against this new spreadsheet every week. What would be the best way to give them access to these macros since the spreadsheets theyre creating from these exports obvisouly wont have them? Oh yea.. and these employees arent the most "technically inclined", so the easier the better. Ive been pondering this for half the day now and I know it cant be that difficult of a thing to do.... Thanks! -- durex ------------------------------------------------------------------------ durex's Profile: http://www.excelforum.com/member.php...o&userid=27857 View this thread: http://www.excelforum.com/showthread...hreadid=473945 |
Advice needed: "Portable" macros?
Put the macros in each of their Personal.xls workbooks. Then for
convenience, create a menu item on each of their Excel applications that will run the macro. I did this for my boss so he would quit sending me his stuff to process with my macro. If you need any guidance in any way, post back. Of course you will need access to their computers for a short while to do this for them. Mike F "durex" wrote in message ... So on roughly a weekly basis a couple employees create an export of some data to a new excel spreadsheet. I then have some macros that they need to run against this new spreadsheet every week. What would be the best way to give them access to these macros since the spreadsheets theyre creating from these exports obvisouly wont have them? Oh yea.. and these employees arent the most "technically inclined", so the easier the better. Ive been pondering this for half the day now and I know it cant be that difficult of a thing to do.... Thanks! -- durex ------------------------------------------------------------------------ durex's Profile: http://www.excelforum.com/member.php...o&userid=27857 View this thread: http://www.excelforum.com/showthread...hreadid=473945 |
Advice needed: "Portable" macros?
Put your macro's in an .xla add-in.
Plenty of good information about this available. This may be good start: http://www.fontstuff.com/vba/vbatut03.htm RBS "durex" wrote in message ... So on roughly a weekly basis a couple employees create an export of some data to a new excel spreadsheet. I then have some macros that they need to run against this new spreadsheet every week. What would be the best way to give them access to these macros since the spreadsheets theyre creating from these exports obvisouly wont have them? Oh yea.. and these employees arent the most "technically inclined", so the easier the better. Ive been pondering this for half the day now and I know it cant be that difficult of a thing to do.... Thanks! -- durex ------------------------------------------------------------------------ durex's Profile: http://www.excelforum.com/member.php...o&userid=27857 View this thread: http://www.excelforum.com/showthread...hreadid=473945 |
| All times are GMT +1. The time now is 05:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com