AvevaWorld Summit
+ Reply to Thread
Page 4 of 4
FirstFirst ... 2 3 4
Results 31 to 38 of 38

Thread: Reports....

  1. #31
    Premium Member Site Level Shrivallabha's Avatar
    Join Date
    Jun 2009
    Location
    Tokyo, for a while ;0
    Posts
    214

    Another Cup of Tea

    Excel VBA is very powerful tool akin to pml in PDMS. And it needs some work before you can do something meaningful out of it. It was just that I was working on this and your example came across. I'm posting the file herewith.

    1. In Excel, Go To Tools >> Macros >> Security and set it to Medium. Exit Excel.
    2. Then open the file that I've posted on this forum. I've written the steps in the file.

    And Yes, you can see the edited by pressing ALT + F11 (Visual Basic Editor). And should that increase your curiosity then there are forums for this. One of the best is VBAX.

    I hope the file helps you in your cause.
    Attached Files

  2. #32
    Premium Member World Level NEILD's Avatar
    Join Date
    Sep 2006
    Location
    Newcastle
    Posts
    1,881
    Thankyou very much for sharing this with me.
    It worked very well.

    Cheers
    Neil

  3. #33
    Premium Member Pipe Level sahaja's Avatar
    Join Date
    Nov 2006
    Location
    INDIA
    Posts
    20
    Hi

    I am learning PML.I want to learn report customization using PML.Someone guide me what to learn in PML for reports customization with some examples

  4. #34
    Premium Member World Level NEILD's Avatar
    Join Date
    Sep 2006
    Location
    Newcastle
    Posts
    1,881
    To start with you need to become a premium member to access all the pml section of this web site...

    There is a excellant section for collections under it...

    When you have collections mastered you need to use evaluations (to manipulate the collections)...a bit of maths and know how to write to a text file....

    Cheers
    Neil

  5. #35
    Premium Member Pipe Level sahaja's Avatar
    Join Date
    Nov 2006
    Location
    INDIA
    Posts
    20
    Hi Neil
    Thanks.I'll definitely subscribe for premium membership.Just looking for international creditcard which i dont have.

    Meanwhile can you send me some report formats and PML code for them as good practice for my learning

  6. #36
    Moderator Forum Moderator yar_nl's Avatar
    Join Date
    Apr 2006
    Location
    the Netherlands
    Posts
    1,629
    I believe you can use PayPal too for premium membership.

  7. #37
    Pipe Level uisa's Avatar
    Join Date
    Feb 2009
    Location
    Nigeria
    Posts
    23
    cool stuff well how can I master excel VBA? Is it tough to learn?

  8. #38
    Premium Member World Level pitch's Avatar
    Join Date
    Mar 2006
    Location
    Middlesbrough UK
    Posts
    1,268

+ Reply to Thread
Page 4 of 4
FirstFirst ... 2 3 4

Tags for this Thread