Get filename

  • Thread starter Thread starter Matt
  • Start date Start date
M

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.
 
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?
 
Hi,
You must not have copied and pasted all the sample code.
The function ahtCommonFileOpenSave is included in that code.
 
Back
Top