Output Report to Excel Issue

A

Anthony Viscomi

This is sorta the same question that I've been asking, but maybeI can convey
it a liitle better. I have the following VBA"

DoCmd.OutputTo acReport, "AR>121DaysBalance>180",
"MicrosoftExcelBiff8(*.xls)", "G:\MEI Cash Sheets\AGING DAYS Template.xls",
False, "", 0
DoCmd.OutputTo acReport, "AR>181DaysBalance>365",
"MicrosoftExcelBiff8(*.xls)", "G:\MEI Cash Sheets\AGING DAYS Template.xls",
False, "", 0
DoCmd.OutputTo acReport, "AR>61DaysBalance>90",
"MicrosoftExcelBiff8(*.xls)", "G:\MEI Cash Sheets\AGING DAYS Template.xls",
False, "", 0
DoCmd.OutputTo acReport, "AR>91DaysBalance>120",
"MicrosoftExcelBiff8(*.xls)", "G:\MEI Cash Sheets\AGING DAYS Template.xls",
False, "", 0
DoCmd.OutputTo acReport, "ARDaysBalance>365",
"MicrosoftExcelBiff8(*.xls)", "G:\MEI Cash Sheets\AGING DAYS Template.xls",
False, "", 0


My problem is that I would like each reprot to be a seperate worksheet
within the same spreadsheet. My question is, how can this be done?

Thanks!
Anthony Viscomi
 
Top