Solved

Access 2007 macro output to excel sheet

Posted on 2011-03-01
4
1,038 Views
Last Modified: 2012-08-13
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
Comment
Question by:jn1480
  • 2
4 Comments
 
LVL 3

Expert Comment

by:JAMcDo
ID: 35009592
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
 

Author Comment

by:jn1480
ID: 35009619
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 35009840

"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
 

Author Closing Comment

by:jn1480
ID: 35333360
Didn't match my request entirely, but a great add to my personal knowledge - thanks!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Use a Combo-Box to do a Search 26 25
Add records to a form to a table 11 37
Normalization of a table 19 69
Using Multiple  Filters (XLS and XLSX) in File selection dialog 6 26
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now