Column Headers
 

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

Column Headers
 

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

Column Headers
 

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

Column Headers
 

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

Column Headers
 

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