Getting =HOST() Web Component to work in Data Acces Pages

[Guest]

I am having a real problem getting the Office Spreadsheet Component of 2003
Web Components to return a value (other than 0) from my DATA ACCESS PAGE when
using the HTML HOST function.

Am using the formula "=HOST().data_access_page_field_name.value" in the cell
of the Spreadsheet Component as per the Microsoft Office Assistance:
Calculate a value web page
(http://office.microsoft.com/en-us/assistance/HP051879071033.aspx)

It's also extrememly difficult to find any valuable sources of information
regarding the HTML HOST function.

Any ideas folks?

 

[Sylvain Lafontaine]

This function was a security flaw and has been removed, so it's no longer
available. (The entry is still there in the automation interface but a call
to it will now always return 0.)

http://support.microsoft.com/?id=328130
http://support.microsoft.com/kb/322382/EN-US/

 

[Guest]

Well, that explains it then!

Thanks Sylvain, greatly appreciated.

Ben