Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
running an excel program
A colleague wrote a program in excel that runs my data and does a good job.
(I think it's a macro). Problem is - I'd like to run this program over night - incrementing to the next file that needs to be run. To run the file, I open an excel file and hit a button he labeled "Process data". example: file1 runs, when it's finished, I'd like the program to go to the next file and run it. And so on... Thanks for any help! Al. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
running an excel program
You need to post the macro.
1) From worksheet press ALT-F11 2) On the right hand side of window you will see the project window. Macro can be located in three places. You need to double click on the Project window in the correct location to find all the macros Place to find macros 1) Thisworkbook 2) On any of the sheets in your workbook. These will have the same name as the sheet name 3) In a module. Press the plus sign next to module and the double click on each of the modules. There may also be macros on any forms that may be in the project. "Al" wrote: A colleague wrote a program in excel that runs my data and does a good job. (I think it's a macro). Problem is - I'd like to run this program over night - incrementing to the next file that needs to be run. To run the file, I open an excel file and hit a button he labeled "Process data". example: file1 runs, when it's finished, I'd like the program to go to the next file and run it. And so on... Thanks for any help! Al. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running another program out of excel | Excel Programming | |||
Excel VBA Macro stops running when another program is activated | Excel Programming | |||
how do i disable "running virus scan" in excel program when opened | New Users to Excel | |||
Program calling up Excel - Not running Macro | Excel Programming | |||
A program running on different Excel Versions | Excel Programming |