Hi,
My problem is as follows.
I have written a dozen macros to compile a multi-sheet workbook for a facility set up which interacts with simulation packages and database SQL's.
I need to export a single sheet as text file to import into a machine.
The problem with using " Sheet1.SaveAs "C:\filename.txt", <format>"
is that it saves the whole book with that new name, and i lose the new compiled data in the other sheets.
I want to export that single sheet in text format, without compromising the original workbook integrity.
One way i was able to come around this, is open a new blank workbook, copy the sheet over, and then save it from there and then close the new workbook!!!! but i'm sure there is a faster route.
Thanks in advance guys, any tips would be highly appreciated.
Salman
My problem is as follows.
I have written a dozen macros to compile a multi-sheet workbook for a facility set up which interacts with simulation packages and database SQL's.
I need to export a single sheet as text file to import into a machine.
The problem with using " Sheet1.SaveAs "C:\filename.txt", <format>"
is that it saves the whole book with that new name, and i lose the new compiled data in the other sheets.
I want to export that single sheet in text format, without compromising the original workbook integrity.
One way i was able to come around this, is open a new blank workbook, copy the sheet over, and then save it from there and then close the new workbook!!!! but i'm sure there is a faster route.
Thanks in advance guys, any tips would be highly appreciated.
Salman
