OLEObjects: Adding jpg Object
From the Recorder:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 4/17/2008 by James Ravenswood
'
'
ActiveSheet.OLEObjects.Add(Filename:= _
"C:\Documents and Settings\Owner\Desktop\blacky.jpg", Link:=False, _
DisplayAsIcon:=True).Select
End Sub
--
Gary''s Student - gsnu200779
"Kate Lynne Ronquillo" wrote:
Is there a way to add a jpg object on a cell?
I'm using Paint.Picture but the image is in bmp.
We are trying to minimize the overall size of the excel file.
We have been using word document before, but we jpg is a much smaller file.
Is there a way to add jpg object in the file.
Or maybe an application that the default extension is jpg?
I have no idea how to this, please help.
Thanks a lot!
-- Kate
|