Export Images from MS-List to Excel (Macros)
Until about 1-2 months ago, I could easily export images from MS lists to an Excel spreadsheet with macros. I downloaded the list of images as a CSV and imported it into Excel. The images were stored in a SiteAssets folder in SharePoint, which I could easily extract the imges from the folder using the image names in the CSV and VBA code and import them into Excel. Now the images in the new entries have completely different names and they no longer appear in the folder. Is there another or new way to import the images using VBA code? Inserting everything manually takes far too long and is not worth the effort.
Until about 1-2 months ago, I could easily export images from MS lists to an Excel spreadsheet with macros. I downloaded the list of images as a CSV and imported it into Excel. The images were stored in a SiteAssets folder in SharePoint, which I could easily extract the imges from the folder using the image names in the CSV and VBA code and import them into Excel. Now the images in the new entries have completely different names and they no longer appear in the folder. Is there another or new way to import the images using VBA code? Inserting everything manually takes far too long and is not worth the effort. Read More