Access 2000 Open file dialog box???

[Guest]

I want to automate an excel spreadsheet imoprt function in a macro or VBA
code but I don;t want to hardcode the path and filename. Does anyone know a
way or have code to create a dialog box where i can browse for the file I
want just like doing it manually from the "file" , "open" buttons????


Thanks.

 

[Guest]

Matt,

If you would have searched the newsgroup you would have found that a lot of
people have this question. ;-)

But for you again:
For a nice example check the webpage http://www.mvps.org and especially
http://www.mvps.org/access/api/api0001.htm there you will find a nice
example which works in Access 95 and later versions.

Regards,
Bernd

 

[Guest]

Thanks alot BerHav. Just what i was looking for. I guess I am just lazy and
didn't seach first.