Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Read picture filename
I need a vba in Excel 2007 that once I drag a jpeg picture from a
folder to a cell it would type the picture filename in below cell cell excluding the extension, the typed filename has to be readable by vlookup this project is for creating a excel based catalogue which will have approx 9 to 12 pictures per standard sheet this project idea is very classic which I believe it is already done Thanks George |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Read picture filename
Objects cannot be pasted "into" cells.........only lay on top.
To have a picture show up based on VLOOKUP when you select an item from a DV list or type in a name see JE MCGimpsey's site. http://www.mcgimpsey.com/excel/lookuppics.html As written John's code allows for only one picture to be displayed and the pictures must be stored and hidden on the same worksheet as the VLOOKUP formula. But that will pose no problem...........simply cut and paste the shapes to the sheet in which you want them to be displayed. Or you need multiple pictures shown from VLOOKUPS............. Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for adding pictures via selections. Allows for more than one picture to be displayed on a sheet but also requires the pictures be stored on same sheet. http://www.contextures.on.ca/excelfiles.html#DataVal DV0049 - ClipArt Selection Gord Dibben MS Excel MVP On Sat, 27 Aug 2011 21:06:57 -0700 (PDT), Geo wrote: I need a vba in Excel 2007 that once I drag a jpeg picture from a folder to a cell it would type the picture filename in below cell cell excluding the extension, the typed filename has to be readable by vlookup this project is for creating a excel based catalogue which will have approx 9 to 12 pictures per standard sheet this project idea is very classic which I believe it is already done Thanks George |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Read picture filename
On Aug 28, 6:16*pm, Gord wrote:
Objects cannot be pasted "into" cells.........only lay on top. To have a picture show up based on VLOOKUP when you select an item from a DV list or type in a name see JE MCGimpsey's site. http://www.mcgimpsey.com/excel/lookuppics.html As written John's code allows for only one picture to be displayed and the pictures must be stored and hidden on the same worksheet as the VLOOKUP formula. But that will pose no problem...........simply cut and paste the shapes to the sheet in which you want them to be displayed. Or you need multiple pictures shown from VLOOKUPS............. Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for adding pictures via selections. Allows for more than one picture to be displayed on a sheet but also requires the pictures be stored on same sheet. http://www.contextures.on.ca/excelfiles.html#DataVal DV0049 - ClipArt Selection Gord Dibben *MS Excel MVP On Sat, 27 Aug 2011 21:06:57 -0700 (PDT), Geo wrote: I need a vba in Excel 2007 that once I drag a jpeg picture from a folder to a cell it would type the picture filename in below cell cell excluding the extension, the typed filename has to be readable by vlookup this project is for creating a excel based catalogue which will have approx 9 to 12 pictures per standard sheet this project idea is very classic which I believe it is already done Thanks George- Hide quoted text - - Show quoted text - Hi Geo, You may interest this link. http://www.excelfox.com/forum/showth...-in-a-Cell-UDF Kris |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Read picture filename
On Aug 28, 9:06*am, Geo wrote:
I need a vba in Excel 2007 that once I drag a jpeg picture from a folder to a cell it would type the picture filename in below cell cell excluding the extension, the typed filename has to be readable by vlookup this project is for creating a excel based catalogue which will have approx 9 to 12 pictures per standard sheet this project idea is very classic which I believe it is already done Thanks George Hi George, Have a look at this link. http://www.excelfox.com/forum/showth...-in-a-Cell-UDF Kris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forcing a Read Only Filename | Excel Discussion (Misc queries) | |||
Insert picture from filename & path in sheet's cell | Excel Programming | |||
Macro to read filename in cell and open new file | Excel Programming | |||
reference an ole image control's .Picture filename? | Excel Programming | |||
VBA to read spreadsheet's filename? | Excel Programming |