[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"