I've been using a VBA script (embedded in an Excel spreadsheet) to create HTML pages to add images to a photo website. The VBA script controls Photoshop CS2 and Microsoft Word. (I'm using CS2 because it's a 16-bit app. Newer versions of PHotoshop that I have are 32-bit and aren't callable from VBA.) The spreadsheet with embedded script is attached.
Anyway, I've been using this flawlessly for years and then one day about a month ago it simply stopped working. Usually this is caused by an update to Photoshop CC 2015; and in the past I fixed it by reinstalling CS2 (which restores whatever files got clobbered). Not this time.
The error I get is "run-time error -2147212704 (80042260)". When I hit "Debug" this line is highlighted: Call objapp.ExecuteAction(id153
1, desc138, dialogMode). (I know this means nothing out of context...)
Windows 7 Pro, up-to-date
Microsoft Office 2010
Adobe Photoshop CS2
Thanks for any insights! Gary