creating pdf files with macro
 

Can anyone tell me how to create a PDF file in excel
using a macro. I have Acrobat 6.0 and Excel 2000. I am
using pcs with Windows 2000 and Windows XP.

I have seen these functions before but am not sure how to
use them or if they work.

ConvertToPDFA
CreatePDFAndCloseDoc
finalPDFFileName