get file name

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

thread

Hi all,
i built a code that allow to choose file and its via excel object from
access.
the problem is that the minute the user is opening the dialog box to
open choose the file and move to diffent place,the dialog box is
disapearing and the only thing left is to close the access file and
start all over again.
does anyone know about a better way of using the get file dialog box
and maybe there is a diffrent function i can use from access
 
Hi all,
i built a code that allow to choose file and its via excel object
from access.
the problem is that the minute the user is opening the dialog box
to open choose the file and move to diffent place,the dialog box
is disapearing and the only thing left is to close the access file
and start all over again.
does anyone know about a better way of using the get file dialog
box and maybe there is a diffrent function i can use from access
Click to expand...
There isn't anything we can do unless you post the code you wrote, so
we can figure out what you have to fix.
 
There isn't anything we can do unless you post the code you wrote, so
we can figure out what you have to fix.
Click to expand...

Dim xlApp As Excel.Application
Dim xlWB As Excel.Workbook

Set xlApp = CreateObject("Excel.Application")
thefile = xlApp.Application.GetOpenFilename("xls files
(*.xls),*.xls", , "Pick a file", "OK")
 
there is quite a big number of code lines,is there anything more
simple?
Click to expand...
I do not know of anything more simple.
Just select all the code on the green section of the page, copy and
paste the code from the page into a general module for each of the
functions..
 
I do not know of anything more simple.
Just select all the code on the green section of the page, copy and
paste the code from the page into a general module for each of the
functions..

--
Bob Quintal

PA is y I've altered my email address.

--
- -

- -- -

- -
Click to expand...

thank you very much,the tip was very much helpfull
 

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

Open Document Function: What on earth is Filelist? 3
How to convert OST to PDF? Simple Methods 4
Word How can I stop Word 2010 asking permission to update a document with an included file? 0
make dialog box bigger 2
File Open dialog box 1
MDA files get name in references from? 2
unable to open file in Wordviewer states dialog box open 1
ODBC window doesn't appear when wanting to import data 1

Back
Top