|
 |
access thread: automating importing an excel spreedsheet when name of file unknown
Message #1 by "Lesley Schulz" <lesley.schulz@h...> on Tue, 4 Sep 2001 19:38:39
|
|
In access 97 pg. 233 in your book. I was reading how to have it import
spreadsheets from excel, but what if you don't know what the file name
will be? I will be inporting an excel sheet and the user may name it
anything. Can you help?
Lesley
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Tue, 04 Sep 2001 13:51:23 -0700
|
|
You can use a file open dialog box to prompt your user to supply a filename.
Search out the code at http://www.mvps.org/access/
HTH,
-Roy
-----Original Message-----
From: Lesley Schulz [mailto:lesley.schulz@h...]
Sent: Tuesday, September 04, 2001 12:39 PM
To: Access
Subject: [access] automating importing an excel spreedsheet when name of
file unknown
In access 97 pg. 233 in your book. I was reading how to have it import
spreadsheets from excel, but what if you don't know what the file name
will be? I will be inporting an excel sheet and the user may name it
anything. Can you help?
Lesley
Message #3 by John Fejsa <John.Fejsa@h...> on Wed, 05 Sep 2001 11:44:03 +1100
|
|
Hi Lesley,
I haven't seen the code you are using but I think that you could easily
use the CommonDialog Control, API call or even an input box to get the
file name and use it in you export code.
JohnF
>>> lesley.schulz@h... 05/09/2001 5:38:39 >>>
In access 97 pg. 233 in your book. I was reading how to have it import
spreadsheets from excel, but what if you don't know what the file name
will be? I will be inporting an excel sheet and the user may name it
anything. Can you help?
Lesley
|
|
|
View Cart
