LAST SAVE DATE/TIME

[Malcolm Austin]

Hi,
I'm using Excel 2000 and have imported a macro from this forum to
show the last date and time of my save. This was:-

Sub Button11_Click()

Sheets("Sheet1").Range("A1").Value = Format(Now(), "mmmm dd, yyyy - hh:mm")
End Sub


This works to update the value in A1 fine. But I'd like to be able to pick
where to save the file to before the macro does its job.

My macro recording is only via the mouse, by the way....

Can anyone help please.

Many thanks, Malcolm...

 

[Bob Phillips]

Malcolm,

Take a look at the GetSaveAsFilename method. It navigates through folders
and returns the selected file path and name

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Malcolm Austin]

Hi Bob,
well you made me think as my "basic" skills are very low.
Went into VB from my worksheet and ran a help search. With the aid of your
"GetSave" advice, I cut and pasted the answer in help straight to my macro.

Happy to say it works fine now.

Many thanks.

Malcolm...

 

[Bob Phillips]

Excellent Malcolm. It always helps to work it out yourself.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)