2 Replies Latest reply on Apr 15, 2019 1:30 PM by gfmalek

    I want to build a list in ProcessBook VBA and export to an Excel file?

    gfmalek

      I would like to create a list of tagnames on a display and export them to an Excel file.  I suppose a generic .txt file would work too.  I cannot figure out how to open Excel via ProcessBook VBA however, much less export strings from one application to another.  I have read and tried a lot of methods that use CreateObject("Excel.Application") and they do not work.  Could this be due to the fact that the display is located on a shared drive and I am trying to open Excel on my own hard drive?

       

      P.S. I have enabled Microsoft Excel x.0 Object Library Reference for this display.  Also, it appears that the CreateObject is causing PB to freeze, and a message saying that the server is busy.

       

      Thanks for your help.