How to use GETDATA in VBA with Application.run

    RE: How to use GETDATA in VBA with Application.run

    Hi!

    Source Code

    1. Application.Run("PALO.DATA", "localhost/demo", "Sales", "All Products", "Europe", "Year", "2002", "Variance", "Units")
    should do the work.
    Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

    Vladislav Malicevic
    VP Development & Support
    Jedox AG

    RE: How to use GETDATA in VBA with Application.run

    Hi,

    DATAT and DATA have the same result : #NUL!

    This is the code :
    firstRangeAtt.Offset(i, j).Value = Application.Run("PALO.DATAT", ServeurBase, Cube, firstRangeElmt.Offset(i, 0).Value, AttLabelRange.Offset(0, j).Value, tempsRange.Offset(0, j).Value)

    Post was edited 2 times, last by “davidhilbert” ().

    RE: How to use GETDATA in VBA with Application.run

    Tried with a simple example and got the (almost) the same problem. The result of the Application.run("PALO.DATAT") or Application.run("PALO.DATA") when reading Text-Elements is "Error 2000" in my case :( Seems we need some more help....

    Post was edited 1 time, last by “h_decker” ().

    RE: How to use GETDATA in VBA with Application.run

    Hi!
    DATAT is "area" function ... there is issue with all Palo Excel area functions which will be fixed in Palo 1.5 ... so you will not able to use this one ... However plain DATA should work … I’ve just tested it and it seams that it really doesn’t work with string values … I will get this fixed … unfortunately you will probably have to wait for version 1.5.
    Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

    Vladislav Malicevic
    VP Development & Support
    Jedox AG