Using Macros was the only way I could find to scale the drawings so that they would plot accurately. With VBA you can directly modify the properties of EXCEL objects (such as the scale limits and physical dimensions of the plot area of a chart object).

Microsoft makes you buy the professional edition of EXCEL to get the help text that tells what those properties are. Fortunately for me, the company I work for owns a site license for the professional edition (along with a plotter), so I was able to work it out.

EdP