HardingR2000
Programmer
I have an excel spreadsheet created by executing the Access VBA command which follows:
DoCmd.OutputTo acOutputStoredProcedure, "Exec IndexPrices_sp '" & Me.StartDate & "', '" & Me.EndDate & "'", acFormatXLS, "TIGERS_Index_Prices.xls", False
When I open the resultant spreadsheet in Excel I get the following message:
Excel found unreadable content in ...
When I click OK I then get the message:
Excel was able to open the file by repairing or removing the unreadable content. Rename invalid sheet name.
I am running Access 2003 and Excel 2007. I have surfed the web and nothing I have found addresses this specific issue.
I think the problem may be in the sheet name that Access creates, which I believe is based on:
"Exec IndexPrices_sp '" & Me.StartDate & "', '" & Me.EndDate & "'"
which comes from the DoCmd.
Does anyone have any suggestions or further information?
DoCmd.OutputTo acOutputStoredProcedure, "Exec IndexPrices_sp '" & Me.StartDate & "', '" & Me.EndDate & "'", acFormatXLS, "TIGERS_Index_Prices.xls", False
When I open the resultant spreadsheet in Excel I get the following message:
Excel found unreadable content in ...
When I click OK I then get the message:
Excel was able to open the file by repairing or removing the unreadable content. Rename invalid sheet name.
I am running Access 2003 and Excel 2007. I have surfed the web and nothing I have found addresses this specific issue.
I think the problem may be in the sheet name that Access creates, which I believe is based on:
"Exec IndexPrices_sp '" & Me.StartDate & "', '" & Me.EndDate & "'"
which comes from the DoCmd.
Does anyone have any suggestions or further information?