Cooperation with HI Process (Examples)
ArchView - Cooperation with HI Process
Within a workbook created by using the template ArchView.xlt, there is implemented the HIP_Interface module containing the procedures called from D2000 HI, if the workbook is opened as a report in it.
Procedures called from D2000 HI:
The procedures are listed along with their implementation.
'Parameters for HI process logon to D2000 Server processSub LogonFromHI(Name As String, Password As String, Server As String, User As String)' for VBAPI logon to D2000 system.'Name - user name'Password - user password'Server - parameter /S'User - parameter /W' in this case, the automatic call Auto_Open will not be executed' manual initialization Common.DefaultD2Server = Server Common.DefaultLogonName = Name Common.DefaultLogonPassword = Password Common.GlobalInitEnd Sub
Description:
The procedure above is called after opening a workbook in the process
D2000 HI
for initialization of own workbook. The parameters describe the way of user
logon. They are useful for initialization of
D2000 VBApi
interface.
Sub SetStringFromHI(sPar As String) ' change of parameters'sPar - user parameter adjustable from D2000 HIEnd SubSub SetNumsFromHI(I1 As Double, I2 As Double) ' change of parameters'I1 - user parameter adjustable from D2000 HI'I2 - user parameter adjustable from D2000 HIEnd SubSub SetTimesFromHI(sTime As Date, eTime As Date) ' change of parameters'sTime - user parameter adjustable from D2000 HI'eTime - user parameter adjustable from D2000 HI ThisWorkbook.Worksheets(DefaultDataSheetId()).Range(D2BeginArchTimeLabel).value = sTimeEnd Sub
Description:
The procedures are called from process D2000 HI
after entering the parameters for report.
For Time interval, there is called the procedure SetTimesFromHI.
In template It changes the begin time for report (cell
FromTime) in template.
For Numeric params, there is called the procedure SetNumsFromHI.
For String there is called the procedure SetStringFromHI.