Pillar is installed on my computer. I can open it and run it.
I'm reading the Programmer's manual from Hyperion Pillar of how to automate Pillar. The directions for VB programmers are as follows:
Accessing PllrApi in VBOpen VB. Select Project | References
Select the PllrSrvr 2.0 Type Library check box (This establishes a reference to PllrSrvrLib which contains PllrApi)
To view the methods in PllrApi select View | Object Browser
I have added "C:\Program Files\...\PllrSrvr.tlb" to my class browser and can see PllrSrvr in the right pane with PllrApi showing as a class and iPllrApi listed as an "interface" with methods (open, save) and "tags" which look to me like properties (field delimiter, record delimiter - these are customizable in Pillar.)
Declare PllrApi as an object in your VB codePublic Pllr AS PllrSrvrLib.PllrApi
Sub Main()
Set Pllr = New PllrSrvrLib.PllrApi
frmMain.Show
End Sub
I SET LIBRARY TO "C:\Program Files\...\PllrSrvr.tlb"
I've tried just about every combination of PllrApi, PllrSrvrLib, iPllrApi, etc. that I can think of.
I can create a text file in the correct format and let my user click her way to adding the data (once or twice a year) but the management said "data could not be entered electronically" to this application and I can see that they don't know what they are talking about. ;-)
Thanks for any help.