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.