Topic: Copy Excel Range to the Clipboard

[Bill Tillman]

I need to get the contents of a range in an Excel spreadsheet into the clipboard but can't seem to get it right.

Code: [Select]

vExcelRange1 = vExcelSheet2.Range("B1:K93")
vExcelRangel.Copy()

This works but only if I keep the Excel app open. I need a method of keeping the clipboard contents static until I can copy it into AutoCAD, which is after I close down Excel.

I've tried this as well, but for some reason the clipboard data is not available to me once Excel closes down

Code: [Select]

vExcelRange1 = vExcelSheet2.Range("B1:K93")
Clipboard.SetDataObject(vExcelRange1, True)


[Drafter X]

not positive this will work, I may have the states reversed but before you exit excel add this maybe

Application.CutCopyMode = False
Application.DisplayAlerts = False



if it doesn't work try changing the first one to true.. been a while and I am away from excel.

[Bill Tillman]

Thanks but that did not work in either form. True or False. Still hacking at this.

[Drafter X]

hmmmmm....  im grasping at straws here but...

how about..

Application.EnableEvents=False
 your code here



and last line of code...
Application.EnableEvents=True

[Bill Tillman]

I am using DisplayAlerts=False and when I set it to true, the alert does popup allowing me to save the clipboard contents for later use. Still it's a difficult call to understand why in VBA code this same process is so simple and works like a champ. But from VB.NET this is all but impossible. I found that by launching AutoCAD I could copy the clipboard into the model space but the formatting, borders, colors, etc... are all missing. No gridlines or nothing like when we were running this from a macro with Excel.

Oh yes, I tried the suggestion in your second post and it was not the answer. Thanks anyway.

[Drafter X]

dunno, did see this article, maybe it is related?
http://www.fmsinc.com/MicrosoftAccess/Errors/ExcelPaste/Clipboard.html