D
Dustin Ventin
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
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