run-time error -2147212704 (80042260)

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(id1531, 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
Add-New-Images-v11.xls

Microsoft ExcelVBAAdobe Creative Suite CS

Last Comment

Frank Helk

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

funwithdotnet

10/5/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Gary Friedman

10/5/2016

ASKER

The VM is a brilliant and practical suggestion. I'm already running Oracle Virtualbox with Ubuntu so it shouldn't be much trouble to load a new Win7 with just the pieces I need. I'll let you know how that goes. I think this will save a lot of time in the long run. :-)

GF

Frank Helk

11/11/2016

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: funwithdotnet (https:#a41830761)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

rwheeler23