Problem: I have made a .rep consisting of 10 tabs. I want to refresh my query for client A, save each seperate tab as a rtf-file to a specified folder for client A. Refresh again for client B, save tabs as rtf, and so on for about 15 clients. Is there a VisualBasic-code to do this? Or any other way?
Sub SavePDF()
Dim boDoc As busobj.Document
Dim Rpt As busobj.Report
For Each Rpt In ThisDocument.Reports
If Rpt.Name = "Tab Name Goes Here" Then
Call Rpt.ExportAsPDF("C:\filename.pdf")
End If
Next Rpt
End Sub
You may find more examples if you do a search of the forum.