How to use file dialog box with VBA?

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I want a toolbar button to export the active table to
Excel. I tried using TransferSpreadsheet with an input box
to get the desired path and filename from the user.
However the user would prefer to have a dialog box to
browse the computer and decide the file location/name.

So how can i call and use a standard dialog box with VBA?

Thanks
 
Back
Top