How to save the workbook1 from workbook2
 

Hi
In my VBA application (Excelapplet.xls)i have a hidden sheet where
store some operation done throught the files i access fro
Excelapplet.xls.

I have common dialog control where we can open other XLS file fo
example "testing.xls" through "Excelapplet.xls"

I do some operation in this and when i save the current workboo
through VBA code Testing.xls alone is saved but the hidden sheet in th
Excelapplet.xls is not saved. How to acheived this


activeworkbook.save

is not working ..can you suggest some other method to do this

Thanks in advance

Venkatesh

--
Message posted from http://www.ExcelForum.com

How to save the workbook1 from workbook2
 

activeworkbook.save is not working

If you want to save a workbook that is not active you should save it by
name:

Workbooks("Excelapplet.xls").Save

--
Jim Rech
Excel MVP
"kvenku " wrote in message
...
| Hi
| In my VBA application (Excelapplet.xls)i have a hidden sheet where i
| store some operation done throught the files i access from
| Excelapplet.xls.
|
| I have common dialog control where we can open other XLS file for
| example "testing.xls" through "Excelapplet.xls"
|
| I do some operation in this and when i save the current workbook
| through VBA code Testing.xls alone is saved but the hidden sheet in the
| Excelapplet.xls is not saved. How to acheived this
|
|
| activeworkbook.save
|
| is not working ..can you suggest some other method to do this
|
| Thanks in advance
|
| Venkatesh.
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|