Thread: Saving current workbook

I have an Excel spreadsheet that uses VB to watch for entries in certain cells. At times an 'aduit' feature is triggered to write entries to a protected sheet.

There are a couple of these I woudl like to ensure get saved without further intervention.

I see there is a SaveAs function that could do this - but is there the equivalent to simply save the current worksheet back as the same filename that was used to open it? Ie the equivalent of clicking the Save Disc icon.

Regards
Clive

Thisworkbook.Save

or

ActiveWorkbook.Save

--
Regards,
Tom Ogilvy

"ccarmock" <ccarmock.20wsoy_1136040301.7008@excelforum-nospam.com> wrote in
message news:ccarmock.20wsoy_1136040301.7008@excelforum-nospam.com...
>
> I have an Excel spreadsheet that uses VB to watch for entries in certain
> cells. At times an 'aduit' feature is triggered to write entries to a
> protected sheet.
>
> There are a couple of these I woudl like to ensure get saved without
> further intervention.
>
> I see there is a SaveAs function that could do this - but is there the
> equivalent to simply save the current worksheet back as the same
> filename that was used to open it? Ie the equivalent of clicking the
> Save Disc icon.
>
> Regards
> Clive
>
>
> --
> ccarmock
> ------------------------------------------------------------------------
> ccarmock's Profile:
http://www.excelforum.com/member.php...o&userid=27670
> View this thread: http://www.excelforum.com/showthread...hreadid=497154
>

Tom,

Many thansk - that worked perfectly.

Clive