SET WEBARCHIVE=OFF

TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE PCHOLD AS REPORT FORMAT EXL2K OPEN
END

TABLE FILE CAR
SUM WHEELS
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K CLOSE
END

I would love to get an xls file generated and not an xmh file. Setting webarchive to off is not doing what it's supposed to to.

Also, Is there any way to stop that IE Information Bar warning? Specially if I'm running this on a local computer.

Thanks,

This message has been edited. Last edited by: Francis Mariani,

Francis,

I copied/pasted your code and got an XLS output file directly. Not sure what the problem is on your end.

I've seen the IE information bar warning fixed in the following two ways.

Try adding your site (local computer, internal server etc.) to the Local Intranet zone on IE.
1) From the Tools drop-down menu select Internet Options.
2) Select the Security tab.
3) Select the Local Intranet from the zones.
4) Click the Sites button.
5) Click the Advanced button and add your site to the list.

OR

Turning off the pop-up blocker in IE from the Tools menu.

Hope this helps,

Norb

Norb,

Thanks for the tip on IE - your suggestion worked.

I have Office 2010 and that's maybe why I get an xmh file and a pop-up message. Then when I try opening the file I get another pop-up with "The file you are trying to open is in a different format than specified by the file extension".

quote:

The file you are trying to open is in a different format than specified by the file extension".

Oh wouldn't I love to get rid of the message.

Check out this document. Although it is for an earlier version of WebFOCUS, it may point you in the right direction.

WebFOCUS client administration

Check out the link for "Microsoft Excel Report Considerations" under "Changing Redirection Settings".

Norb, I tried this and it unfortunately doesn't work.

You can get rid of the popup message for Excel 2010 by making a registry entry. This Microsoft article explains this for Excel 2007, but the fix is pretty much the same for 2010:

http://blogs.msdn.com/b/vsoffi...tension-warning.aspx

The only difference is the key you need to change - for Excel 2010, add the new DWORD value to the HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security key.

quote:

"The file you are trying to open is in a different format than specified by the file extension".

This is just another in the long list of things MS has done to try and make Office 2010 more secure. Even though the file comes down with a .xls extension, Excel 2010 is warning you that the file is not really a .xls file.

The fix JR describes basically turns off the warning mechanism.

We (OKDHS) implemented this state wide a few months ago.

You may also want to check out the setting in Excel under Options/Trust Center/Trust Center Settings.

This message has been edited. Last edited by: jgelona,

Whenever possible, I like to use the EXL07 format so that this message does not appear. However, the EXL07 in 7703 has some limitations.

You do realize that "some" actually means "quite a few"?

[EXPLAINED] EXL2K vs EXL07 performance

Setting webarchive=off does work for me, it changes form xmh to xht. However, the file extension warning still appears of course and when the user goes to save the file (if they choose to open rather than save in the first place) it still tries to save the file as a web document.

I think this depends on the web brower. In Firefox, I have set the Content Type of Excel to "Use Microsoft Execl". I get one pop-up, "What should Firefox do with this file?" (even though I set "Do this automatically..."), I click OK and it opens in Execl 2010 without other messages.

I'm happy with this, so thanks very much everyone.