This is kind of a twisted method so please forgive the lack of conciseness:
I have been using a VBA program in Excel in which one of the stages it captures a range of cells to the clipboard. The VBA program then launches AutoCAD and a LISP program pastes the data from the clipboard to an OLE object in the model space of the drawing. All of this happened on the same computer and it worked well and the resolution of the OLE object in AutoCAD is crisp and clear.
We have modified this process such that user starts Excel and the VBA code captures the range to a jpg file which is saved on the server. Another computer in the IT room launches AutoCAD and prepares the drawing and in then imports this jpg file. This too works well but the resolution of the graphic is degraded substantially.
Would there be a way to use VBA or VB.NET to somehow capture this clipboard data to a file and forgo the jpg file creation. We compared the two methods this morning and there is a severe drop-off in resolution which makes the image look not too professional.
If I had to I could save the Excel file temporarily on the server and then have a VB.NET program probe it to get the range into the clipboard on the IT room computer and repeat the paste process which results in true OLE object which comes into AutoCAD so much crisper and clearer.