Hello guys,
Here is my problem:
My first column contains different numerical values.
All numerical value have a matching picture.
The picture's filename is basically composed of the value + a unkown character in front of them.
So I would like to insert the picture file matching the value in...
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...
Hello everyone,
Can someone tell me how to insert a picture using a variable instead using of the path and the filename.
Can it be done by using Pictures.Insert ????
Thank you
Zap
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.