Reply to thread

Message: [QUOTE="Zeq, post: 6447846"] I have yearly data for multiple countries stored in an Access database I You could use the following as a starting point to have all you templates in one workbook - this is the only way I can think of to prin to one pdf. (There are utilities available to combine several pdfs t one, though.) VBA Code: -------------------- Dim country(1 To 10) As String, i As Integer country(1) = "USA" ' define all the countries you need.... Workbooks.Add For i = 1 To UBound(country()) Sheets.Add Type:="your_template_name.xlt", Before:=Sheets(Sheets.Count) ActiveSheet.Name = country(i) ' here get the data in place for country(i) ' e.g. Range("country_name").Value = country(i) Range("data_set").QueryTable.Refresh Next -------------------- [/QUOTE]