VBA Is it possible to open and print a text file to pdf?

[dreid1011]

Good morning,

I am trying to make a few processes at work a bit more efficient. One of them requires me to print a set of text files to pdf. Right now, I can do it one of two ways:

Open each file and print to pdf one at a time.

or

Change my default printer to the pdf printer and right click + print each text file one at a time.

I've been poking around, but so far I have come up empty. I can open the files as TextStream objects, but can I print them?

Thank you,

 

[Domenic]

That's great, I'm glad you were able to work it out. Minor point, though. Since you're already referencing the active document using the "With/End With" statement, you can replace...

Word.ActiveDocument.Saved = True

with

.Saved = True

 

[dreid1011]

That's great, I'm glad you were able to work it out. Minor point, though. Since you're already referencing the active document using the "With/End With" statement, you can replace...

Word.ActiveDocument.Saved = True

with

.Saved = True

Ok, I'll give that a try. I may have misinformation that that syntax didn't work for some reason.

Edit: And that would be the case. Don't believe everything I read. Thanks again!

 

[Domenic]

You're very welcome!

Cheers!