Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tom Ogilvy | Excel Programming | |||
Tom Ogilvy | Excel Programming | |||
Tom Ogilvy | Excel Programming | |||
tom ogilvy? somebody? | Excel Programming | |||
Thank u Tom Ogilvy | Excel Programming |