gustavbrock/vba.pictureurl

Download and display pictures directly from URLs

Hi there 👋

vba.pictureurl's Issues

Doesn't Overwrite Existing Files

The code is working well. However, once "WeatherData.csv" exists, it is not overwritten with the next button press. Is there a modification that can be made to your code that performs the action of first checking if file exists, deleting it if it exists, then continue with the download?

Getting Weather Info

Thanks for pointing me to this "Issues" link. I will send you as much information as possible to help figure out how to import weather data on 64bit MS Access 2016. 1st: Is this normal for code to be red?

Images do not auto-rotate based on EXIF data

Images taken with cell phones do not always display in the proper orientation.

Cache file is converted to .htm

Hi,

When I try to use this function for my images, my URLs ends with a .jpg. The cache file is however saved as .htm-files. The MS Access-file cannot display that file type. I have looked at the URLDownloadToCacheFile documentation, but I cannot find a way to avoid convertion of the file at download. Even in your example code, your picture is changed from .jpg to .png (but that is still ok for the image control in Access).

Is there a way to force URLDownloadToCacheFile to keep original file format? In that case, it should be included in your function to improve performance.

My pictures that I have is stored in a Sharepoint Document Library, which I have full access rights for. Could this be a part of the issue?