[RESOLVED] Cell Formatting in an Excel Object

[RobDog888]

Yes and No. Most of it will be ok but some of it will require complete object references.

'VBA:
Sheet1.Cells(1, 1).Value = "Test"
 
'VB:
Dim oApp As Excel.Application
Set oApp = New Excel.Application
oApp.Workbooks("Book1.xls").Sheets("Sheet1").Cells(1, 1).Value = "Test"

[guyjasper]

ok, i'll keep that in mind. i was playing with excel macro recording and i noticed that it uses "Selection" object. when i looked it up in the object browser (VBA), it belongs to Excel.Window object. how come i can't find it in VB? i already made a reference to Microsoft Excel 11.0 Object Library and there is no Excel.Window object