Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

get open file name

Discussion in 'Information Technology' started by thread, Jul 28, 2006.

Tags:
  1. thread

    thread
    Expand Collapse
    Guest

    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?
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    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"

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "thread" <yaniv.dg@gmail.com> wrote in message
    news:1152716953.043646.94980@i42g2000cwa.googlegroups.com...
    > 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?
    >
     

Share This Page