Hi,

I've got various older "photo logs" that coworkers made in Excel, all over our shared drive, and many of them are huge because pictures were not compressed. I've been trying to free up drive space by eliminating duplicates and reducing photos, but the ones in "photo logs" are in tables in Word documents.



I have a list of those in Excel (thanks to PowerQuery) and have eliminated any less than a year old. I'd like to run a macro that would open each file based on the path in column A of "this workbook" (current workbook) and compress all pictures, save and close. (Office 365 for Business, V 2508, on a Windows 10 PC)

I've got a few stumbling blocks, so I'll ask them separately.

First, various sources say I must first hit ALT+F11 and check the Microsoft Office 16.0 Object Library before using a macro that references Word from within Excel. But this box was already checked. And I kept getting an error on the line

So I tried checking also the Microsoft Word 16.0 Object Library, then also tried moving it upward in priority. Should I have to do this? Or did this mess something up?

After I did re-prioritize Word in the Excel VBA, I did get the macro to run, but not to satisfaction. Details to follow.