Use Excel VBA to control program open via Citrix

[ExcelVBAJunkie]

Hello,

Using Excel VBA I am trying to use “SendKeys” to send keystrokes to a program that was opened via Citrix. The program via Citrix is open and running actively on my computer. I am trying to use Excel to send commands to the program.

Steps I normally do. Go to Citrix and select the program I want to use. Program log in screen pops up at which point I log in using my credentials. Once logged in, I select “F10” on my keyboard to access the menu. Next I select a letter such as “s” from the keyboard which prompts the program to open a menu.</SPAN>


With Excel open locally on my machine I am attempting to send the “F10” and “s” keys but it is not registering on the program. When I do it manually via the keyboard everything works as expected. I attempted to install Excel on Citrix and run both Excel and the other program via Citrix. To my surprise the “SendKeys” commands all work. The problem is that I can’t keep Excel on the Citrix environment. I have to use the local Excel program to accomplish these steps.</SPAN>

The following commands are what I’m using…</SPAN>

Public Sub PullAndSetUp_Master_Schedule_ForEdits()</SPAN>

Application.Wait (Now + TimeValue("0:00:01"))</SPAN>
SendKeys "{F10}", True</SPAN>
DoEvents</SPAN>
SendKeys "{s}", True</SPAN>
DoEvents</SPAN>
SendKeys "{m}", True</SPAN>
DoEvents</SPAN>

End Sub</SPAN>

I searched for threads all over and have found others that are having the same issue but none of the threads have any solutions via VBA.</SPAN>

Thank you in advance for any help you are able to provide.</SPAN>