GleamTheCube
New Member
- Joined
- Jul 26, 2011
- Messages
- 2
I have a macro that publishes a range to a sharepoint. There is conditional formatting in a few cells that show a green check mark when viewed in Excel. Upon publishing these turn into numbers.
What I'm trying to accomplish is to clear those cells and replace the numbers with anchored images that are stored on the sharepoint.
First I tried to insert normal html into the cell, but when viewed in sharepoint there are quotes around the img tags.
The last thing I tried was to add a .Shapes.AddPictures call to the cells in question with the filename set to the location of the image. This throws a 1004 error.
I'm stumped on whether this is even possible to do.
Basically all I want is to have a static html view of a range, but with img src... in a few cells which references the image stored on the same sharepoint.
Can anyone help?
What I'm trying to accomplish is to clear those cells and replace the numbers with anchored images that are stored on the sharepoint.
First I tried to insert normal html into the cell, but when viewed in sharepoint there are quotes around the img tags.
The last thing I tried was to add a .Shapes.AddPictures call to the cells in question with the filename set to the location of the image. This throws a 1004 error.
I'm stumped on whether this is even possible to do.
Basically all I want is to have a static html view of a range, but with img src... in a few cells which references the image stored on the same sharepoint.
Can anyone help?
Last edited:
