Pictures in Excel Files

gottimd

Well-known Member
Joined
Jul 29, 2002
Messages
501
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?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
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

Well-known Member
Joined
Jul 29, 2002
Messages
501
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

Well-known Member
Joined
Jul 29, 2002
Messages
501
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,282
Messages
5,571,301
Members
412,379
Latest member
achugg22
Top