Create PDF with dynamic file path

[dark_prince69]

Hello,
I have found this code on the web but still can't seem to find a solution to this,
I want to create a pdf file with the filepath based on userform captions or sheets values like you can seen bellow but i can't seem to make it work and i don't know what i'm doing wrong.

Please Login or Register  to view this content.

[dotchiejack]

Without seeing the file or knowing the error you are getting?
What happens when you use this?

Please Login or Register  to view this content.

[nigelog]

Please Login or Register  to view this content.

do these give the expected results

[Kenneth Hobson]

It could be either of the two problems addressed.

1. The code is not in the Userform object and or the control objects reference names don't exist.
a. I seldom find need for Me.

2. Your pdf filename is not valid/legal.
a. MsgBox() is fine for debugging. I normally use Debug.Print and view a Run's result in VBE's Immediate Window.
b. Just because you create a drive:\path\filename.ext does not mean that the drive:\path exists nor that it uses valid characters and does not exceed character limits. Date strings can often cause this sort of problem. e.g. 8/30/2018

[nigelog]

Works here in a mock up