Conversion xls to pdf page size must set to A4 through script

G

gourish R

Am newbie to vbscipts perdon me for any of my mistakes.i have vbs script to convert file of xls to pdf now i need to make changes to script so that pdf page size must set to "A4" while converting xls to pdf.In machine pdf page size has been set to "Letter" , am not supposed to make change in machine through script only need to set pdf page size to "A4"on error resume next'WScript.Sleep(1000)'Make sure to to get the file name from the invoking locaitonIf WScript.Arguments.Count < 1 thenWScript.Quitend IfMfile = WScript.Arguments.Item(0)set objExcel = CreateObject("Excel.Application")Set objF

Continue reading...
 

Similar threads

S
Replies
0
Views
490
Simon Timms (MVP)
S
Back
Top Bottom