how to use the insert picture form

in excel, when you use insert \ picture \ from file you got a dialog box who appear, I want to use it and get back the adress of the file, and then do my business with it, but i don't know how to do

??
What do you need?, the code to insert a picture

VB Code:

ActiveSheet.Pictures.Insert("C:\Pictures\Terst.bmp").Select

(got that from the macro-recorder.)

Or what?

I want the user, to choose his picture with this form, and i want to get the link as a text

In this case use the commondialog, you can set the filter to whatever file-extensionm you need and you get the filename and path back.

what is the common dialog where is it and how to use it, i'm working on vba for excel

Oh, sorry, can't find it in VBA either.
Try this
[vbcode9
Dim dlganswer
dlganswer = Application.Dialogs(xlDialogOpen).Show
[/Highlight]
and look into the help section
Have to leave, long weekend is starting!
By

you're too lucky actually i'm in china working 6 days a week

ok this code is perfect

VB Code:

Dim dlganswer
dlganswer = Application.Dialogs(xlDialogInsertPicture).Show

but i still don't know how to get the path of the file as a text

Hi, French-China-Men
Why don't you use the same source for that information I'd be using? Exel-VBA-Help!
I don't have that at my home-computer, so it's up to you now!