Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Automatic Excel to PDF - Can this be done using VB script?
7 views
Skip to first unread message
Nicole Allen
Oct 13, 1999, 3:00:00 AM10/13/99
to
A client wants to take excel document to pdf format. I want to automate
this process. Is it possible to write and run a script that will do this
conversion automatically? (i.e. Can vbScript and the Windows scripting host
be used to call commands in Excel, Adobe, etc.)
this process. Is it possible to write and run a script that will do this
conversion automatically? (i.e. Can vbScript and the Windows scripting host
be used to call commands in Excel, Adobe, etc.)
Jens Linde Sørensen
Oct 14, 1999, 3:00:00 AM10/14/99
to
Yes,
Just remember to load the PDFWriter.xla file before running the Auto_Open
and the PrintPDFFile macro.
You can use this script.
Just remember to load the PDFWriter.xla file before running the Auto_Open
and the PrintPDFFile macro.
You can use this script.
/Jens
Dim objXL
Dim Arg
Set Arg = WScript.Arguments
Set objXL = WScript.CreateObject("Excel.Application")
objXL.Visible = FALSE
ObjXL.WorkBooks.Open "D:\Program Files\Microsoft
Office\Office\XLStart\PDFWriter.xla"
ObjXL.WorkBooks.Open Arg(0)
ObjXl.ActiveWorkbook.SaveAs Arg(1)
ObjXL.Run ("Auto_Open")
ObjXL.Run ("PrintPDFFile")
ObjXL.Quit
Nicole Allen wrote in message <#dBTf#XF$GA.196@cppssbbsa03>...
jaron...@gmail.com
Dec 11, 2014, 3:07:10 AM12/11/14
to
On Wednesday, October 13, 1999 12:30:00 PM UTC+5:30, Nicole Allen wrote:
> A client wants to take excel document to pdf format. I want to automate
> this process. Is it possible to write and run a script that will do this
> conversion automatically? (i.e. Can vbScript and the Windows scripting host
> be used to call commands in Excel, Adobe, etc.)
I think the script wouldn't be that efficient and promising while we need to convert some important excel documents to PDF file . The better way to do this is using converter tool . i have been using a tool names as Total Excel Converter. This is really efficient tool and easy to use . I have been using this tool from years and i haven't seen any type of problem with this tool.
> A client wants to take excel document to pdf format. I want to automate
> this process. Is it possible to write and run a script that will do this
> conversion automatically? (i.e. Can vbScript and the Windows scripting host
> be used to call commands in Excel, Adobe, etc.)
Source : http://www.coolutils.com/Excel-to-PDF
0 new messages