Output To Excel

S

Steve

Everyone

I am working on trying to Output to Excel using a macro. Easy enough, except I have two tables in Access that I need to go into the SAME Excel file as two DIFFERENT worksheets. (So, filename is Import.XLS - and the sheets in it would be TimeCard_Header and TimeCard_Detail). Anyone know how I can do this?
 
V

Vladimír Cvajniga

Hi,

I'm affraid you must do it through an Excel object. Not an easy task but
when I tried it for the first time it took several hours... :-( Luckily, I
didn't have to do it again.

E-mail me (vladimir dot followed by the rest you can find in my post). I'll
send you a code snippet I used to export some data to an Excel table. It's
only one-sheet but I hope it'll help... the difference is that you need to
add one more sheet. It's simple when you know how to add the first one ;-).

Vlado

Steve said:
Everyone:

I am working on trying to Output to Excel using a macro. Easy enough,
Click to expand...
except I have two tables in Access that I need to go into the SAME Excel
file as two DIFFERENT worksheets. (So, filename is Import.XLS - and the
sheets in it would be TimeCard_Header and TimeCard_Detail). Anyone know how
I can do this?
 

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

Excell Otpions in office environment 0
Update several ppt documents from a single excel file 0
Embed the same Excel multiple times 0
Need Help with Macro Security 1
Finding the right style field in VBA 0
Using TransferSpreadsheet Macro to import a single sheet from exce 1
Word macro that can call cells out of Excel for a find and replace 0
Autonumber field in Excel that behaves the same as Access 0

Top