Baffled, can record macro, and then RTE5. Macro works fine on another PC. Excel2007

[boyd98]

Windows Server 2003, SP2.
All I want to do is open another excel sheet, and save it as a pdf.

I record it on the 2003 server and the functionality works. Opens the xls and saves as pdf. But if I run the macro I get RTE 5 (invalid procedure call or argument)

If i email the files to another PC Winodws 7, Office 2007, the macro works fine.

-----------------
Sub Macro2()
'
' Macro2 Macro
'

'
ChDir "C:\temp1"
Workbooks.Open Filename:="C:\temp1\ADOCERNERLabOrders.xls"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\temp1\results1.pdf", Quality:=xlQualityStandard, IncludeDocProperties:= _
False, IgnorePrintAreas:=False, OpenAfterPublish:=False
End Sub
---------------------------------------------------

Any help would greatly be appreciated.

Thanks again,

Boyd

 

[boyd98]

Issue resolved.

Bug with Office 2007 and pdf. needed to install Office 2007 SP2

 

[muckshifter]

thanks for reporting back, glad you got it sorted.