[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1064
  • Last Modified:

Access 2007 macro output to excel sheet

I have a simple Macro in Access 2007 using the 'Output To' Action to Export a query to an Excel Spreadsheet.

Works perfectly.
However, what I need is to be able to specify to output that query to FileA.xlsx, Sheet 1.
The next query to FileA.xlsx, Sheet 2
The next query to FileA.xlsx, Sheet 3

do-able?
0
jn1480
Asked:
jn1480
  • 2
1 Solution
 
JAMcDoCommented:
Clarification please>

Have you 1 query or more than 1 query?

Or . . .

Is the same query reuslts sent to Sheet1, then Sheet2, then Sheet3, . . . in a cyclic manner?  If so, are you trying to track which sheet either was the last sheet or should be the next sheet?

J.
0
 
jn1480Author Commented:
No tracking needed.
No cycles.

I will literally hand input each query into the Macro myself (I am brand new to this, and fascinated with the automation Macros are going to provide me).

I will assign one action line in the macro to output queryA to sheet/tabA in FileA.xlsx
I will then assign the next action in the macro to output queryB to sheet/tabB still in FileA.xlsx
Then the next action in the macro to output queryC to sheet/tabC still in FileA.xlsx

I want to end up with 3 (and/or many more) query outputs all in the SAME XLSX workbook file, just on separate sheets.
0
 
Jeffrey CoachmanCommented:

"do-able?"
Sure, but not easily with "Macros"

See this popular link:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_25141094.html

JeffCoachman
0
 
jn1480Author Commented:
Didn't match my request entirely, but a great add to my personal knowledge - thanks!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now