Runtime Error 429 - Citrix

[xlStar]

I have a VB6 program which work for years until recently my company has moved from PCs to Citirx Environment using WYSE terminals (we no longer have PC now).

This means that all the software are installed centrally on a server instead of C:\ drive (base PC).

Unfortunately this has upset the VB6 program which was written by ex-colleague; this is the extract of the codes that doesn't work on Citrix environment but works on PC..


Private Sub Command1_Click()
Dim pExcel As Excel.Application

Set pExcel = GetObject(, "Excel.Application")
If pExcel Is Nothing Then
GoTo Err
End If

pExcel.Visible = True

Exit Sub
Err:
MsgBox "Error - Can't find Excel"
End Sub




I have searched all over google for the solution but no avail. They all said you need Excel on C:\ but provided no alternative VBA codings for Citrix.

If it any help, the CITRIX boot drive is on drive Z although we can not able to expand the subfolders/files from this drive.

Basically I need to get opened Excel with the reference to drive Z and not C. I am not part of IT department by the way.

Can anybody help?

 

[SkipVought]

hi,

This forum is forum707.

You might want forum222.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

the codes that doesn't work on Citrix environment but works on PC..

what do you mean by 'doesn't work on Citrix'?

Do you get an error? If so, what error are you getting? Which line of code creates the error? (error handler would be nice to have in your code)

Have fun.

---- Andy