Excel Cell Formating in Visual Basic 6.0
 

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!

Excel Cell Formating in Visual Basic 6.0
 

The Macro recorder is a good place to start when looking at things lik
this. I recorded the following:


Code
-------------------

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 03/05/2004 by tinyjack
'

'
Columns("A:A").ColumnWidth = 32.57
Rows("1:1").RowHeight = 72.75
End Sub

-------------------


But, as you are automating Excel from VB6 you will need to make sur
everything is fully referenced back to your Excel object.

T

--
Message posted from http://www.ExcelForum.com

Excel Cell Formating in Visual Basic 6.0
 

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!