Sending data to excel

  • Thread starter Thread starter mickey
  • Start date Start date
M

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!
 
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!"
 
You *do* recall correctly, John! Thanks - the TextFrame object somehow
passed me by :-)
 
Back
Top