How save active workbook w/o knowing name

[John]

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?

[Gary Keramidas]

that works for me

--


Gary


"John" <John@discussions.microsoft.com> wrote in message
news:BAFF90F7-ED9A-462C-96E7-2B536E16AEC6@microsoft.com...
>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?

[Norman Jones]

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" <John@discussions.microsoft.com> wrote in message
news:BAFF90F7-ED9A-462C-96E7-2B536E16AEC6@microsoft.com...
>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?

[Tim Williams]

> 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" <John@discussions.microsoft.com> wrote in message
news:BAFF90F7-ED9A-462C-96E7-2B536E16AEC6@microsoft.com...
> 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?