Copy Method on "Hidden" OWC Spreadsheets

[StepHenHairNet]

A quick question about the ActiveX Spreadsheet control in Office 2000 Web
Components…

I’m using these in a VB.net project and wish to do something within a
“hidden†OWC Spreadsheet. By “hidden†I mean that they exist only in code.

Once the calculations are finished, I wish to copy the entire sheet into
another “hidden†OWC spreadsheet. I’ve tried various ways of doing this
but keep hitting “Access Denied†exceptions.

However, when I put “invisible†OWC Spreadsheets onto a form and use these
instead of the “hidden†or code-based versions, everything works fine.

Is there a way that I can use the OWC Spreadsheets as “work areas†without
having to have physical copies (albeit invisible to the user) on forms?

I have seen some similar posts with answers saying that there is a
security risk, however in these solutions (1) my IE settings correspond to
what they should be and (2) my implementation is within a Windows
Application and not a web page.

Any help appreciated.

Mr HairNet.

 

[Alvin Bruney [MVP]]

for that you should use the excel interop control on the server available as
a download from the office website

or you can use the clientside version and set the style display to 'None' if
you are doing client-side stuff

 

[StepHenHairNet]

Does that apply to Office 2000 Web Components Alvin?

I thought they were only available from Office 2002 onwards?

Thanks for the quick reply anyway.