Hello,

I've looked through the web to learn that if I want to convert Excel to PDF
and give it a specific name (automatically) through macro I should use

....printout PrintToFile:=True, PRtoFileName:="I/....xx.pdf"

But there's an error accessing the created pdf. It's all due to PrintToFile
functionality. If I change destination file name extension to .prn, then it
works.

However, when I double click on this .prn file it asks me to choose a
program. It then converts it to adobe acrobat file.

It's there a more direct way to create from excel to pdf and having file
name as variable? My intention is to create batches of pdfs from excel and
through macro emailing out to people. I want to skip the step of converting
from .prn to .pdf (haven't figured how I would do it).

Thanks,
Carmen