Excel found unreadable content

[HardingR2000]

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?

 

[SkipVought]

Excel does not take kindly to sheet names containing / or \, among several characters.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dhookom]

I agree with Skip. You can try change the sp IndexPrices_sp to accept parameters like "20100101" rather than "01/01/2010".

Duane
Hook'D on Access
MS Access MVP

 

[HardingR2000]

Excellent suggestion. Thanks.