Blackie50
08-27-2010, 02:37 AM
Hi
I have a macro that does some stuff (creates a list of prices).
I am using the 'Application.Dialogs(xlDialogSaveAs).Show' to open the
save window after it finishes.
Is there a way to automatically make the 'File name' populate with yesterdays date and the 'save as type' default to Excel (the macro takes a text file as its source data so tries to save as text type.
thanks
Jon
I have a macro that does some stuff (creates a list of prices).
I am using the 'Application.Dialogs(xlDialogSaveAs).Show' to open the
save window after it finishes.
Is there a way to automatically make the 'File name' populate with yesterdays date and the 'save as type' default to Excel (the macro takes a text file as its source data so tries to save as text type.
thanks
Jon