Hi guys,
I am having a bit of trouble with a macro i am trying to write.
I need to save a copy of a workbook (in the same directory as the active workbook) and after this i need to run one of the macros in the copied wb.
Any help is appreciated.
Regards
Nick
If you copied it....the macro should be in the original too.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
To make a copy of your workbook while keeping it open use SaveCopyAs
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote
