Saving HTML as Excell

[Guest]

Hello all,

In my project we have exporting to Excel capabapility. What we used to do is
generate HTML and set content type as Excel. This worked great for 2003. When
I open the file in 2007 I get a security warning.

Does anyone have any idea, how can I make the warning dissapear?
Thank you in advance

 

[crferguson]

I'm thinking you're getting the security warning in 2007 because of
the file extension. Unless your file has one of the new Excel 2007
extensions (.xlsx, .xlsa, xlsm, etc) you're going to get a warning.
It doesn't mean anything is wrong with your file. It's just a new
"feature" in Office 2007.

Hope that helps...

Cory

 

[Guest]

Thanks for the reply.

I've tried that. Unfortunatelly, when I rename it to for example to .xslx I
get an error that the file is corrupted (because it's not .xslx). Do you have
any other ideas?

 

[crferguson]

Thanks for the reply.

I've tried that. Unfortunatelly, when I rename it to for example to .xslx I
get an error that the file is corrupted (because it's not .xslx). Do you have
any other ideas?

Sorry, as you've already figured out you can't just rename the
extension because it's proprietary to Office 2007. I can't find any
info on how to disable that specific warning, but you may find
something in the Trust Center in Excel 2007. In Excel 2007, go to the
Office button --> Excel Options --> Trust Center (on left) --> Trust
Center Settings. Perhaps within one of those categories is your
answer. I wish I could've been of more help.

Cory