Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel found unreadable content

Status
Not open for further replies.

HardingR2000

Programmer
Oct 6, 2008
40
US
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?

 



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

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top