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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

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,122,298
Messages
5,595,310
Members
413,986
Latest member
Elizsk

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top