Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from workbook1 to workbook2 | Excel Worksheet Functions | |||
Copying Selected Rows From Workbook1 to WorkBook2 | Excel Discussion (Misc queries) | |||
Copying Selected Rows From Workbook1 to WorkBook2 | Excel Discussion (Misc queries) | |||
workbook1 data to workbook2 data | Excel Worksheet Functions | |||
autom update cells from Workbook1 to Workbook2 | Excel Discussion (Misc queries) |