stevebutler
Board Regular
- Joined
- Jul 5, 2005
- Messages
- 65
i want to save a copy of a sheet from Workbook A, into Workbook b.
I want Workbook B (with the new copied sheet) to be saved in the same folder as Workbook A
I thought i could use ThisWorkbook.path but i can't seem to get it to work.
also, i want to add the date to the end of the file name.
thanks in advance.
steve
I want Workbook B (with the new copied sheet) to be saved in the same folder as Workbook A
I thought i could use ThisWorkbook.path but i can't seem to get it to work.
also, i want to add the date to the end of the file name.
thanks in advance.
steve