I'm not sure if this is a problem that excel VBA can solve or not.

So I have an excel file with a dozen or so worksheets. One page is inputs, then there are 2 different types of outputs and the rest are a bunch of tedious calculations and lookup tables.

Currently, we use this default excel file to just enter the data on the inputs tab, then we copy a section of the relevant output tab and paste it to AutoCAD as an OLE object. Then we print the AutoCAD drawing to PDF. The AutoCAD drawing contains a standard layout and default drawing just to demonstrate the geometry.

The PDF is printed from AutoCAD and has layers that can be activated or hidden from the pdf. There's a drawing at the top, and information about the project at the side. The red box is where I want the cells from excel to be.

Capture.JPG

I would like to cut out having to copy this to AutoCAD and instead print it straight to PDF. Is there any way to do this using excel vba? If not, does anybody have any suggestions?