As long as you have an Excel application object then you have access to the
Excel object model. So you need something like

xlApp.ActiveWorkbook.Activesheet.Columns("A:H").Co lumnWidth = 14

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"ElanKathir .S.N" wrote in message
...
Hi all !

How to Format a Excel Cell using Visual Basic 6.0?
I want to fix the column width and hight and i using Excel Object for
create the Excel Sheet.

Thanks & Regards

Elankathir,
B'lore,
India.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!