Screen updating hidden in vba
In fact, in this blog post, I go much further than simply showing you how to simply convert Excel files to PDF.
Among others, I also: If you want to download (for free) the Excel workbook containing all of the macro samples that I explain in this post, along with the sample PDF files showing the actual conversions, click here.
This particular Excel tutorial also focuses on the topic of working with Excel and PDF files.
You will have better success if you first understand how the application is pieced together.
In other words, you determine in which file format the new (resulting) file is saved by specifying it in the Type parameter.