Defining a Worksheet

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
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
 
Hi Anthony

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

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

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.

--
 
I beleive that this is an Access newsgroup
Jamie Collins said:
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.

--
Click to expand...
 
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,
 
That's actually what I ended up doing...thanks!
George Nicholson said:
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,
Click to expand...
 
Back
Top