|
|
|
|
#1
05-20-2015, 11:16 PM
|
|||
|
|||
I think the only issue is the 3rd line of code. The workbook name does not include the file extension at least not in my experience. Change it to
Code:
If ThisWorkbook.Name = "Test" Then Thanks 
|
|
| Tags |
| excel 2010, vba excel |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 VBS saveas API behaviour is different from Menu saveas
|
Ahmed AbuZekry | Word VBA | 2 | 03-23-2015 02:14 AM |
|
SaveAs docm file from template
|
ptmuldoon | Word VBA | 7 | 03-09-2015 05:38 PM |
|
I need an index file containing the names of all the worksheets in a workbook.
|
retiredstuart | Excel | 3 | 09-12-2014 06:26 AM |
| the saveas macro in excel 2010 is not transferring the macros to the new workbook | missmr28 | Excel Programming | 3 | 06-20-2012 05:30 AM |
|
Read text Report file with VBA and write parsed fields to Excel workbook
|
tpcervelo | Excel Programming | 1 | 01-05-2012 10:14 PM |
Windows 8 
Office 2003
Hybrid Mode