Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't print excel sheet using wsh script
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't print excel sheet using wsh script
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script to Print Range of Cells | Excel Discussion (Misc queries) | |||
How to mention a particular sheet name while opening excel with VB script. | New Users to Excel | |||
How to mention a particular sheet name while opening excel with VB script. | New Users to Excel | |||
Excel macro script to copy only formulas and not values from one sheet to another | Excel Programming | |||
Excel 2000/XP script to Excel97 script | Excel Programming |