Pictures in Excel Files

[gottimd]

I have many spreadsheets in excel that drop in certain corporate logos based on cell contents. The problem is, is that when I create an HTML file of this, it creates another folder with all of the logos, and I have to upload each one to the company site/server.

Is it possible to have one main folder on my server called logo's, and when I am in excel, have an HTML tag point to that logo on the server so I don't have to upload each logo?

For instance, make a directory on my server called logos. www._____.com/logos

In Cell a1 on a spreadsheet, I want it to pull logo #1.

I have tried <'img src=" tags, but it only seems to display the text when I save as an HTML page from excel. What tags should I be using, if possible at all?

 

[nbrcrunch]

After using Excel to generate the html file, you can use Notepad to manually edit the html text and change the location of the tag.

 

[gottimd]

So there is no way to do that in a macro is there. I would have to open each html page and edit the link?

 

[gottimd]

I can't put in cell b7 the words, logo##.bmp

and then in b8 the formula is img src="http://www.____.com/logos/logo##.bmp" and the logo will show up there? I left out the "<" and ">" in the above formula so it would show in text.