Defining a Worksheet

[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

 

[Guest]

Hi Anthony

Think you probably need to post this in an Excel support site. Good luck

Sheila

 

[Jamie Collins]

Think you probably need to post this in an Excel support site.

I think if they did they'd get the reply, 'I think you probably need
to post this in an MS Access newsgroup.' To me this is more an MS
Access question because of the DoCmd i.e. you don't need to know much
about Excel to answer the question.

Jamie.

--

 

[Anthony Viscomi]

I beleive that this is an Access newsgroup

I think if they did they'd get the reply, 'I think you probably need
to post this in an MS Access newsgroup.' To me this is more an MS
Access question because of the DoCmd i.e. you don't need to know much
about Excel to answer the question.

Jamie.

--

 

[George Nicholson]

If nothing else, let Access export your reports to separate single-sheet
workbooks like it wants to and then use Excel Automation to move those
sheets into a single workbook. Since you already know the workbook & sheet
names that Access generated, it is pretty straightforward (if you know a
little about the Excel object model).

I don't know of a way to send reports from Access to separate sheets of the
same Excel workbook. (but I would be thrilled to be proven wrong).

HTH,

 

[Anthony Viscomi]

That's actually what I ended up doing...thanks!

If nothing else, let Access export your reports to separate single-sheet
workbooks like it wants to and then use Excel Automation to move those
sheets into a single workbook. Since you already know the workbook & sheet
names that Access generated, it is pretty straightforward (if you know a
little about the Excel object model).

I don't know of a way to send reports from Access to separate sheets of the
same Excel workbook. (but I would be thrilled to be proven wrong).

HTH,