View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kvenku[_26_] kvenku[_26_] is offline
external usenet poster
 
Posts: 1
Default 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