Sending data to excel

[mickey]

From Access 2000 I am able to programmatically add a label
to an excel sheet using the following:

Set myLabel = myDocument.Shapes.AddFormControl(xlLabel,
100, 150, 200, 50)

But, I can't figure out how to send text (caption) to the
label. Any help greatly appreciated.

Thanks!

 

[Graham Mandeno]

Hello Mickey

I don't know if there is a more direct method, but you can use the Selection
object:

myLabel.Select
Selection.Characters.Text = "Hello World!"

 

[John Nurick]

Hi Mickey,

IIRC you use
myLabel.TextFrame.Characters.Text = "Hi There!"

 

[Graham Mandeno]

You *do* recall correctly, John! Thanks - the TextFrame object somehow
passed me by