Adding Bitmap to Worksheet

[Macca]

Hi,

I am using Automation with VC++ 6 to create,format and write data to an
excel spreadsheet.

I am having problems knowing who to add a bitmap to my spreadsheet through
automation. Can anyone tell me how to do this?

Thanks In Advance,
Macca

 

[Jim Rech]

I don't know the C++ syntax but in VB I'd do something like:

ActiveSheet.Pictures.Insert "C:\Pic.bmp"

--
Jim Rech
Excel MVP
| Hi,
|
| I am using Automation with VC++ 6 to create,format and write data to an
| excel spreadsheet.
|
| I am having problems knowing who to add a bitmap to my spreadsheet through
| automation. Can anyone tell me how to do this?
|
| Thanks In Advance,
| Macca

 

[Macca]

Hi Jim,

Thanks for the reply. How can i select whereabouts on the worksheet, the
bitmap goes?

Cheers
Macca

 

[Tom Ogilvy]

set pic = ActiveSheet.Pictures.Insert ("C:\Pic.bmp")
With activesheet.Range("B9")
pic.Top = .Top
pic.Left = .Left
End with

aligns the upper left corner of the picture wit the upper left corner of
Cell B9.