[Resolved] Excel VBA and SaveAs dialog box

[Hollie]

Hi,

I want to save some spreadsheets as part of a macro but I want to let the user choose where to store them - in other words I want to use the SaveAs dialog box.

I know how to do this in VB but I can't get it to work in Excel/VBA.

Does anyone have any ideas??

Thanks

H.

[Gaffer]

dlgSaveAsString = Application.Dialogs(xlDialogSaveAs).Show

[Hollie]

Thanks for that!

Next stage of my problem:
I create several spreadsheets in my macro and I only want the SaveAs dialog to appear the first time, allow the user to choose where they want to save all the spreadsheets and then just save all the other spreadsheets there.

Can this be done?

H.

[Hollie]

Got it!