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


--
onedollar
------------------------------------------------------------------------
onedollar's Profile: http://www.excelforum.com/member.php...o&userid=31407
View this thread: http://www.excelforum.com/showthread...hreadid=511028