VBA save as pdf with path and name on range. (1 Viewer)

[skdn71]

Hello

Could you please help how to fix this problem:

1. I am trying to write a VBA code to save a selected range to save as PDF and use a cell as the path and name for the file
with below VBA, the data will be saved on the same path =C:\Data\PDF Export\
Name = Student Result - 1002.pdf ( this example)

 

[June7]

Okay, so what is the issue with code - error message, wrong result, nothing happens?
Review https://stackoverflow.com/questions/67125689/export-the-excel-range-into-pdf

Use Dir() function in an If Then to check if folder exists. Use MkDir to create folder. https://www.access-programmers.co.u...directory-exist-and-create-a-directory.27374/