basic question - cannot get the range name correct when importing Excel worksheet

[JC]

Hey there,

I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.

Does anyone know what I am doing wrong?

DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel9, "tblTest",
"H:\everyone\Sh ared\ASC Processes\State Aid Processing
Databases\Lexin gton Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"


Thank you in advance,

JC

[Cyberwolf]

Re: basic question - cannot get the range name correct when importing Excel worksheet

Try this

DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel9,
"tblTest",
"H:\everyone\Sh ared\ASC Processes\State Aid Processing
Databases\Lexin gton Hurns.xls", 0, "Total Cvue Data!"


HTH

JC wrote:

Hey there,
>
I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.
>
Does anyone know what I am doing wrong?
>

DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel9,
"tblTest",
"H:\everyone\Sh ared\ASC Processes\State Aid Processing
Databases\Lexin gton Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"

>
>
Thank you in advance,
>
JC

[JC]

Re: basic question - cannot get the range name correct when importing Excel worksheet

Thanks CyberWolf

That did the trick. I knew I was missing something small.

Justin

Cyberwolf wrote:

Try this
>
DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel9,
"tblTest",
"H:\everyone\Sh ared\ASC Processes\State Aid Processing
Databases\Lexin gton Hurns.xls", 0, "Total Cvue Data!"
>
>
HTH
>
JC wrote:

Hey there,

I am trying to import an excel spreadsheet using the code below. Every
time it gives me a "cannot locate object" error.

Does anyone know what I am doing wrong?

DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel9,
"tblTest",
"H:\everyone\Sh ared\ASC Processes\State Aid Processing
Databases\Lexin gton Hurns.xls", 0, "Lexington Hurns!Total Cvue Data"

Thank you in advance,

JC