Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

3011 - could not find file 1

Status
Not open for further replies.
trudye10

trudye10

Programmer
Sep 8, 2006
67
I am receiving error '3011' could not find object. Here is my code.

Code: 
<html>
  <head>
    <title>Page</title>
  </head>
  <body>
Function Export_Output()

On Error GoTo WhyMe
DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "tblEnroll_Error_Report", "U:\marketing\ResultsControl\AON_Enroll_Error_Report-2_" & Format(Date, "yyyymmdd") & ".xls", True
Exit Function
WhyMe:
    MsgBox ("Error Number: " & Err.Number & " | Error Description: " & Err.Description)

End Function
 </body>
</html>

I've used this command before and never had a problem, what am I missing?

Thanx,
Trudye
 
Sort by date Sort by votes
"U:\marketing\ResultsControl\AON_Enroll_Error_Report-2_" & Format(Date, "yyyymmdd") & ".xls"
Click to expand...

Are you sure the drive mapping is still the same? I'm guessing that the U drive may be pointing to a network location.

One way to get around that type of problem would be to use the full network path as apposed to the drive letter associated with it (if this is indeed the case).

--

"If to err is human, then I must be some kind of human!" -Me
 
Upvote 0 Downvote
By George I think I've got it. I forgot the acExport behind the transfertext command

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblEnroll_Error_Report", "E:\marketing\ResultsControl\AON_Enroll_Error_Report-2_" & Format(Date, "yyyymmdd") & ".xls", True


So he was trying to do an import and thus could not find the file!!!

Thanx to everyone who chimmed in!
Trudye
 
Upvote 0 Downvote
Anytime! All of us are here trying to help! [wink]

[rofl]

--

"If to err is human, then I must be some kind of human!" -Me
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hermanlaksko
  • Question
Convert PDF file to text
Replies
6
Views
319
hermanlaksko
hermanlaksko
Kennelbloke
  • Locked
  • Solved
Split Function not working
Replies
3
Views
474
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
769
dhookom
dhookom
Moss100
  • Locked
  • Question
Find error in currency feild 2
Replies
8
Views
1K
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
691
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top