How to set excel column width from VB 1

[cassidybklyn]

Gentlemen,
I am using Visual basic 6.0 to import data from access table to excel spreadsheet. The process wss successful, but one of the fields in the spreadsheet is a date field but it does not display the date, rather it displays "#######". when I go into the spreadsheet and manually widen the column that has the date, the dates displays correctly. How can I set the column width from VB so that the date field displays correctly?
Thanks.
C.

 

[dgillz]

In VBA, try this:

Columns("C").Select
Columns("C").EntireColumn.AutoFit

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[SkipVought]

SheetObject.UsedRange.EntireColumn.AutoFit

autofits ALL columns




Skip,

_[red][/red]

 

[cassidybklyn]

Thanks Skip.
You've a tremendous help. I wish I can buy you a "drink" somehow.
C.

 

[dgillz]

Actually you can buy him a drink:

http://www.buyyourfriendadrink.com/home.php

New website, starting in NYC, to be expanding around the globe. disclaimer: I have no financial interest in this company.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[SkipVought]

My drink of choice is [highlight orange]Diet Peach Snapple[/highlight]. ;-)

Skip,

_[red][/red]

 

[cassidybklyn]

Skip,
ha ha ha ha ha
Okay, "Diet Peach Snapple" - u got it. Didnt know the "best stuff on earth" comes in diet flavor.
Thanks.
C.

 

[SkipVought]

You wouldn't want me to get all hyper on sugar, would you?

Skip,

_[red][/red]