Prining from VBA not coming out in the correct size, please help me

Hi, I am using the script below to print files in a specific location from excel, but the sheets are not printing in A4, they're about half the size they should be, can anyone please spot why? if I print the documents manually they are fine, but priting from the VBA is causing an issue. Thank youSub PrintFiles()Dim oFSO As ObjectDim lngLastRow As LongDim lngIndex As LongDim strFname As StringDim xlSheet As WorksheetDim xlWB As WorkbookSet oFSO =... Read the entire article at the source link... leemcder

http://codango.com/prining-from-vba-not-coming-out-in-the-correct-size-please-help-me/

I am happy to share this resource that we found. The content displayed on this page is property of its original author or their organization.