sendkeys “{TAB}” is being ignored

i've created a .VBS file with the code seen below.

It works fine if I use it to fill in any form in a browser, and also works with Excel and Notepad.

However, it gives an error when used on an application installed on my system. The entire text is entered in a single cell. sendkey "{TAB}" doesn't work in this application.

Also, if I press Tab after using this, it moves to the previous cell instead of the next cell. The Shift key gets stuck there because of CAPITAL text I think.

Also, NUM LOCK key off sometimes while using this.

Can any one help with this?

set wshshell = wscript.CreateObject("wScript.Shell")
wscript.sleep 700
wshshell.sendkeys "TYPE TEXT 1"
wscript.sleep 400
wshshell.sendkeys "{TAB}"
wscript.sleep 400
wshshell.sendkeys "TYPE TEXT 2"
wscript.sleep 400
wshshell.sendkeys "{TAB}"
wscript.sleep 400
wshshell.sendkeys "TYPE TEXT 3"
wscript.sleep 400
wshshell.sendkeys "{TAB}"
wscript.sleep 400
wshshell.sendkeys "TYPE TEXT 4"
wscript.sleep 400
wshshell.sendkeys "{TAB}"
wscript.sleep 400

I am working on Citrix application. Yes tab key works in in where I am trying.

No application doesn't have any issue other software like Auto Hot Key is working fine

I think the problem is that your Excel macro is running in your Windows space and Citrix is a virtual desktop. I think this should work if you run your Excel macro from within Citrix. Does your Citrix desktop have Excel?