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.
--
Regards,
Tom Ogilvy
"onedollar" wrote
in message ...
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