Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE A SHEET AS A BOOK, CLOSE IT, CONTINUE VBA CODE - XCL 2003
The Subject pretty much describes my situation. There are 5 sheets in
'ThisWorkbook'; I want to save one of them as an .xls file (replacing an existing file with the same name; preferably this newly-saved file will have zero VBA code included), close it, continue with my Code. (Later in my Code, I want to open this VBA-saved .xls file.) Previous attempts: 1) using a 'Sheets("WORKPLACE").Copy' stmt; this did not result in consistent stable results; 2) using AdvancedFilter to copy the Sheet (omitting the CriteriaRange); I could not generate an error-free stmt. Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'BeforeClose' code problems:book won't close if more than one book is open | Excel Programming | |||
save Changes and close book | Excel Programming | |||
Open book, copy and paste from sheet, and then close.... | Excel Programming | |||
Create new book..paste data..save..close | Excel Programming | |||
Open book, check for macros, close book | Excel Programming |