Inserting Picture into Excel 1

[Lil8]

Hi

I am trying to write a macro that will automatically
allow someone to chose a picture from their My Pictures folder and when the image has been selected, will
automatically insert this picture into a spreadsheet into a specific space

Please can any one help

thnaks Nic

 

[SkipVought]

Nic,

Trun on your macro recorder and have at it!

Then you'll want to modify it and use the application.getopenfile method



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[IvanMoala]

have a look here for code you may amend to suit......

http://www.xcelfiles.com/VBA_InsertImgs.html

http://www.xcelfiles.com