controlling excel with access VBA (HELP)

[Guest]

I desperately need to be able to add/change/format cells in excel from access.
I've been searching through the forums looking for all the small pieces--
but I was hoping there was a webpage somewhere with all the VB code/commands
for doing excel formatting.

The stuff I need to do includes,

selecting a cell (i think it's done like a graph/grid right? ex: (A,1)? )
adding a value to that cell,
setting the cell's current value to a variable

Inserting a column/row between other rows/columns
deleting "

Importing/Exporting Excel with VBA, and/or copying+pasting from excel to
access.
using the same name + path of the imported/exported excel file.

Excel Formatting...
Bolding a group of cells
Adding/removing a border for a group
changing font/back color.
Aligning top/bottom

Looking/searching/seeking an excel field (a big loop that checks if every
cell = value?)

Thanks so much for Any help.

 

[Roger Carlson]

Actually, what I do quite often is export data to a separate tab of an Excel
template where the cells are linked to a pre-formatted sheet. That way the
formatting stays intact when I export new data.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ExportToExcel.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Wow your website is helpful for a lot of stuff-- thanks so much.

 

[Guest]

do you know how to format specific cells in excel?
like adding/removing/bolding etc

 

[Douglas J. Steele]

Check my July, 2005 "Access Answers" column in Pinnacle Publication's "Smart
Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

 

[Guest]

thx Doug

Check my July, 2005 "Access Answers" column in Pinnacle Publication's "Smart
Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html