Help Importing Excell Files

S

swichman

Can somebody help me with the below expression?

I am getting a syntax error.


Much appreciated.

Docmd.TransferSpreadsheet
(acImport,acSpreadsheetTypeExcel9,"DrawingsCurrentRevImport","C:
\Documents and Settings\swichman\My Documents\ABFJV\SubmittalReports/
PMIVExport.xls",,,)
 
D

Daniel

Without even testing or looking up the function I notice a forward slash in
your path?

"C:\Documents and Settings\swichman\My
Documents\ABFJV\SubmittalReports/PMIVExport.xls"

Shouldn't it be

"C:\Documents and Settings\swichman\My
Documents\ABFJV\SubmittalReports\PMIVExport.xls"
 
K

Ken Snell \(MVP\)

Eliminate the parentheses. You don't need them when using this VBA
statement.
 
S

swichman

Eliminate the parentheses. You don't need them when using this VBA
statement.

--

Ken Snell
<MS ACCESS MVP>









- Show quoted text -
Click to expand...

STILL DOES NOT WORK. I FEEL LIKE AN IDIOT
 
Top