Forum Discussion
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.
2 Replies
Make sure your CSV file correctly reflects the new names or paths of the images if those have indeed changed. You might also want to run a check on your MS List to see how the image URLs are structured.
First, verify where the new images are being stored and if they have alternate naming conventions. If they are still located in SharePoint, the path must be identified correctly.
