By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,957 Members | 1,323 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,957 IT Pros & Developers. It's quick & easy.

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

elak6
P: 21
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
Nov 25 '11 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,709
Select a File or Folder using the FileDialog Object should help you with that :-)
Nov 25 '11 #2

elak6
P: 21
Thanks NeoPa for all your help
Fially figured it out
Nov 28 '11 #3

NeoPa
Expert Mod 15k+
P: 31,709
No worries - Pleased to help :-)
Nov 28 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.