can't print excel sheet using wsh script

  • Thread starter Thread starter onedollar
  • Start date Start date
O

onedollar

Hi,

I'm trying to print a pdf by using a wsh script. Problem is Excel
complains that printing is not possible because the file is already in
use or locked, which is complete nonsense.

Set objXl = wscript.createobject ("Excel.Application")

objXl.DisplayAlerts = False
objXl.visible = true

Set objwb = objxl.workbooks.open("c:\temp\test.xls")
Set objwb = objXl.activeworkbook.worksheets("Tabelle1")

objXl.ActiveSheet.PrintOut ,,,,,,,"my.pdf"


Any ideas ?

TIA
 
Are you sure it is trying to write to my.pdf? I assume you are using some
special print driver to create a PDF - maybe it has a different way to
determine what file to write to.
 
Back
Top