PDA

View Full Version : Save copy.



nickm687
04-10-2007, 07:22 AM
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

lucas
04-10-2007, 07:41 AM
If you copied it....the macro should be in the original too.

mdmackillop
04-10-2007, 11:34 AM
To make a copy of your workbook while keeping it open use SaveCopyAs