Exporting Table to Specific Excel Worksheet

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a macro that opens a query, runs the app and then transfers the table
to Excel. Is there a way to transfer the table to a specific tab in my Excel
sheet and and to a specific cell in the worksheet. For example I would like
my access table transferred to the Jones tab in the IS file and would like
the data to begin in cell "A6"

Thanks.
 
Bob,

How did you get the whole list of Macros to run. I wrote three lines of
macro and it only runs the first one. Is there a call function for the second
one? I want to automate the query to be exported into excel.

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to export table from outlook into ms access table? 0
Output to macro action 1
Excel Move or Copy Stopped Working? 0
Export table to txt file with a variable filename 0
Export to Excel 3
How to Transfer Emails from One Gmail Account to Another? Simple Steps 3
Excel Multiple Worksheets - TransferSpreadsheet VBA 0

Back
Top