How to save the workbook1 from workbook2

K

kvenku

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
 
J

Jim Rech

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
| 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.
|
|
| ---
|
|
 
Top