Tom Ogilvy
 

I don't understand this comment from you:
"If you mean you have the spreadsheet control from the office web components
on your userform, then I don't see any property/method that will allow you to
print the worksheet. Perhaps you would need to copy the cells from the
sheet and paste them into a regular excel sheet, then paste that.

this may be the way microsoft protects themselves, if you can't open files,
save files or print, then not much chance this will be used instead of buying
excel itself. "

I mean, the userform is made from inside excel. Without excel, no userform,
without userform, no userform spreadsheet.
I know I can export the spreadsheet to a new workbook and print it that way,
I was just hoping for a more direct and faster way

Rgs

Kjeldc

Tom Ogilvy
 

"if you can't open files, save files or print,"

There is no method to Open, Save or Print files; BUT the OWC object has
properties XMLData and CSVData: you can write that these return to a file and
reconstitute the OWC.Spreadsheet by assigining to the XMLData property the
contents of the file.

ALthough you can EXPORT the OWC.Spreadsheet to XLS format, this will not
ALWAYS work because the OWC worksheet size is bigger that the Excel worksheet
size: there may be some truncation.

I've given up this technology because there is no way to suppress the right
click: without being able to do so, it is imnpossible to control the
component.

Tom Ogilvy
 

Thank you. Always nice to learn somthing new :-)

"AA2e72E" skrev:

"if you can't open files, save files or print,"

There is no method to Open, Save or Print files; BUT the OWC object has
properties XMLData and CSVData: you can write that these return to a file and
reconstitute the OWC.Spreadsheet by assigining to the XMLData property the
contents of the file.

ALthough you can EXPORT the OWC.Spreadsheet to XLS format, this will not
ALWAYS work because the OWC worksheet size is bigger that the Excel worksheet
size: there may be some truncation.

I've given up this technology because there is no way to suppress the right
click: without being able to do so, it is imnpossible to control the
component.

Tom Ogilvy
 

Tom,

If you're still mointoring this post, and you can provide some assistance
(even though you've abandoned OWC)?

OWC is a client-side technology. Is there a way to write a modified OWC
spreadsheet back to the *server* (Apahce in this case) through accessing the
OWC methods via javascript or vbscript?

Or, is there some other simple method to achieve this?

Thanks in advance.

Jimbo




"AA2e72E" wrote:

"if you can't open files, save files or print,"

There is no method to Open, Save or Print files; BUT the OWC object has
properties XMLData and CSVData: you can write that these return to a file and
reconstitute the OWC.Spreadsheet by assigining to the XMLData property the
contents of the file.

ALthough you can EXPORT the OWC.Spreadsheet to XLS format, this will not
ALWAYS work because the OWC worksheet size is bigger that the Excel worksheet
size: there may be some truncation.

I've given up this technology because there is no way to suppress the right
click: without being able to do so, it is imnpossible to control the
component.