Text can't be paste into Excel automatically

J

Javier garcia

If a execute Excel from VB and I send the text to the
clipboard and use Sendkeys to simulate CTRL + V this don't
work. =(

Clipboard.Clear
Clipboard.SetText "My text", vbCFText

TasId = Shell("C:\Program Files\Microsoft Office\Office10
\Excel.EXE", vbMaximizedFocus)

AppActivate TasId
SendKeys "^V", False 'CTRL + V

If I use the notepad it works fine.

What can be the problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba constant value for "Unicode Text" in PasteSpecial function 0
Save Text file 2
Copy Paste in Excel 2007 3
How to copy non-contiguous columns to a text file 62
Can't Paste into Paint, any suggestions? 2
export to excel from access 2
Disable Cut/Copy/Paste in Excel 2010 0
Word text pastes as Adobe icon 1

Top