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/
|