Excel: Save sheet seperatly
I have a question about excel.
Is it possible to save the sheets in the workbook seperat?
When I save the Excel dokument i want both the workbook and the sheets to be saved seperat.
So when I open the workbook all sheets are included but when i choose to open a sheet only that sheet is opened.
I got a screendump here to show what I mean.
http://img215.imageshack.us/img215/9079/excelbd2.jpg
If you want I can describe better....
Re: Excel: Save sheet seperatly
you can save a sheet using
VB Code:
Sheets("sheet1").SaveAs ' need to specify filename and fileformat etc
Re: Excel: Save sheet seperatly
Quote:
Originally Posted by westconn1
you can save a sheet using
VB Code:
Sheets("sheet1").SaveAs ' need to specify filename and fileformat etc
I'll try it.
Are sheet still linked too the workbook when I save the sheet?
Re: Excel: Save sheet seperatly
Could you give me an example of how i can use it?
It would be very kind of you..