Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

How to generate FC or DB block with Excel

Created by: Magica at: 5/12/2014 4:57 PM (14 Replies)

Rating (3)

Thanks 7

Result pages:: |; 1 | 2; |

15 Entries

Entries per page: 10 | all

5/14/2014 2:30 PM	Rate (0)
Piotr.M Platinum Expert Joined: 6/24/2013 Last visit: 11/11/2024 Posts: 1652 Rating: (426)	Hi All I use excel for bulk tasks like boring "alarm reset" where alarms are in the data block: 1. display DB as data view 2. copy/paste to excel 3. in excel use =concatenate("R ALARMS.",<Cell_With_Name) where ALARMS is db symbolic name 4. paste this to LAD editor when switched to STL and other similar stuff. rest - better to do in LAD/FBD/STL editor because it will check syntax, etc.

Suggestion To thank Quote Answer

5/20/2014 12:46 PM	Rate (0)
OmegaProjects Silver Member Joined: 11/14/2008 Last visit: 5/6/2024 Posts: 504 Rating: (22)	Maybe this will help ? Attachment Create_S7DB.zip (1047 Downloads)

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users giovani32

5/29/2014 3:26 PM	Rate (0)
Magica Posts: 35 Rating: (0)	S7-FreshMan Maybe this will help ? Hello S7-FreshMan, Thanks so much for your reply.Your attached file is very similar to what I want to do.But I check the Excel in the attached I find there's no trigger sth like a button the user can press to trigger the program to work.Could you please give me more details? thanks!!!
Magica Posts: 35 Rating: (0)
Suggestion To thank Quote Answer

6/2/2014 8:29 PM	Rate (0)
sps-concept Gold Member Joined: 4/5/2006 Last visit: 8/13/2023 Posts: 642 Rating: (131)	Hello, i generate most of my blocks (also GRAPH) with Excel-macros / VB. e.g.: http://raeppel.de/download/sample/symcreator.zip http://www.raeppel.de/download/sample/vass_codegenerator.zip Regards André Räppel --------------------------------------------------------------------------------- www.raeppel.de work faster withinnovative PLC-Tools

Suggestion To thank Quote Answer

6/13/2014 3:58 PM	Rate (0)
OmegaProjects Silver Member Joined: 11/14/2008 Last visit: 5/6/2024 Posts: 504 Rating: (22)	When you go to Add-ins in Excel you can find a dropdownmenu Simatic. There you can choose to save it etc... Your welcome :)

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on