Inserting Objects from folder and resizing them

[Guest]

I have a columnA that contains the path of a file (it includes the drive
letter and actual name of file) and I would like to insert the object in the
cell next to it (column B). These objects are AutoCAD drawing files. In
addition, I need it to resize to like 1"x1" or so and then be anchored to the
cell. Any ideas?

My goal is to create a catalog sort looking thing that can be updated so if
you have other ways to accomplish the same thing please advise. Most of you
folks have a million ways to get where we want to get to . Thank you in
advance for your help.

 

[Ron de Bruin]

Hi Rookie_User

AutoCAD drawing files?

Maybe this will help if they are pictures
http://www.mcgimpsey.com/excel/lookuppics.html

 

[Guest]

That is awesome site but after trying it doens't get to where I need. I
wasn't sure how to alter it with my need because I want all of my pics
visible. In the below code, how could I make the value of A1 take the place
of the path and filename in the third line. Then I could at least get all
the pics inserted.


Sub Insert_Picture()
ActiveSheet.OLEObjects.Add(Filename:= _
"W:\ICC\5590 -5591\5590_1_RECEIVE\5590_SLDW_AUTO.dwg", Link:=False, _
DisplayAsIcon:=False).Select
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3

 

[Gord Dibben]

To have all the pictures visible is not possible with the method JE uses in the
lookuppics workbook.

I had the same problem........wanted all pics visible when DV selection
made........ and received help from Bernie Dietrick with some code and a sample
workbook he emailed to me.

If you like I can email Bernie's workbook to you for your perusal.


Gord Dibben MS Excel MVP

 

[Guest]

Yes please. (e-mail address removed)

I am just trying to automate putting a bunch of pics in. I have their path
and filename, seems like I should be able to use that value and have a macro
start from the top and work it's way down. Thanks for your time and effrot -
it is well appreciated.

 

[Gord Dibben]

On the way.

Hope it's close to what you want.

At least it will show you how to add pictures without losing the ones you have
visible.


Gord