TransferSpreadsheet...but I want Worksheet two! 1

[TudorSmith]

Help!

I have the following code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblPGMImport", strImportPath, , "A16:V100"

This is successfully importing my spreadsheet...but now I want to run the code again, and import the data on worksheet 2 of the spreadsheet into a different table!

Any clues?

Thanks

birklea
birklea ~©¿©~ <><
I know what I know...don't presume that I know what I don't! Smithism!!!

 

[GHolden]

Put the sheet name in the range ie. &quot;Sheet1!A1:A5&quot;

 

[TudorSmith]

Excellent...so let me get this straight...sheet two in my spreadsheet is called &quot;PGRD&quot;, so my import spec should read:

"PGRD!A1:V100"

birklea birklea ~©¿©~ <><
I know what I know...don't presume that I know what I don't! Smithism!!!

 

[GHolden]

That should work splendidly

 

[TudorSmith]

It worked a treat...thanks...have a star! birklea ~©¿©~ <><
I know what I know...don't presume that I know what I don't! Smithism!!!