Manipulating and formatting rows in Excel

[Jonathan Blitz]

I am creating an Excel spreadsheet from within Access using an
Excel.Application and an Execl.Workbook object.
I have no problem creating the sheets and saving.

However, I also need to be able to perform the following before saving:

1. To specify the top row as a header row so that it doesn't scroll.

2. To specify the format of certain cells (whole columns).

How do I do this from withing Access?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Alex Dybenko]

the simplest way to do this:
open excel, open sheete you need, start macro-recording. do what you need to
do with your sheet. stop recording. open module and see code excel saved
there. now you can copy pieces you need and paste in access, but "based" on
Excel.Application object you have
HTH

 

[Jonathan Blitz]

Thx.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."