Excel macro - print to file
Posted by Sandy on July 17, 2001 1:29 PM
We're using MS Office 97, SR2. We're looking to take an entire spreadsheet and save it as postscript file to a particular directory. The code we're using is below. The problem is that it only saves the entire spreadsheet some of the time. The other times it saves just the worksheet. How can we get it to be consistent with saving the entire workbook as a postscript file?