Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
Solved
run-time error -2147212704 (80042260)
Posted on 2016-10-05
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
Windows 7 Pro, up-to-date
Microsoft Office 2010
Adobe Photoshop CS2
Thanks for any insights! Gary
Add-New-Images-v11.xls
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
Windows 7 Pro, up-to-date
Microsoft Office 2010
Adobe Photoshop CS2
Thanks for any insights! Gary
Add-New-Images-v11.xls
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Did you try completely uninstalling all Adobe products and reinstall CS2? If it's a Photoshop-related issue, that should probably fix it, based on your original comments. If it doesn't, I'd wonder if the issue was something else.
The issue is really that the solution is frozen in time - a legacy solution.
For legacy solution issues, I typically setup a VM with the required software, make sure it works and periodically save a backup copy of the working image. Windows 10 Pro conveniently has Hyper-V available. That at least keeps things productive when issues arise.
Good luck!
The issue is really that the solution is frozen in time - a legacy solution.
For legacy solution issues, I typically setup a VM with the required software, make sure it works and periodically save a backup copy of the working image. Windows 10 Pro conveniently has Hyper-V available. That at least keeps things productive when issues arise.
Good luck!
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
GF
Active 7 days ago
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Do you use a spreadsheet like Microsoft's Excel? Have you ever wanted to link out to a non excel file on your computer or network drive? This is the way I found to do it!
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
Suggested Courses
Course of the Month11 days, 6 hours left to enroll
718 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.