Jake104
MrPLC Member-
Content count
23 -
Joined
-
Last visited
Community Reputation
1 NeutralAbout Jake104
-
Rank
Sparky
Profile Information
- Country Denmark
Recent Profile Visitors
-
Slow performance of Write to tag from VBA
Jake104 posted a topic in Allen Bradley / Rockwell Automation
As part of a startup initialisation I want to set some 400 memory tags to a string value. I use this routine: Public Sub WriteValue(val As Variant, TagName As String, Fm As Display) Dim TG As TagGroup Dim WriteTag As Tag Set TG = Application.CreateTagGroup(Fm.AreaName) TG.Add TagName Set WriteTag = TG.Item(TagName) WriteTag.Value = val End Sub It Works well - but it is slow. Making about 400 writes takes 40 seconds. I thought maybe the creation of a taggroup before every write was slow (like it's done with the use of this WriteValue routine), so I tried making a taggroup with all 400 tags first, set active=true for this taggroup and then do all the writes. But it's equally slow. How do I speed up the writing of such memory text tags? I have a had similar read-issue - here the many individual reads is slow, but if I create a large taggroup with active=true - then reading is fast. I use FTview SE 7.0 on Win 7-64 -
Jake104 started following Slow performance of Write to tag from VBA
-
yep - it is quite well hidden - but can be found with Windows Explorer. But my question is rather: How do I get this folder location by accessing the API Object Model for the FTview application/project? I would like to get the folder name to use in VBA.
-
Jake104 started following Location of project file?
-
In VBA I would like to get the path to the location of the project file. In the project Explorer I can right-click the project and see the path for the "Project File" on the property pop-up. See attached screen dump. As this application will eventually run from a server it will most likely not be in the standard location on the C-drive. I would therefore like to get this path in VBA. How is that done? I use FTview 7.0 on Win7pro-64bit
-
FTview 7.0 - how do I make a Macro run a VBA-routine?
Jake104 replied to Jake104's topic in Allen Bradley / Rockwell Automation
I got the logic set up to run a macro based on an event. But can I make the macro run a VBA routine? That's my issue. I want to run VBA when my event occurs. If I can run a VBA-routine from a Macro - then i'm fine - but ideally I would just have the event run the VBA directly (without a Macro calling the VBA-routine). -
FTview 7.0 - general VBA module for the project
Jake104 replied to Jake104's topic in Allen Bradley / Rockwell Automation
I think we are not talking about the same thing. I want to have a VBA module (MyRoutines) with my own standard functions. These functions must be available to VBA modules in all my displays - therefore MyRoutines must be generally available and if I use one of the functions then it should jump to MyRoutines if I press Alt-F2 when the cursor is on the procedure name. It has nothing to do with the PLC - it's purely a HMI-VBA issue. -
FTview 7.0 - how do I make a Macro run a VBA-routine?
Jake104 posted a topic in Allen Bradley / Rockwell Automation
I would like a Macro to run a VBA routine (that I wrote for a special purpose). How is that done? -
FTview 7.0 - general VBA module for the project
Jake104 posted a topic in Allen Bradley / Rockwell Automation
I would like to have a general VBA module with general routines that I share between displays. When I e.g. create a button on a display and open the VBA for this button, then I can insert a module and write functions and procedures that I call from this button. But this module is nested below the particular Display - and not accessible to other Displays. Is there a way to access this module across all displays? -
FTview 7.0 - ho do I run a VBA routine every 5 seonds?
Jake104 posted a topic in Allen Bradley / Rockwell Automation
How do I set up a timer-based event? I would like to run e specific VBA routine every 5 seconds. How is that done? Can I somewhere define a timer on the FTview-application or on the Display to run a routine every 5 seconds? In iFix of WinCC I can just define a timer like this - and I looking for the equivalent in FTview. -
kaiser_will liked a post in a topic: FTview 7.0 - VBA and MS Office Chart 11
-
FTview 7.0 - VBA and MS Office Chart 11
Jake104 replied to Jake104's topic in Allen Bradley / Rockwell Automation
FTviewSE. And I kind of got it working now with VBA code and the chart object. -
FTview 7.0 - VBA and MS Office Chart 11
Jake104 posted a topic in Allen Bradley / Rockwell Automation
I have made an ActiveX Control with a Microsoft Office Chart 11. I would now like to add data series to the chart from VBA. I have previously done this in iFix - but the VBA code is not directly compatible with FTview. Does anybody know how to manipulate the chart object from VBA? A working VBA example would be very good. -
FTview 7.0 - Picture with constant header / footer
Jake104 replied to Jake104's topic in Allen Bradley / Rockwell Automation
Thank you! I had almost come to the same solution - but I shall investigate your trick with the 0,0 position on all three Pictures. I just place them on the absolute position when they all open. -
FTview 7.0 - how to display af picture
Jake104 replied to Jake104's topic in Allen Bradley / Rockwell Automation
Thank you for this. I can see that the Lab Manual may come handy as I explore FTview. Anyway - I had figured out that I could add a Picture to a button. And now - using the Image Tool I can place a Picture anyway on a Display! Thank you for your help. -
FTview 7.0 - how to display af picture
Jake104 replied to Jake104's topic in Allen Bradley / Rockwell Automation
I am looking in the manual - but have not found the answer to this question. As you can see from my other questions I am looking around for different issues. I know that ideally I should be properly trained and make exercises - but if I can just get answers to the very specific questions - then that would help me a lot. Since FTview is not completely intuitive (whatever that is...) sometimes quite simple tasks are difficult. However - if you know what to do - it's easy. So do you know how to insert a Picture on a Display? -
FTview 7.0 - how to display af picture
Jake104 replied to Jake104's topic in Allen Bradley / Rockwell Automation
I already did that - but how exactly do I then use it in my display? I have a Picture of my logo. I want to have it in the corner of my display. How is that don? I cant drag it from the Image library - and there is no "Insert"" menu point. -
FTview 7.0 - VBA instead of Macros
Jake104 replied to Jake104's topic in Allen Bradley / Rockwell Automation
I have made a button to change the on-screen language. This button performas an action where I use the command "Language" to change to Canadian-French. However - as I will eventually also have some logic in VBA, I would prefer all programming to be in VBA and not this mix of Macros/Button-configuration. So - how can I do this from VBA?