Exporting Excel 2003 to pdf RRS feed

  • Question

  • I have a vb6 app that creates an Excel 2003 doc that I need to export to pdf. I have the following code to export,

    excelWorkBook.Worksheets.PrintOut Copies:=1, ActivePrinter:="Adobe PDF",' printtofile:=True, prtofilename:=strOutputName 

    but nothing prints. The app exports to pdf works in test, but not when I move it to production. I have to remote into the machine that runs the app, so my printers from my local pc are "attched" to the remote session, can this have something to do with no output.  The remote machine does not have the Adobe print drivers installed.

    What can I do to get the export to work?


    Thanks in advance



    Monday, September 12, 2011 12:39 PM