Connect to Citrix with VBA

Question

This is my first question here.

In my work, we connect to our internal network with smart cards.
Thus, when we want to connect to Citrix, we just open CheckPoint's Hammer (from all programs menu), then press ctrl+alt+delete and then type our personal password (for the smart card).

Since we don't have username and password for Citrix, I don't know how to connect automatically using VBA (i.e. from Excel).

I found a code that requires username and password, which I don't have (it starts well and then stucks):

Sub checkConnected()
    Dim cli As New WFICALib.ICAClient
    cli.SetProp "Address", "255.255.255.255"
    cli.SetProp "Username", "xxxxxxxxxx"
    cli.SetProp "Password", "xxxxxxxxxx"
    cli.SetProp "Domain", "xxxxxxx"
    cli.Startup
    cli.Launch = True
    cli.Connect
    Debug.Print cli.AUTHUsername
    Debug.Print cli.Connected
    Debug.Print cli.GetSessionCount
End Sub

I would love to get your Help. Thank you!

Answer 1

have you talked to your company IT/ data security team? Checkpoint Is usually there to secure corporate data, and the intention is that you cannot remove it from the internal network. Can you not use excel and access within Citrix to collect and present the data, rather than trying to pull the data off the network and onto your PC? Your IT team will be able to help you find the best and most secure way to do what you want.