vodkasoda
07-14-2010, 05:29 AM
I have an Excel VBA program that executes the following line ...
ThisWorkbook.FollowHyperlink MyNews
... unfortunately this is giving me a Run-time error 432 - "File name or class name not found during automation process"
The Variable MyNews is a valid and correct address (E:\VULCANO\Newsletter S9.pdf). I can open this file directly by clicking on it and it opens in Acrobat Reader 9.
This program and this line has worked perfectly OK for ages, but I have recently rebuilt my Windows Vista system (only the C: Drive, where the OS is based) and upgraded from Office 2003 to Office 2007 and it now doesn't work.
So, have I missed something in my rebuild, have I forgotten to do something to associate this line with a PDF file in my VBA program, is there something different in 2007 compared to 2003, or is it something completely different ?!?
Help :dunno !!!!!
ThisWorkbook.FollowHyperlink MyNews
... unfortunately this is giving me a Run-time error 432 - "File name or class name not found during automation process"
The Variable MyNews is a valid and correct address (E:\VULCANO\Newsletter S9.pdf). I can open this file directly by clicking on it and it opens in Acrobat Reader 9.
This program and this line has worked perfectly OK for ages, but I have recently rebuilt my Windows Vista system (only the C: Drive, where the OS is based) and upgraded from Office 2003 to Office 2007 and it now doesn't work.
So, have I missed something in my rebuild, have I forgotten to do something to associate this line with a PDF file in my VBA program, is there something different in 2007 compared to 2003, or is it something completely different ?!?
Help :dunno !!!!!