Manipulating and formatting rows in Excel

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

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."
 
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
 
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."
 
Back
Top