
12-18-2009 01:55 PM
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!