Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

R438 no such property or method

Status
Not open for further replies.

tiedyelime

Programmer
May 8, 2006
6
0
0
US
I am getting the above error message. I am trying to export a report to pdf. I can supply with my code if that will help. But the snipet where the problem is...
Sub GeneratePDF()
Set objImpRep = objImpApp.OpenReport(strImrSource)
objImpRep.Reexecute
Set ImpPDFRep = objImpRep.PublishPDF
ImpPDFRep.Version 0 'line where the problem starts
ImpPDFRep.ExportOptions 15
ImpPDFRep.Publish strPDFFileName & ".pdf"
strPDFFileName = Left$(objImpRep.FullName, Len _
(objImpRep.FullName) - 4)
ImpPDFRep.Publish strPDFFileName & ".pdf"
ReportPDF = strPDFFileName & ".pdf"
objImpRep.Save
objImpRep.CloseReport
End Sub
 
I believe that the .Version and .ExportOptions are confined to the Publish Excel object, not PDF.

soi la, soi carré
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top