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

Returning the path to a file in VBA

P: n/a
A2003/XP Pro

I need to be able to open a file browser dialog, select an Excel file and
then return the file's path in VBA and haven't a clue how to do it. The
previous developer of the app I'm working on used an ActiveX control but
since our migration from A97 this is no longer an option. Can anyone point
me in the right direction?

Many thanks.
Keith.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Most advocate using API calls for this, which removes versioning and
licensing issues. Check this link:

http://www.mvps.org/access/api/api0001.htm

There's an example of useage at the bottom .. you should be able to play
around with it and figure out how it works.

"Keith" <ke*********@baeAWAYWITHITsystems.com> wrote in message
news:42********@glkas0286.greenlnk.net...
A2003/XP Pro

I need to be able to open a file browser dialog, select an Excel file and
then return the file's path in VBA and haven't a clue how to do it. The
previous developer of the app I'm working on used an ActiveX control but
since our migration from A97 this is no longer an option. Can anyone
point me in the right direction?

Many thanks.
Keith.

Nov 13 '05 #2

P: n/a
Superb, many thanks indeed!
:o)

"Scott McDaniel" <scott@NO_SPAM_HEREthedatabaseplace.net> wrote in message
news:dI********************@comcast.com...
Most advocate using API calls for this, which removes versioning and
licensing issues. Check this link:

http://www.mvps.org/access/api/api0001.htm

There's an example of useage at the bottom .. you should be able to play
around with it and figure out how it works.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.