var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Prompting for Save location In Macro
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 ?
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,
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.
Is this what you need?
Private Function FileExists(fname) As Boolean
FileExists = (Dir(fname) <> "")
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.