Forum Discussion

Sivilay's avatar
Sivilay
Copper Contributor
Sep 03, 2021
Solved

Excel macro

Hi, I want to know how to run Excel macro/ vba on cell, i mean macro contents writing on the cell. See photo attached
  • Sivilay 

    A macro sheet, as shown in your photo, is outdated. It was used in Excel 4.0 (released in 1992!) and earlier. Since Excel 5.0 (released in 1993), VBA has been the standard programming tool in Excel.

    Although macro sheets are still supported, I would not recommend creating and using them.

6 Replies

  • Sivilay 

    A macro sheet, as shown in your photo, is outdated. It was used in Excel 4.0 (released in 1992!) and earlier. Since Excel 5.0 (released in 1993), VBA has been the standard programming tool in Excel.

    Although macro sheets are still supported, I would not recommend creating and using them.

    • Sivilay's avatar
      Sivilay
      Copper Contributor
      Hi hans vogelaar, thank you for information
      • Sivilay's avatar
        Sivilay
        Copper Contributor

        Hi Microsoft team,

        Could you please help me for the VBA issue?

        After upgrade office 2013 to office 2019, i have a issue while opening excel book as show below

        1. Could not load an object because it is available on this machine. I have click the close 15 times after that onec pop up as below

        2. Copile error in hidden module: PIDL_API. This error commonly occures when code is incompatable with the version, platform, or architecture of this application. cilk *Help* for information on how to correct this error.

        Note: I also use PI datalink in this excel workbook

         

        Thank you in advance

        Sivilay

Resources