Get filename

[Matt]

I'm trying to write some code that will display a file
dialog box, allow the user to select a file, then post
the full path and name of that file as a hyperlink into a
table.

I've run into 2 problems: I can't figure out how to get
APIs to work (Access doesn't recognize the
CommonFileOpenSave line), so I tried using the
Application.FileDialog; however, this returns a relative
path, and since the files will be on a shared drive I
need the absolute path (e.g.,
\\drivename\drivefolder\etc\etc.xls)

Any advice would be much appreciated.

 

[Matt]

Thanks for the quick response.

I've looked at that page previously, but I guess part of
my problem is that I don't really understand the API
concept. When I enter ahtCommonFileOpenSave into VBasic,
I get a "Sub or Function not defined" error. Do I need
to have an external process set up for this to call, or
should VBasic recognize the CommonFileOpenSave command?

 

[Dan Artuso]

Hi,
You must not have copied and pasted all the sample code.
The function ahtCommonFileOpenSave is included in that code.