Manipulating Excel through Access VB

  • Thread starter Thread starter C Glenn
  • Start date Start date
C

C Glenn

I hope I'm in the right group. Let me know if I'm not.

I would like to know how to add an image to an Excel spreadsheet as it
is being created through Access 97 VB. I know how to add a textbox:

Set objChart = objExcel.ActiveChart
With objChart
.TextBoxes.Add 290, 200, 120, 25
.TextBoxes(1).Interior.Color = RGB(255, 255, 100)
.TextBoxes(1).Font.Size = 7
.TextBoxes(1).Font.Bold = True
.TextBoxes(1).Text = "Some text in here."
End With

So I'm thinking that there is a similar object class for placing an
image within Excel that I can use in the same way at the same time. Can
anyone help me with this?

Thanks.
 
C:

You're more likely to get a qualified response if you post this in the
Microsoft.public.Excel.programming newsgroup.
 
Back
Top