<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Qing Xu wrote:<br>
</div>
<blockquote
cite="mid:CAFK-kEVeJsByhFRN1fCFu2jX77EY6pDzOpgf9zOfhPFjsKjOPA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hi All<br>
<br>
</div>
<div>Original code:<br>
<br>
<span style="font-family:courier new,monospace">import
win32com.client<br>
import win32clipboard<br>
from win32com.client import Dispatch<br>
<br>
ws_fc_ipn.PasteSpecial(Paste=-4163)</span><br>
</div>
</div>
</blockquote>
<br>
It would be better to use the symbolic names, like
win32com.client.constants.xlPasteValues. Or:<br>
from win32com.client import constants<br>
ws_fc_ipn.PasteSpecial(constants.xlPasteValues)<br>
<br>
<br>
<blockquote
cite="mid:CAFK-kEVeJsByhFRN1fCFu2jX77EY6pDzOpgf9zOfhPFjsKjOPA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
</div>
Wanted copy and paste special (paste value) to selection. Gave
me <br>
<br>
"<span style="font-family:courier new,monospace">Type Error:
PasteSpecial() got an unexpected keyword argument 'Paste' </span>"
<br clear="all">
<div>
<div><br>
</div>
<div>If anyone knows where the mistake is that would be great!<br>
</div>
</div>
</div>
</blockquote>
<br>
Named parameters should work, although you can always fall back to
positional parameters, like what I have above. What version of
Python and Python-Win32 are you using?<br>
<pre class="moz-signature" cols="72">--
Tim Roberts, <a class="moz-txt-link-abbreviated" href="mailto:timr@probo.com">timr@probo.com</a>
Providenza & Boekelheide, Inc.
</pre>
</body>
</html>