I am working on a project which up until recently used Excel VBA and AutoCAD. To the point, one of the important things this process did was grab a range of cells in the Excel file and copy them to the clipboard. This range of cells was a nicely formatted table with borders, cell filled colors, etc... and the VBA code would copy it to the clipboard before laumching AutoCAD. Once AutoCAD was opened a LISP program would automatically paste this into the model space. It made a lovely OLE object in AutoCAD with crisp, clear appearance.
We are now trying to do away with the VBA part in favor of .NET. I am really at a loss to explain why the code I used before will not work, nor will anything else I try: