Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel generation and PageSetup.CenterHeader
Hi,
I'm programming a web site from which I can generate Excel files (using PIA). I have no problem except writing Headers and Footers : I get a "printer is required" error message when trying to execute PageSetup.CenterHeader... The web site will run on a server where no printer is running. How can I bypass this problem ? Can I create a sort of virtual printer or anything else ? Thanks for help, Laurent. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel generation and PageSetup.CenterHeader
Just add and select a print driver in the Operating System. You don't
actually have to have a printer attached. -- Regards, Tom Ogilvy "lfb" wrote in message ... Hi, I'm programming a web site from which I can generate Excel files (using PIA). I have no problem except writing Headers and Footers : I get a "printer is required" error message when trying to execute PageSetup.CenterHeader... The web site will run on a server where no printer is running. How can I bypass this problem ? Can I create a sort of virtual printer or anything else ? Thanks for help, Laurent. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel generation and PageSetup.CenterHeader
How can I select the printer ? I use a Microsoft.Office.Interop.Excel.ApplicationClass and I only find a read only method "ActivePrinter" ? "Tom Ogilvy" a écrit dans le message de ... Just add and select a print driver in the Operating System. You don't actually have to have a printer attached. -- Regards, Tom Ogilvy "lfb" wrote in message ... Hi, I'm programming a web site from which I can generate Excel files (using PIA). I have no problem except writing Headers and Footers : I get a "printer is required" error message when trying to execute PageSetup.CenterHeader... The web site will run on a server where no printer is running. How can I bypass this problem ? Can I create a sort of virtual printer or anything else ? Thanks for help, Laurent. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel generation and PageSetup.CenterHeader
ActivePrinter isn't read only.
? activePrinter \\ARDAPS01\1D343E on Ne02: If I change my printer manually (as an example) then did ActivePrinter = "\\ARDAPS01\1D343E on Ne02:" it would change the active printer to that one. -- Regards, Tom Ogilvy "lfb" wrote in message ... How can I select the printer ? I use a Microsoft.Office.Interop.Excel.ApplicationClass and I only find a read only method "ActivePrinter" ? "Tom Ogilvy" a écrit dans le message de ... Just add and select a print driver in the Operating System. You don't actually have to have a printer attached. -- Regards, Tom Ogilvy "lfb" wrote in message ... Hi, I'm programming a web site from which I can generate Excel files (using PIA). I have no problem except writing Headers and Footers : I get a "printer is required" error message when trying to execute PageSetup.CenterHeader... The web site will run on a server where no printer is running. How can I bypass this problem ? Can I create a sort of virtual printer or anything else ? Thanks for help, Laurent. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TinyGraphs - Open Source Excel Add-in for Sparklines Generation | Excel Discussion (Misc queries) | |||
Excel List Generation | Excel Worksheet Functions | |||
PageSetup | Excel Discussion (Misc queries) | |||
java based pdf and excel generation | Excel Discussion (Misc queries) |