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"
 
Back
Top