First of all, I'm a rank novice and this was my very first VBA application. It worked great a year ago, then I upgraded from XP to Windows 7, and from Office 2003 to Office 2010, and from Photoshop CS2 to CS5. (All programs are involved.) The program no longer works; and I can't figure out what the problem is.
This program was designed to add images to my stock photography website. Once a tweaked picture was opened in Photoshop, I would open this XL spreadsheet with a button labeled "Add to FA website". Among other things the program would ask questions about location, keywords, title, and then it would add a logo to the image, shrink and sharpen to two different sizes (depending upon image orientation) and save them in the right locations, create a new HTML page and save that to the right location, and finally add a linked thumbnail image to a master index.htm page. All of this worked flawlessly for a couple of years.
Today after the aforementioned upgrades the program asks me what subdirectory to save it in, opens a blank Microsoft Word document (as it should), and then it hangs for about 20 seconds, after which it errors out with "Runtime error '429': ActiveX component can't create object". When I hit debug the highlighted line is "set objapp = CreateObject("Photoshop.Ap
I'm aware that the API for Photoshop CS5 changed somewhat when it came to printing an image; however none of that was invoked by my program.
I have a feeling this involves having to register an ActiveX DLL or an OCX, but I have no idea what nor any idea of how to do it. (And please don't laugh at my code - as I said this was my first project.) Something tells me this will be painfully obvious to most of you. Any insights welcome!
(Note: I couldn't find a 'VBA' zone to classify this in, so I chose the next closest thing.)