p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

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




  Return to Index