AnsweredAssumed Answered

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

Question asked by gfmalek on Apr 5, 2019
Latest reply on Apr 15, 2019 by 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.

Outcomes