Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save Macro in excel to be used on schedule file
Hi All
I have a ? about macros Our scheduler emails a new schedule each day to several people in our facility I want to use a macro on my machine to calculate the % of utilization. How can I stor this macro in excel so that I can use it when I get a new schedule. Normally I would expect to see the macro with the schedule file but I want it to be on my computer so I can use even though the scheduler does not have this macro attached to the file she sends. Any help on how to do this will be appreciated Thanks -- crunchnin numbers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save Macro in excel to be used on schedule file
hi
you could put the macro in a personal.xls workbook and save the personal.xls to the xlstart folder. the personal.xls file would open hidden and all macro in the personal.xls file would be available to run on any file at any time. regards FSt1 "belvy123" wrote: Hi All I have a ? about macros Our scheduler emails a new schedule each day to several people in our facility I want to use a macro on my machine to calculate the % of utilization. How can I stor this macro in excel so that I can use it when I get a new schedule. Normally I would expect to see the macro with the schedule file but I want it to be on my computer so I can use even though the scheduler does not have this macro attached to the file she sends. Any help on how to do this will be appreciated Thanks -- crunchnin numbers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
internet connection via excel macro at timed intervels & save data to excel file. | Excel Worksheet Functions | |||
Allow a macro to save over another file | Excel Discussion (Misc queries) | |||
Macro Save File (Unique file name) | Excel Worksheet Functions | |||
Macro to save a file as | Excel Discussion (Misc queries) | |||
Macro to save a file as a PDF | Excel Discussion (Misc queries) |