T
tbjohnso
I have a person trying to export from Access 2000 to Excel 2003 via VBA -
they are receiving an error 53, file not found - yet when I run it (Excel
2000/Access 2000) it works fine. Is there any unique references that I need
to specify? The code that is exporting the data is:
DoCmd.TransferSpreadsheet acExport, , "qryPullTime", txtSpreadsheetFile, True
where txtSpreadheetFile is a text box on the form where they can specify
where to save the file.
they are receiving an error 53, file not found - yet when I run it (Excel
2000/Access 2000) it works fine. Is there any unique references that I need
to specify? The code that is exporting the data is:
DoCmd.TransferSpreadsheet acExport, , "qryPullTime", txtSpreadsheetFile, True
where txtSpreadheetFile is a text box on the form where they can specify
where to save the file.