VBA to Open and SaveAs

[AndrewKent]

Hi there folks,

I need to build two VBA routines that when activated will...

1) open the OPEN dialog box and allow the user to open an Excel file of their choice.

...and...

2) open the Save As dialog box and allow the user to save an Excel file to a location of their choice.

...be damned if I can't remember the code to bring up these dialog boxes!

Many thanks,

Andy

 

[Jon von der Heyden]

Try:

Application.Dialogs(xlDialogOpen).Show

Application.Dialogs(xlDialogSaveAs).Show

HTH

Jon

 

[AndrewKent]

Spot on! Thank you muchly!

 

[Norie]

Andy

Perhaps Application.GetOpenFileName/GetSaveAsFileName.

 

[AndrewKent]

Following on from this,

How easy is it to add in coding so that when

Application.Dialogs(xlDialogSaveAs).Show

is used, a potential file name (defined by my coding) is populated into the filename box?