Hi,

I am trying to populate an Excel Worksheet from VB6. I can't figure out how
to put the column headers on the column header area of Excel. In other
words, I have columns 'First Name', 'Middle Name', etc. I want the area
where Excel names the columns 'A', 'B', etc. to have my headers. The best I
have been able to do is get them into the first row.

Also, is there a way to trim the number of columns so that no new blank
columns appear as the user horizontally scrolls past the last column with
data?

I hope this is clear. Thanks.

Otis

Hi
you can't change Excel's column headers. The best you can do (as you
have already discovered) is population row 1 and hiding Excel's column
headings

--
Regards
Frank Kabel
Frankfurt, Germany
"Otis" schrieb im Newsbeitrag
...
Hi,

I am trying to populate an Excel Worksheet from VB6. I can't figure
out how
to put the column headers on the column header area of Excel. In
other
words, I have columns 'First Name', 'Middle Name', etc. I want the
area
where Excel names the columns 'A', 'B', etc. to have my headers. The
best I
have been able to do is get them into the first row.

Also, is there a way to trim the number of columns so that no new
blank
columns appear as the user horizontally scrolls past the last column
with
data?

I hope this is clear. Thanks.

Otis

Hi Otis

You can't replace them

But you can use window-Freeze Panes in the menubar
To freeze the first column and Row select cell b2 and do windows -Freeze Panes

You can put your own headers in the first row and column now

Under Tools -options -View uncheck row & column headers so
the default row and column headers are gone


You can hide the column you don't use

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose Hide


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Otis" wrote in message ...
Hi,

I am trying to populate an Excel Worksheet from VB6. I can't figure out how
to put the column headers on the column header area of Excel. In other
words, I have columns 'First Name', 'Middle Name', etc. I want the area
where Excel names the columns 'A', 'B', etc. to have my headers. The best I
have been able to do is get them into the first row.

Also, is there a way to trim the number of columns so that no new blank
columns appear as the user horizontally scrolls past the last column with
data?

I hope this is clear. Thanks.

Otis

You can't change the labels for the columns or rows. (beyond the automatic
changes made by change the reference style).

--
Regards,
Tom Ogilvy

"Otis" wrote in message
...
Hi,

I am trying to populate an Excel Worksheet from VB6. I can't figure out
how
to put the column headers on the column header area of Excel. In other
words, I have columns 'First Name', 'Middle Name', etc. I want the area
where Excel names the columns 'A', 'B', etc. to have my headers. The best
I
have been able to do is get them into the first row.

Also, is there a way to trim the number of columns so that no new blank
columns appear as the user horizontally scrolls past the last column with
data?

I hope this is clear. Thanks.

Otis

Thanks Everyone. Its is almost as good to know when something can't be done
as is to know how something can be done.

Otis