FactoryTalk View SE and Excel

mgallgood

Member
Join Date
Dec 2016
Location
Tennessee
Posts
19
First, a little about me.
This is my first real post here (I did a practice post a minute ago).
I've been out of the PLC game for a little over 7 years. I've been working fairly exclusively with Schneider Electric software during that time. I've got a new job and a new project that utilizes FT View SE.

Now my issue and question(s)?
This is an existing system. It is a distributed system (a View SE Server, a FT Directory Server, a Terminal Server for SE Clients, etc.)The customer currently has a spreadsheet where they are checking the status of CIP and Flushes on assets in their system to ensure the proper cleaning was done between batches. This is a manual validation process. They want to automate this via their existing View SE system. In short they want a screen that mimics the input worksheet in the spreadsheet. The operator would enter the last and next formula numbers here. The screen would then write this information to the spreadsheet and then read out the required cleaning steps. The screen would read that information and enumerate these into integer values and pass those to the PLC controlling the asset. The PLC code would then compare the required cleaning steps with the cleaning that has actually been completed and enable or inhibit the next batch accordingly.

I'm not familiar with View SE (although I had used Me a decade ago). So my questions currently are generally what is the best method to accomplish the spreadsheet interaction from SE? Since the clients are run on the terminal server where is the best place for the spreadsheet to "live" (on the terminal server, etc.)? Looking at the SE server, Excel is not installed and therefore there is not Microsoft Excel reference library to enable in the VBA editor. How do I enable that so that the Excel object model is available?

I have a lot more questions but I'll stop here and hope that I at least get some answers that will get me started. Some of the other answers will reveal themselves as I start moving forward.

Thanks in advance for any helpful advice!
Mike
 

Similar Topics

Hi, I'm trying to export data from a DataGrid to Excel using VBA, but I'm getting an error "Object doesn't support this property or method". The...
Replies
0
Views
63
Is there a way to export a value to an excel sheet without using VBA? I would like to write a single 8 digit number to an excel sheet (location...
Replies
3
Views
3,844
Hello to all, I would like to implement an 'interface' between FactoryTalk ME application and Excel. The sequence will be the following: The user...
Replies
7
Views
7,823
Hi, I want to display Factory talk SE tag values in Ms excel. Can any one tell syntax for the same. Thanks In Advance, Vinod B. Bansode
Replies
0
Views
3,889
I'm looking for a better solution to place the values of 100 SLC N7 tags on an excel spreadsheet from a FactoryTalk View SE display VBA...
Replies
32
Views
48,681
Back
Top Bottom