i put a number or alphapets in sheet cell a13 (exp :a13=5946)
image store in c:\image\5946.jpg
how to show picture from stored place in excel any place or cells ?
please help in example xls or commands!!
i put a number or alphapets in sheet cell a13 (exp :a13=5946)
image store in c:\image\5946.jpg
how to show picture from stored place in excel any place or cells ?
please help in example xls or commands!!
anbusathya2003,
Welcome to the forum!
Give this macro a try. When you run it, it will ask you to select the range of cells containing the image file names. Then it will ask you to select a destination cell where the images will be imported:
Please Login or Register to view this content.
How to use a macro:
- Make a copy of the workbook the macro will be run on
- Always run new code on a workbook copy, just in case the code doesn't run smoothly
- This is especially true of any code that deletes anything
- In the copied workbook, press ALT+F11 to open the Visual Basic Editor
- Insert | Module
- Copy the provided code and paste into the module
- Close the Visual Basic Editor
- In Excel, press ALT+F8 to bring up the list of available macros to run
- Double-click the desired macro (I named this one tgr)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks