inserting cell to cell

hi
i suppose the title is sort of lame. sorry.
I’m helping a friend develop her online store database. We are developing in Microsoft Excel 2000 - xls.
To save lots of work we’re naming the images after the sku (product id). For example if the sku were “P1234” then the three images would use that sku name as the basis for the image name. Like so…
P1234.jpg
P1234_sm.jpg
P1234_l.jpg
Where _l represents the large version in case you have problems with your font displaying the letter l and the number 1.
At any rate, we need to insert the sku into several fields row by row but I do not know how to do this. We need to take the first cell of the row and insert into column 5, which is an image link. For example…
P1234|field2|field3|field4|<IMG SRC="Path_to_image/ SKU.gif" BORDER=0>|
The “SKU” needs to be changed to the value of cell1 on a row by row basis.

Concerning the _sm and _l images; they go into column 8 and column 9 rows respectively. Both fields have similar requirements in that they both have the relative path followed by the image name…
images/products/SKU_sm.jpg
images/products/SKU_l.jpg

like so…
P1234|||||P1234.jpg|||Path_to_Image/SKU_sm.jpg|Path_to_Image/SKU_l.jpg|

The example above has field5 shortened for demonstration purposes.

It would be great to have an example to do this globally for the initial setup then as products are added the replacement or insertion can be done on a row by row basis to avoid any possibility of messing up established products.

Any links to appropriate reference or examples of a macro or function would be greatly appreciated.

Thanks for your consideration!

Hi Martin
Thanks for replying. I appreciate it.
In what format do you want the example? I'm concerned that my xls file may include a macro I have, which may present issues with some ppl and attachments. I can export to pipe.txt then upload. Then you can download and rename to database.pipe, for example.
Sorry for being a pain I just don't want to be uploading anything that maybe considered inappropriate as security for me is extremely important.

I assume you want a few product rows to work with with one being complete.
Dan

Hi Old Chippy
Thanks! Very interesting thread. I'll have to make a notation as this is a great example for helping ppl doing what I do. However. I'm assuming that this is for displaying pictures within a workbook file only.
The end result of the dB manipulation in xls will be to export to a pipe delimited plain text file which will be the core of an online store. There is no capability for imbeded images in the dB. The image references will either be html image links or image names, which the store will parse out the appropriate linking mechanism where only image names are used.
Sorry if I misunderstood your lead.

Thanks. I appreciate your input and thanks for the link to the cool thread.
Dan

Hi
Sorry for the delay I got hijacked and hammered with some intensive web work. :-\
I attached two files, one a tab-delimited file with the extension of txt for security reasons. It is a plain text file saved from excel to avoid any chance of including the macro I have in excel and to avoid any chance of unknowingly including some nasty thing that may have avoided the many security steps I execute on a regular basis. One never knows … looking out for anyone wanting to download my files. Simply drop the “.txt” extension and open in excel. I also included column titles for easy reference.
Note: always scan every file introduced to your operating system either before, during or after downloading. In any case always before opening/executing.
The other file is a plain text explanation file concerning what is needed to partially automate development of the dB. The info is the same as is posted here in this forum post. Simply as a matter of convenience so anyone can download both files and work offline with all the information necessary (I hope).

I added all 13 fields with contents in 10 rows (10 products) as a complete example of an authentic dB. This should hopefully avoid any confusion as to structure concerns.
The columns (fields/cells) of interest are
Cell A – Product ID
Cell E - Main Product Image
Cell H - Product Thumbnail/User Field 1
Cell I - User Field 2

The base image name for each and every product is the same as the Product ID unique to the individual product. Looking at the first two products you will see the image names are complete and based on the Product ID. The subsequent product image names all have four question marks where the Product ID must be inserted, replacing the question marks. Naturally this will happen on a row by row basis, as each Product ID is unique to the row (product).
10 or 100 products is not a big deal but any more than that a lot of tedious work can be avoided by some sort of macro or formula.
Please post any and all questions if I haven’t been thorough enough

Thanks for any and all comments, solutions, links or howdys. Grin
Dan