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