Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting pictures without a control

Status
Not open for further replies.

zapBranigan

Technical User
Jun 29, 2001
3
CA
I would like to open a Picture file in excel without having to use a control.

I tought I could use something like this

Sub OpenBook1()
EXEPath = Application.Path & Application.PathSeparator
fName = EXEPath & "BOOK1.XLS"
Set myBook = Workbooks.Open(Filename:=fName)
MsgBox myBook.Worksheets(1).Range("A1").Value
End Sub

but this is used for workbooks.

Is there any similar way to open a picture file ???

Thank you for your time,

Zap_Branigan
 
This should work (or something along these lines):

ActiveSheet.Pictures.Insert("C:\MyPath\MyPicture.jpg") Store300

Store300@ftnetwork.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top