Force IMAGE To Connect

[Davey54]

Folks, I am coming here for the first time because over the years I have seen some excellent advice here for Excel.

I am exporting from MS-Access to Excel a long list of rows, each with a working URL to a website which contains image data. Inside Excel the corresponding cell simply shows the IMAGE function and the URL string. It is not until I click to enter the cell and hit the Enter Key or hit F2 that cell will update and show the actual image instead of the URL string.

Obviously, there is a program function inside Excel which must be triggered to force this update. Any ideas of how I might do that programmatically?

Please note that I have dealt with the security issues and the validity of the URL, as simply entering the cell manually and hitting Enter forces an update and the image actually shows.

If you are going to recommend a "Send Keys" macro, then you probably need to test it yourself, because that does not do it either.

 

[Jaafar Tribak]

Hi,

My excel 2016 doesn't have the IMAGE function so I can't test but since it is a function, you could press F9 (or Ctrl+Alt+ F9) to force a worksheet calculation.
If that works and you want to be able to automate the forced calculation after importing the data from Access. then that will depend on the way you are importing the data.

 

[RoryA]

You could also try a replace operation on the relevant range like:

Range("B2:B100").Replace "=", "=", xlpart

 

[Davey54]

I thank you both very much for your responses. I knew if I came here I could find good advice.

The Recalc idea I tried already, and it does not work.

On the other hand, the Range/Replace idea is a WINNER! It WORKS!

Thank you both so very much!