We have been trying to create a macro in MS Excel 97 that will create a PDF based on the current print area. A button on the sheet will call the PDFwriter to start the process. The macro is empty when we try to record the process of File, Create Adobe PDF. We are having problems writing the macro from scratch as well. Any ideas? Any help will be appreciated. Thanks.
--Kurt
--Kurt