Excel generation and PageSetup.CenterHeader

  • Thread starter Thread starter lfb
  • Start date Start date
L

lfb

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.
 
Just add and select a print driver in the Operating System. You don't
actually have to have a printer attached.
 
How can I select the printer ?
I use a Microsoft.Office.Interop.Excel.ApplicationClass and I only find a
read only method "ActivePrinter" ?
 
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.
 
Back
Top