Run-time error 3011

[LJG]

Hi Guys,

Am having a problem with some code, I have included this path in the code:

strSS = "C:\database\appointments\appointment_" _
& "*" & rst.Fields("User Name") & ".xls" 'the name of the
field

And fails here:
DoCmd.TransferSpreadsheet acImport, 8, "tempAppointments",
_
strTransfer, True, ""

Yet when I run this code I get an error message stating that it is looking
for a file path of C:\reliable

if I run in the code in the immediate the response's are:

?strSS
C:\database\appointments\appointment_*Les.xls

?strTransfer
Appointment_173_Les.xls

So it finds the file in the correct folder then when it loops to look for
more it appears to be looking elsewhere. I do have a folder C:\reliable but
have no mention of it within my code??

Any suggestions would be appreciated.

TIA
Les

 

[Michael J. Strickland]

Hi Guys,

Am having a problem with some code, I have included this path in the code:

strSS = "C:\database\appointments\appointment_" _
& "*" & rst.Fields("User Name") & ".xls" 'the name of the
field

And fails here:
DoCmd.TransferSpreadsheet acImport, 8, "tempAppointments",
_
strTransfer, True, ""

Yet when I run this code I get an error message stating that it is looking
for a file path of C:\reliable

if I run in the code in the immediate the response's are:

?strSS
C:\database\appointments\appointment_*Les.xls

?strTransfer
Appointment_173_Les.xls

So it finds the file in the correct folder then when it loops to look for
more it appears to be looking elsewhere. I do have a folder C:\reliable
but have no mention of it within my code??

Any suggestions would be appreciated.

TIA
Les

I don't see any reference to strSS in your "DoCmd.TransferSpreadsheet"
statement.

One thing I did notice is that you have included an asterisk ("*") in your
filename. This is not allowed since the asterisk is used as a wildcard in
filename references, not a literal character.


--