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

Output Access Data to Excel

dsatino
100+
P: 393
Ok, I admit there's info on this out there already but it's kind of scattered and usually specific to a problem, so stick with me for a second. I'm not looking for any specifics, just generally how to go about the following:

From Access VBA I need to:

Launch Excel
Create a new workbook
Create worksheets
Move around the worksheet cells
Edit cells

If anyone can give me any library references and/or general methods that would be great.
Thanks
Aug 5 '10 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,769
Have you considered Application Automation?
Aug 5 '10 #2

dsatino
100+
P: 393
That'll work for getting started thanks. I'm sure i can figure out the all moving around and formatting as I play with the library.

Thx!
Aug 5 '10 #3

NeoPa
Expert Mod 15k+
P: 31,769
No worries. I'm pleased I could help you, especially as you've contributed so much here recently :)
Aug 5 '10 #4

dsatino
100+
P: 393
No problem. It wouldn't be fair to ask and not answer where I could.
Aug 5 '10 #5

NeoPa
Expert Mod 15k+
P: 31,769
I think you've more than done your fair share, but we like that, so don't stop now :D
Aug 5 '10 #6

Post your reply

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