How to automatically Insert Images in Excel but have the images show up Offline?
Posted on 2011-05-11
I have a simple but complex problem. I want to insert web images in my excel spreadsheet automatically. I am using a simple VBA code
Dim SelRange As Range
Set SelRange = Selection
sImageName = SelRange.Value
Selection.ShapeRange.Height = 80
SelRange.Value = ""
What this does is it takes the file path in the cell and inserts the image. The images are often from an internet source.
however, If i'm offline and not on the internet, when I open the excel spreadsheet, the images will not show up locally. Where the images are it will just display the source of that image is unavailable.
What really makes this all confusing is if I MANUALLY insert an image, via Excel Insert Picture function, and I would paste it the same online image source, this picture would show up Offline and when i'm NOT on the internet.
I need to be able to automatically insert an image via VBA and have it show up if i'm offline. Can someone please help with this?