Prompt user to search for excel file to export access table to(vba/macro)

[elak6]

I am creating a form which will act as a dashboard for a variety of other functions

I am currently having problems in one aspect
I want to export mutiple tables to different worksheets in the same excel workbook.I also want to be prompted to search and pick the excel file that the tables are going to be exported as opposed to specifying the file.
Is there a way i can go about this
Thanks for your help

[NeoPa]

Select a File or Folder using the FileDialog Object should help you with that :-)

[elak6]

Thanks NeoPa for all your help
Fially figured it out

[NeoPa]

No worries - Pleased to help :-)