By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,505 Members | 1,549 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,505 IT Pros & Developers. It's quick & easy.

Export to excel sheets

P: 32
Hi,

I have 5 tables in my database. I would like to be able to export the data from 4 tables into one excel file, where each table would be on it's own sheet.

Is this possible with just a macro group? Or would I have to do some VB coding here?

Thanks,
Jason
Mar 17 '08 #1
Share this Question
Share on Google+
2 Replies


cori25
P: 83
It is possible in a macro, you would have to do a transfer spreadsheet for each table and define which sheet it should go to.

Although, I try to avoid transfer spreadsheets and do it in a module.

If you need more assistance, just let me know.

Thanks
Mar 17 '08 #2

P: 32
Hi Cori25,

If doing it in a module is a better idea, then I'm up to trying it. Is there somewhere you can direct me to learn how to get this working?

Thanks,
Jason
Mar 17 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.