Recent content by dhtguru

Basically, I am tabing and copying about 12 cells in a spreadsheet. I assign each cell a name and later I paste the values into a web based form.

I use it in a script that performs data entry. It copies cells in an Excel spreadsheet assigns it a variable name and then pastes the value as it reaches different locations on a page in a different system.

My company has locked down the security settings for IE8, so I can no longer enable scripting to use the clipboard. Is there a way to substitute using Word or Excel in place of IE? Here is what I am using now. Set objIE = CreateObject("InternetExplorer.Application")...

Thanks that seems to be doing the trick.

As you cand see I have tried Shift + F10 also, but it will sometimes loose its focus and the line and the script will fail. Wscript.Sleep 100 ' objShell.SendKeys("+{F10}") ' objShell.SendKeys "c"' objShell.SendKeys "^c"'...

The problem I am having with control+c for some reason. Sometimes it will paste the letter c in the field to be copied instead of performing a copy.

I don't have access to the HTML.

Thanks for the quick response. However, these two posts don't seem to address my issue. I am tabbing on a website and as I tab each area where I tab to is being highlighted. I need to be able to copy the highlighted data to the clipboard each time I tab. Without using Control + c.

I need to be able to copy highlighted text into the clipboard without using the above. I couldn't find anything in the forums that exactly matched what I needed. THanks