Macro in Excel VB (Inserting Picture)

[theone_in_themoon]

Im trying to insert a picture through Macro in a worksheet.

The following line of Code doesnt work.

Code
---------------------------------------------
ActiveSheet.Pictures.Insert("C:\HomeData\PICTURES\EMPLOYEE\" & employee_number & ".JPG").Select
---------------------------------------------

Where 'employee_number' is a string.

Please help ...

Thanks in advance

 

[Jonathan_T]

you may be add string val. for get path picture thus as code below

------------------ Ex. code ------------------------------------------------------------
Dim MyPath as String

MyPath=("C:\HomeData\PICTURES\EMPLOYEE\" & employee_number & ".JPG"
ActiveSheet.Pictures.Insert(MyPath).Select
-------------------------------------------------------------------------------------------

--------------------------------------
My Favorite Microcontroller
**broken link removed**

 

[theone_in_themoon]

Thanks a lot Jonathen, My prob was solved ...