get open file name

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

hi all,
does anyone know how can i get the full file name of the current file
that i'm using via vba code?

there is a function called getopenfilename but from some reason its not
working,any idea?
 
What full file name are you talking about? The MDB file your code is running
in? That's CurrentDb.Name

GetOpenFileName is an API that invokes the standard Windows File Open
dialog. There's a complete example of using it at
http://www.mvps.org/access/api/api0001.htm at "The Access Web"
 
You must log in or register to reply here.

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Access Manage Attachments linked to a SubForm 0
Access Print Files from Query Results 0
Issue copying MS database from active application 3
.GetOpenFilename - Filter on File Name 5
Get "Open File" dialog 14
get file name 7
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top