| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How save active workbook w/o knowing name
I tried "ActiveWorkbook.Save", but I don't think this saved the workbook. I
have a bunch of macros that update data on various sheets in various workbooks and want to save the entire workbook at the end of each macro without knowing which workbook the macro is running in. What is the correct command? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How save active workbook w/o knowing name
that works for me
-- Gary "John" wrote in message ... I tried "ActiveWorkbook.Save", but I don't think this saved the workbook. I have a bunch of macros that update data on various sheets in various workbooks and want to save the entire workbook at the end of each macro without knowing which workbook the macro is running in. What is the correct command? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How save active workbook w/o knowing name
Hi John,
If your intention is to save the active workbook, then your code: ActiveWorkbook.Save is correct. I tried "ActiveWorkbook.Save", but I don't think this saved the workbook Are you sure that the active workbook was the one that you expected? --- Regards, Norman "John" wrote in message ... I tried "ActiveWorkbook.Save", but I don't think this saved the workbook. I have a bunch of macros that update data on various sheets in various workbooks and want to save the entire workbook at the end of each macro without knowing which workbook the macro is running in. What is the correct command? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How save active workbook w/o knowing name
without knowing which workbook the macro is running in
It's not completely clear from your post whether the macros and data are located in the same workbooks. Maybe ThisWorkbook.Save is what you need (if your macro is operating on data in the same workbook as the macro location). Tim -- Tim Williams Palo Alto, CA "John" wrote in message ... I tried "ActiveWorkbook.Save", but I don't think this saved the workbook. I have a bunch of macros that update data on various sheets in various workbooks and want to save the entire workbook at the end of each macro without knowing which workbook the macro is running in. What is the correct command? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to save a workbook to an active Web Page? | Excel Discussion (Misc queries) | |||
| Share Workbook - Knowing who is in it. | Excel Discussion (Misc queries) | |||
| Macro: Exit active workbook without save? | Excel Worksheet Functions | |||
| opening a workbook without knowing its exact location | Excel Programming | |||
| Preventing opening workbook inside active workbook. | Excel Programming | |||
Linear Mode
