TransferSpreadsheet problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anybody know why this isn't working from AccessXP?

Dim strFileName As String

strFileName = "f:\users\janetb\fhc" & StrConv(Date, "mm-dd'yy") & ".xls"
'DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8,
"qryFHCxlsRpt", strFileName, True
DoCmd.TransferSpreadsheet acExport, 8, "qryFHCxlsRpt", strFileName, True, ""
 
Eureka! Credit and thanks Roy-Vidar and PH Appreciate the assistance...

Just in case someone else runs across this:
Does not work:
strFileName = "f:\users\janetb\fhc" & StrConv(Date, vbShortDate) & ".xls"

Works like a charm:
strFileName = "f:\users\janetb\fhc" & Format$(Date, "mm-dd-yy") & ".xls"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Task Scheduler 5
Task Scheduler 3
Opening Excel Workbook from Access after TransferSpreadsheet 2
dao recordset error 3
Run-time error 3061 excel to access 1
formating spreadsheet 3
Executing MS Excel through MS Access vba 20
Export to Pocket Excel 1

Back
Top