What's wrong with the transferspreasheet code?

[msand]

I am doing datatransfer from excel to access. In the spreasheet code line, I want to use active workbook name but it kept showing this is wrong. The latest running showed "Run-time Error 13" -Type Mismatch.
anybody knows what's wrong with the line code of ActiveWorkbook?
Thanks


appAccess.DoCmd.TransferSpreadsheet _
acImport, _
acSpreadsheetTypeExcel97, _
"Shipping", _
"ActiveWorkbook.Path &" \ " & ActiveWorkbook.Name", _
True, "TransferRange"

 

[msand]

I figured it out by using MsgBox to test. Here is the code that works.


appAccess.DoCmd.TransferSpreadsheet _
acImport, _
acSpreadsheetTypeExcel97, _
"Shipping", _
ActiveWorkbook.Name, _
True, "TransferRange"

Hey thanks people who help on the thread "how to automate data import process from Excel to Access"

msand