Forum Discussion
Run-time error '-2147024894 (80070002)' Single Macros won't work on my laptop but works for others.
Hi I have Excel 365 W10 HP laptop. I have an excel file with lots of Macros in it. One single macros will not work, the error is Run-time error '-2147024894 (80070002)' Automation error. The system ...
JKPieterse the error is with this line
myShell.Run FolderName & FileName
Hi,
It is possible that on that particular machine there is a problem with the file association pertaining to pdf files. Rather than using the Shell command, can you create a hyperlink (for testing purposes, in an Excel cell) to the file in question and does it work? Can you open the file in question by double-clicking it in Windows explorer on the offending machine?
It is possible that on that particular machine there is a problem with the file association pertaining to pdf files. Rather than using the Shell command, can you create a hyperlink (for testing purposes, in an Excel cell) to the file in question and does it work? Can you open the file in question by double-clicking it in Windows explorer on the offending machine?
Hi Jan, Do you think my issue would be resolved if I restored factory reset my laptop?
Dannielle
- It might. As a workaround, you might also try this:
ActiveWorkbook.FollowHyperlink FolderName & FileName
JKPieterse I think you are correct with the error being with my machine and shell, hopefully there is a way to fix it. If I place a hyperlink in the database and click on it (jpg or pdf) it opens perfectly. as do all the files open via file explorer too.