Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Silver Contributor
Posts: 835
Registered: ‎03-24-2009

Citrix \Terminal Server clamping down on an IE shell call from vbScript

For an SLX vbScript I'm using the Internet Explorer shell to copy a mass of tab delimited data to.....

 

Then I paste that data to Excel or MS Word.....works great.....

 

In IE, if you go into the Security Options and turn off access to the clipboard and scripting in the Internet settings, you can shut this down Pronto.

 

so on individual user's machines, we allow the scipting and everything is fine.

 

Not so in Citrix however....is there somewhere else to look? Maybe an overall Citrix 'Stop The Script' 'feature' that overrides the local users choice for lower Internet security???

 

here's the exact script if this will help:

 

        ''''put the string into the windows clipboard.
        DIM  oSHELL, objHTM
        set oShell = CreateObject("WScript.Shell")
        Set objHTM = CreateObject("htmlfile")

        objHTM.ParentWindow.ClipboardData.SetData   "text", MText
        'paste it into Excel.
        objExcel.Range("A2").SELECT
        objExcel.ActiveSheet.Paste
        SET oRegEXP     = NOTHING

 

THANKS!

RJ Samp