Intellisense, Object Browser, Code Issue

[David]

All questions apply to VB5/6

1) Intellisense

If you have a reference to the Excel object in your VB5/6 program
how do you get intellisense to work for Excel objects?

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

2) Object Browser

I find the Excel object browser confusing. I never seem to be able to drill
down to what I need. Take "Range" for Example, why doesn't "Cell"
show under the Range object?

2a) Where do you find all the formatting properties that apply to Column,
Row and Cell?

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

3) Instead of getting the year only (2008) in Cell(1, "A") I keep getting
"6/30" -- and the year is 1905 but does Not show but this is the
value.
I recognize I have the Column formatted as Date, How the @#$%&^
do you format an individual cell as text, general or date = "yyyy"

Help?

I do the following:

'Set column and Cell Formats
With oWB.ActiveSheet

'Date Column
With .Columns("A:A")
.NumberFormat = "MM/DD"
End With

' .Cell(1, "A").NumberFormat = "YYYY" '<< ERRORS

'Center Headers and make Bold
With .Rows("1:3")
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False

.Font.Bold = True
End With

'Enter Value (year only)
.Cells(1, "A").Value = strAcctYear '<<ERROR shows 6/30/1905
'
when strAcctYear = 2008

End With

 

[David]

I found the answer to my Code question -- #3 -- by doing a Macro.

Answer is:
'Format As Text
.Range("A1").NumberFormat = "@"

Still need answers for #1, #2.

Thanks