Excel VBA General QUESTION

[AnilPullagura]

Hey Folks,

I have an interesting(atleast for me) question?

Excel 2007 professional edition.

• Can we control external applications using Excel VBA? Applications connected with CITRIX Client
• If so, How?
• Is the reference "Microsoft Shell Controls and Automation" the correct one to do this?

Any help on this is greatly appreciated.

Thanks,
Anil

 

[tweedle]

I've tried multiple, multiple times without succcess.
Because everything is running in the citrix environment, there are no objects exposed to the local machine (Other than the client, of course).
But from there, it's not really term. server, so sendkey commands are useless if not tedious and mousecontrol APIs are too reliant on the citrix client window to perform reliable screen click calcs; then they rearrange the desktop icons making it completely unreliable, and of course nothing is exposed outside the client (that would rather defeat the purpose).
I've wasted a lot of my time hunting to no avail.

Maybe I just never found the correct combo of technology, but I'm resolved the fact that the engineers at Citrix are smarter than I.

If VBA is available within the client, then life is EZ.

That's my story.
[30]

Edit: Theoretically, one could get the parent window of the citrix client and possibly iterate every child window with Win-API (AOL hacks use to do this): I was never that motivated.

 

[AnilPullagura]

BUMP!!!!! just to make sure that everyone has checked this question