zapBranigan
Technical User
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
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