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?

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?

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?

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?