R
rogedavi
Hi,
I am trying to copy a range of cells as a bitmap file and copy that
file into Lotus Notes using my macro. Can anyone help me?
This is the offending code:
Range("A1:L36").Select (selects the
range)
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
(copies as bitmap)
bodytext = ActiveSheet.Paste (generates an error -
help!)
At the moment the variable bodytext represents the data I want to
appear in the message. I adapted the code from elsewhere where this was
defined as a string, but i changed it to a variant as string and bitmap
are probably not compatible.
Help help please!
cheers,
David
I am trying to copy a range of cells as a bitmap file and copy that
file into Lotus Notes using my macro. Can anyone help me?
This is the offending code:
Range("A1:L36").Select (selects the
range)
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
(copies as bitmap)
bodytext = ActiveSheet.Paste (generates an error -
help!)
At the moment the variable bodytext represents the data I want to
appear in the message. I adapted the code from elsewhere where this was
defined as a string, but i changed it to a variant as string and bitmap
are probably not compatible.
Help help please!
cheers,
David