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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get Filename 1
Import File Information 0
Filename too long fix 0
Access Extract Hyperlink URL as String - Access 2010 0
File Dialog Box Problem 3
Need help using a relative path in VBA 0
Using Application.FileDialog(msoFileDialogFolderPicker) 1
Reading directory names 4

Back
Top