| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Objects from folder and resizing them
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Objects from folder and resizing them
Hi Rookie_User
AutoCAD drawing files? Maybe this will help if they are pictures http://www.mcgimpsey.com/excel/lookuppics.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rookie_User" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Objects from folder and resizing them
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 "Ron de Bruin" wrote: Hi Rookie_User AutoCAD drawing files? Maybe this will help if they are pictures http://www.mcgimpsey.com/excel/lookuppics.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rookie_User" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Objects from folder and resizing them
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 On Mon, 5 Feb 2007 14:23:01 -0800, Rookie_User wrote: 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 "Ron de Bruin" wrote: Hi Rookie_User AutoCAD drawing files? Maybe this will help if they are pictures http://www.mcgimpsey.com/excel/lookuppics.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rookie_User" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting Objects from folder and resizing them
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 On Mon, 5 Feb 2007 14:57:01 -0800, Rookie_User wrote: Yes please. 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" wrote: 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 On Mon, 5 Feb 2007 14:23:01 -0800, Rookie_User wrote: 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 "Ron de Bruin" wrote: Hi Rookie_User AutoCAD drawing files? Maybe this will help if they are pictures http://www.mcgimpsey.com/excel/lookuppics.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rookie_User" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
