Transferspreadsheet w/multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel spreadsheet that varies each day as to whether it has 1
worksheet, 2 or even 3.

How would I code the macro action "TransferSpreadsheet" range to allow for
these variations?

Thank you in advance!
JCarter
Still Learning
 
Is it that it will only have Sheet1, and another day Sheet1 and sheet2,
etc

or

that only sheet1 will have information?
 
I have this very same issue...only I use dating for my worksheets (i.e
070106, 070106 (2), 070106 (3) etc)...Depending on the day, I can have 3-6
worksheets that I need to transfer to my Access DB. When I run the macro, it
only transfer a single worksheet, and it happens to be the same one that I
used to set up the db?? Is there a better way?
 

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

TransferSpreadsheet Macro 1
Can a macro import multiple Excel worksheets 2
TransferSpreadsheet to existing worksheet creates new worksheet instead. 4
passing params to multiple querydefs and transferspreadsheet 8
importing multiple excel spreadsheets into access 3
Question Regarding TransferSpreadsheet w/ Formats 3
Using TransferSpreadsheet to import multiple Excel Files 5
Transferspreadsheet and replacing existing data 2

Back
Top