Wrong Group 1st Post - How to turn on intelisense for Excel obj?

[jofarrell]

I am exporting to an Excel spreadsheet and have never done it before nor have I played much more than the basics of a spreadsheet. It would be nice if VB (like it does for most everything else) listed some properties after I typed. For example:
objResultsSheet.Cells(Y, 1).????? would probably give me a list with Value, Formula etc .. things I am picking up are from past threads and these vries for help So anyone know a way I can just get VB to give me the Excel object properties?

Joanne

 

[ixian]

Joanne,

Go in to Project...then Reference...Then MS excel 9.0 object Library and check it. Then you will have all the properties and methods etc in intellisense


Aaron Fear is the mind killer!!!!!!

 

[jofarrell]

I have that done and nothing comes up when using the Excel object thats why I was wondering if something else is needed

Joanne

 

[strongm]

How are you declaring your Excel object?

[tt]Dim myExcelThing As Object[/tt]

or something like

[tt]Dim myExcelThing as Excel.Application[/tt]

It you are using the former, then Intellisense won't work

 

[Phathi]

Please summarise and paste your procedure for clarity...