+ Reply to Thread
Results 1 to 6 of 6

Writing VBA code but not in excel. for Proficy iFix. anyone and everyone please help

  1. #1
    Registered User
    Join Date
    04-06-2018
    Location
    america
    MS-Off Ver
    2010
    Posts
    30

    Writing VBA code but not in excel. for Proficy iFix. anyone and everyone please help

    Hi guys, I'm stumped here. I want to learn how to write VBA code but I'm completely stuck. It is either not getting to me or I'm just not getting the right sources to learn from. I want to understand VBA code what each period does, what each slash and dash and other symbols do. etc

    this bring me to ask for help with this project that I need to figure out.

    I'm using a software called Proficy iFix, they have VBA integrated in their software. its 1 to 1, which what I mean, whatever is in Microsoft vba that same stuff is in here.

    This software is used for SCADA and PLCs if anyone is familiar.

    But im confused about is that I'm trying to find help how to write the code for some stuff but cant seem to find an answers. examples that are given are given for excel or something else and do not work for that other software, etc.

    Maybe im just not doing something right? im sure I'm not

    I need to write a code to where I press a button on main screen that would take me to a different page at that page I have a drop down menu, which when pressed displays different options to click.
    This options are actually signals that are coming from equipment that this iFix software reads. So what I want is to have those options in the drop down menu to be linked to those signals that I mentioned. and when I press on an option I want data from the signal that is linked to that option to show on a graph, either as a line graph or a chart.

    that equipment I mentioned, it reads pressure and does real life reads

    so yehh basically I wan to be able to press on an option that would pop up a line chart or something on a graph.

    so for example lets say I would have a graph at the top right corner of the screen. it would have up most of the screen. and on the left side of the screen I would have the options to press, it could be a drop down menu, or it could be just names like hyperlinks that I press. but drop down menu Is better because we have hundreds of those options.

    hope im making sense. Please help. thank you

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Writing VBA code but not in excel. for Proficy iFix. anyone and everyone please help

    This is the first I've heard of VBA being used anywhere but in a Microsoft Office application.

    The power of VBA is in the object model for the application. I have no idea what the object model is for Proficy iFix, how it stores data, or anything else about it. So it's going to be hard to get help here, since we specialize in Microsoft Office. If you can point to some documentation for the Proficy iFix VBA object model we might be able to help you navigate it. But the information in your post is not even enough to get started.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Writing VBA code but not in excel. for Proficy iFix. anyone and everyone please help

    Hi Mike,

    Have you looked at this site?
    http://help.geautomation.com/iFIX58/...ction%7C_____0

    If you were doing this using Excel, you could record a macro and see what it looked like. I'm not sure that is possible with iFix.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    04-06-2018
    Location
    america
    MS-Off Ver
    2010
    Posts
    30

    Re: Writing VBA code but not in excel. for Proficy iFix. anyone and everyone please help

    Guys, thanks for even taking time to answers. I appreciate it. Sorry didn't reply earlier.

    Unfortunately these companies like iFix they like to keep their information hidden from public and customer. if you want to learn more you need to pay. I paid 4k for a one week course couple months ago and its was just an introductory course. lol

    From what I was told in that course, VBA in iFix has exactly same commands and stuff as VBA for Microsoft Excel. They have it licensed from Microsoft to be used in their application. based on that I assumed it should all be relevant.

    But still thanks to those who answered and will answer still.

  5. #5
    Registered User
    Join Date
    04-06-2018
    Location
    america
    MS-Off Ver
    2010
    Posts
    30

    Re: Writing VBA code but not in excel. for Proficy iFix. anyone and everyone please help

    Thanks Marvin, I've seen that page at some point. but for me for some reason its hard to understand those instructions because it seems those instructions are made more for those who are pretty comfortable with VBA. I'm still very new to all this.

  6. #6
    Registered User
    Join Date
    10-15-2019
    Location
    Norway, Oslo
    MS-Off Ver
    365
    Posts
    1

    Re: Writing VBA code but not in excel. for Proficy iFix. anyone and everyone please help

    Hi.
    I know this is kind of an old thread.
    But my day to day work is mostly working with ifix as a solution provider, and i could probably help if you have some problems.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Repeat code without writing same code
    By wrestlemy69 in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 01-27-2017, 06:49 PM
  2. re-writing VBA Code
    By ShakJames in forum Excel General
    Replies: 2
    Last Post: 02-13-2015, 11:05 AM
  3. Writing a Formula using R1C1 code in VBA code
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-15-2014, 11:06 AM
  4. [SOLVED] Need help writing Excel VBA code to copy and paste specific rows into a new worksheet
    By Ellen 2Excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-06-2013, 02:40 PM
  5. [SOLVED] User form in excel- need help in writing code with if/then statement
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2013, 08:04 AM
  6. Need help writing a C++ DLL for VB / Excel 2003 using Code::Blocks
    By sarahman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2009, 04:15 AM
  7. Importing XML into Excel 2000 without writing code
    By jjmmbb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-10-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1