Forum Discussion

Dellehurley's avatar
Dellehurley
Copper Contributor
Nov 20, 2020

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 ...
excel
Macros and VBA
office 365
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 20, 2020
What does Dir(FolderName & FileName) return?
  • Dellehurley's avatar
    Dellehurley
    Copper Contributor
    Nov 23, 2020

    JKPieterse Hi Jan, I am not 100% certain what you mean.

     

    If I watch FolderName & FileName I get the correct path to the document.

    eg. Watch : : FolderName & Filename : "C:\Users\delle\Dropbox\Genealogy\Family Tree\FMa4216.pdf" : String : FrmForm.lstDatabase_DblClick

     

    If you meant for me to edit to macros to Dir(FolderName & FileName) it comes back as only the file name.

    eg. Watch : : Dir(FolderName & Filename) : "FMa4216.pdf" : String : FrmForm.lstDatabase_DblClick

    If I have misunderstood please let me know.

    D

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Nov 23, 2020
      On which line of the code does the error occur precisely? (which line is yellow when you click Debug)?
      • Dellehurley's avatar
        Dellehurley
        Copper Contributor
        Nov 24, 2020

        JKPieterse the error is with this line

        myShell.Run FolderName & FileName

Resources