[RESOLVED] VB6 and Excel TextBox Object

I am working with an existing Excel document and VB6. I need to open the document, enter some data into a Textbox object within an excel sheet.

I can open the excel document as normal, but I am having trouble trying to figure out how to reference the textbox object that it contains to add text to it.

Any help with referencing and adding text to a textbox in excel would be awesome.

Ok, so I finally figured it out in case any one else need its.

Once I had a reference to a sheet ie. Set oSheet = oWB.ActiveSheet

I was then able to use:

oSheet.Shapes.Item("TextBox 4").TextEffect.Text = "woo"