| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I best "scrub" a wkbk of "phantom macros"? | Excel Discussion (Misc queries) | |||
| "excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
| Problem- Recording macros for "file save" and "File open" | Excel Programming | |||
Hybrid Mode
