Pastespecial with Late Binding
You can also get away without Pastespecial or any enumerated constants
With ExcelApp.Selection
.Value = .Value
End With
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Harald Staff" wrote in message
...
Hi Dustin
Stuff like xlPasteValues is most often enumerated numeric constants, which
are not recognized using late binding. The object browser in the
application
(here Excel) is your friend then. Search for xlPasteValues and you will
see
Const xlPasteValues = -4163 (&HFFFFEFBD)
now replace the constant xlPasteValues with the real value -4163 in your
code, and it should in theory work (it's past midnight here, so I didn't
test this). Likewise Const xlNone = -4142
HTH. Best wishes Harald
"Dustin Ventin" skrev i melding
...
I'm writing a Microsoft Access application that integrates with Excel,
and
automatically makes Excel do various things using a late-bound
Excel-type
object.
Like so:
Dim ExcelApp As Object
Set ExcelApp = CreateObject("Excel.Application")
Now, I'm trying to select a range of fields and paste only the values
into
another worksheet. My code works fine when I'm not using late-binding,
but
when I am it starts complaining:
"Pastespecial method of Range class failed."
I've tried several variations, neither work:
ExcelApp.Selection.Pastespecial Paste:=xlPasteValues
ExcelApp.ActiveSheet.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone,
SkipBlanks :=False, Transpose:=False
Any ideas? Additionally, since it is quite possible that I will be
doing
a
lot more work in late-binding with Excel, is there any way I can
troubleshoot
these kind of problems without bothering you guys?
Thanks!
Dustin
|