how to use the insert picture form

[writelearner]

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

[opus]

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

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

(got that from the macro-recorder.)

Or what?

[writelearner]

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

[opus]

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.

[writelearner]

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

[opus]

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

[writelearner]

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

[writelearner]

ok this code is perfect

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

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

[opus]

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!