473,387 Members | 1,516 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Output Access Data to Excel

dsatino
393 256MB
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
5 1399
NeoPa
32,556 Expert Mod 16PB
Have you considered Application Automation?
Aug 5 '10 #2
dsatino
393 256MB
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
32,556 Expert Mod 16PB
No worries. I'm pleased I could help you, especially as you've contributed so much here recently :)
Aug 5 '10 #4
dsatino
393 256MB
No problem. It wouldn't be fair to ask and not answer where I could.
Aug 5 '10 #5
NeoPa
32,556 Expert Mod 16PB
I think you've more than done your fair share, but we like that, so don't stop now :D
Aug 5 '10 #6

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

Similar topics

3
by: juffles | last post by:
Dear Anyone, I am a newbie so please forgive my ignorance. Is there anyway that i can migrate data from access to excel and for the data to be presented as a graph all in one single button? ...
5
by: Tammy | last post by:
I am doing some genealogy research and I have discovered that there is a lot of data available on the web in text format. The problem is that the columns in the files are lined up by spaces. I'd...
13
by: nuti | last post by:
Hi all, I am fairly new to VB.I am trying to figure out as how to write a script so that i can read the data from an excel sheet to Access. can u guys please help me out? cheers, nuti
1
by: garry.oxnard | last post by:
Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...
5
by: erick-flores | last post by:
Hello all I have 4 tables in MS Access 2003. I want to export all these tables, with their links, to Excel. How do I export them with all the link between tables....can I do that? I know I can...
5
by: garethfx | last post by:
Hi all Ive 2 crosstab queries that I have been asked to export the data from to excel. My sql isn't to cleaver so I,m stuck. I need to place the queries outputted data into specific cells in...
4
by: xwings | last post by:
I want to export my data to "Notepad" Or "Excel" Below is my Access Database Data; http://img340.imageshack.us/img340/3842/pictureju0.jpg How can i done that with VB6? or isit possible that i...
1
by: shlaga | last post by:
Hi, I have query in access that i output in excel and want to graph the output. I have written the code for this in access -> visual basic i want the code to get the range of the xvalues and...
3
by: peteh | last post by:
Hi All; I have tried to find this info on the IBM site, but alas... We are running DB2 v9.1.1 and making extensive use of Information Integrator (now known as Websphere Federation Server?!) to...
0
by: TrevoriousD | last post by:
hi I have created a data link from access query to excel. I use excel pull data from access in order to do stats. the excel workbook always stays in the same folder as the access db. I want to be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.