Re: Saving current workbook
- From: "Tom Ogilvy" <twogilvy@xxxxxxx>
- Date: Sat, 31 Dec 2005 14:01:01 -0500
Thisworkbook.Save
or
ActiveWorkbook.Save
--
Regards,
Tom Ogilvy
"ccarmock" <ccarmock.20wsoy_1136040301.7008@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:ccarmock.20wsoy_1136040301.7008@xxxxxxxxxxxxxxxxxxxxxxxx
>
> I have an Excel spread*** that uses VB to watch for entries in certain
> cells. At times an 'aduit' feature is triggered to write entries to a
> protected ***.
>
> 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 work*** 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?action=getinfo&userid=27670
> View this thread: http://www.excelforum.com/showthread.php?threadid=497154
>
.
- References:
- Saving current workbook
- From: ccarmock
- Saving current workbook
- Prev by Date: Re: how to create a new folder through a macro ??
- Next by Date: Re: paste to word document and save
- Previous by thread: Saving current workbook
- Next by thread: how to create a new folder through a macro ??
- Index(es):
