I have a question about Excel

[Executionerhk]

I want to use Marco in Excel. Which means the VB will help me to find a picture from a location to fill in a cell in the excel.

I have an old VB written by someone else.
which i can use ctrl+W to active the Marco and fill in the picture.

I changed it to work with my excel.
but after I saved the file and reopen it.
It will not work anymore.

can anyone here know how to solve the problem.
or can anyone write me a new VB marco command?

Here is what I want.
I have a location with .png .jpeg and .bmp and they are named in item number.

so i need to make a spec sheet.
which I use VLOOKUP.
so I will have a VLOOKUP cell which contain the Item number as picture name.

I want to use the marco to call out the particular picture via VLOOKUP.
how can i do it?

I can resize it my own since all the products are in different shapes.

This is the marco I have in hand.

Sub fotoeinf()
'
' fotoeinf Makro
' Makro am 11.03.2005 von maichholzer aufgezeichnet
'
' Tastenkombination: Strg+w
'
Dim variable As String

variable = "P:\Current Project\Item pictures\" _
& ActiveCell.Offset(0, 1).Range("C22") & ".png"


ActiveSheet.Pictures.Insert(variable).Select
Selection.ShapeRange.LockAspectRatio = msoTrue
Selection.ShapeRange.Height = 45.25
ActiveCell.Offset(1, 0).Range("A5").Select
End Sub


can anyone help me?
or
can anyone write me a marco?

you can leave out &&&fill in your file location here&&&
so I will replace anything that is in between &&& &&&

thanks for the computer help.

Steve