In a Macro,
how would one prompt the user for a filename for saving ?
meaning, how would you simulate the action of selecting "Save As" ?

Also would it be possible to add VB code to the macro ?

For example, I want the input on a sheet to be a date; would it be possible to make a pop-up calendar form and have it working in Excel ?

thanks.

C

Use this for promting with the Save As dialog box: Application.Dialogs(xlDialogSaveAs).Show

Here's one way to creat a calendar: http://support.microsoft.com/default...&Product=xlw2K

Hope that helps,

Smitty

thx alot...
it should help out...

also, do u know the function that returns a boolean stating whether there is an existing file ?


i've been looking for it but i can't rembmer the name.
thx

Is this what you need?

thx,

Dir
was the function i was looking for..

Also, for the calendar thing,
i was looking for more something like a popup button based calendar;
where u can select a day and it will automatically return that day.

Rite now, i have a cell where I manually enter the date (eg. 1/29/2004).
I'd like to have a calendar pop up and then i can select a day and it will automaticlly populate that cell with the date.