Import Spreadsheet Problem

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

fishqqq

Is there a way to create a macro that will ask the user which .xls
file (on their hard drive) they wish to a particular table in a .mdb
file?

I have customers emailing me .xls files which have only one row of
data in them and i would like the user to click a button and be asked
which .xls file they wish to import and have this data pasted into
[table1] in my .mde file.

Once the data is in the table I know how to get it to do what i wish.
What i don't understand is how to create a macro that will ask the
user which file to import.
The "importexportspreadsheet" action will let me import a
predetermined file but i need something that will ask me for the
specific file i wish to import.

I know i can do this with the external data options but when i create
my .mde file the end users will not have the ability to do this. i
need something 'built in' to access which will allow them to do this.

any ideas are greatly appreciated.

tks
Steve
 
Back
Top