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

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
"Macca" wrote in message
...
| 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

Hi Jim,

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

Cheers
Macca


"Jim Rech" wrote:

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
"Macca" wrote in message
...
| 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

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.

--
Regards,
Tom Ogilvy

"Macca" wrote in message
...
Hi Jim,

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

Cheers
Macca


"Jim Rech" wrote:

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
"Macca" wrote in message
...
| 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