Open File Dialog Box 
Author Message
 Open File Dialog Box

Is there a way to access the Open File Dialog Box via
VBA...you know, where you can traverse through the
directory structure to find the file you want to open? I
know the method is called "GetFileOpen" in Excel, but I
can't seem to find a similar Access method. Thanks in
advance!


Fri, 16 Sep 2005 23:53:32 GMT  
 Open File Dialog Box
Whoops...actually, what I want is the "Get External Data |
Import" Dialog Box. Any ideas on that one???
Quote:
>-----Original Message-----
>Is there a way to access the Open File Dialog Box via
>VBA...you know, where you can traverse through the
>directory structure to find the file you want to open? I
>know the method is called "GetFileOpen" in Excel, but I
>can't seem to find a similar Access method. Thanks in
>advance!
>.



Sat, 17 Sep 2005 00:11:35 GMT  
 Open File Dialog Box
Do you mean you just want to kick off the import process, the same as
if you'd clicked those menu items?  Try

    RunCommand acCmdImport

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


Quote:
> Whoops...actually, what I want is the "Get External Data |
> Import" Dialog Box. Any ideas on that one???

> >-----Original Message-----
> >Is there a way to access the Open File Dialog Box via
> >VBA...you know, where you can traverse through the
> >directory structure to find the file you want to open? I
> >know the method is called "GetFileOpen" in Excel, but I
> >can't seem to find a similar Access method. Thanks in
> >advance!
> >.



Sat, 17 Sep 2005 01:06:42 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Open file dialog box and upload file

2. Open File Dialog Box

3. Open file Dialog Box in Access..Please Help

4. Open File Dialog Box

5. open file dialog box?

6. Open File Dialog Box

7. How to have a open file dialog box

8. Open File Dialog Box

9. paste or sendkeys into an Open File dialog box

10. Open File dialog box

11. invoke the Open file dialog box in DHTML

12. invoke the Open file dialog box in DHTML

 

 
Powered by phpBB® Forum Software