Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a macro from one excel file to another excel file
Hello,
I am using an Excel 2007 file containing several command buttons I call this Excel file "AMProcessing". On one particular command button I want to run a particular vba coding (marco) in the "AMProcessing" workbook that needs to be used for another Excel file called "CCCardExpense". The vba coding will do what it needs to do for "CCCardExpense" file. I don't want to put the vba coding in the "CCCardExpense", because it is a download file "master". How can I use one Excel file to run the vba coding (macro) for another Excel file. I want to avoid puting a command button in the toolbar itself. If I have to open "CCCardExpense" file that's fine, but I want to have it close automaticlly after the macro is run. Any tips will be appreciated. Thank you in advance. Cheers, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel '00, 1st file has macros, how to stop macro in 2nd file? | Excel Discussion (Misc queries) | |||
how can i call macro in powerpoint file from excel file | Excel Programming | |||
Macro to save Excel file with date and time in the file name? | Excel Programming | |||
Creating a new excel file from an existing file using macro | Excel Programming | |||
VBA Macro to copy an column from one Excel file into another file | Excel Programming |