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

Allow to user to map to file to compile

P: 25
I'm creating an interface for some staff. I was wondering whether it is possible to allow the user to map the file to import.

Bause now i'm using a marco action to import the file and the file specifcally mapped by me.. so the all users must used that specific file only...It's rather erm troublesome/stupid...

PLEASE PLEASE AND THANK YOU
Sep 19 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
I'm creating an interface for some staff. I was wondering whether it is possible to allow the user to map the file to import.

Bause now i'm using a marco action to import the file and the file specifcally mapped by me.. so the all users must used that specific file only...It's rather erm troublesome/stupid...

PLEASE PLEASE AND THANK YOU
This code behind a command button brings up the common Windows file open dialog box:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Command0_Click()
  2. Dim dlgOpen As FileDialog
  3.  
  4. Set dlgOpen = Application.FileDialog(msoFileDialogOpen)
  5.  
  6. With dlgOpen
  7.     .AllowMultiSelect = True
  8.     .Show
  9. End With
  10.  
  11. End Sub
This requires a reference to Microsoft Office 11.0 or 12.0 Object Library (note this is a separate reference from the Microsoft Access 11.0 Object Library)

Also have a look at this thread: http://www.thescripts.com/forum/thread681968.html

Regards,
Scott
Sep 21 '07 #2

Post your reply

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