I have a problem I could use some help with. I am trying to create a macro to print my spreadsheet to a pdf file. I tried recording the macro and the code I have posted below is what was suggested. However, when I try to open the pdf file I get an error message that says the file is incompatable or corrupted. Any suggestions on how to fix this problem? The code I am using is placed within a "do" loop. My intent is that the name of the pdf file would be taken from the value in the cell named "FileName2".
Bookmarks