Hi,
Very new to VBA and currently using to the below code to create a folder and pdf from one worksheet within excel.
Sub APOrderForm()
Dim myDir As String, myDirSub As String, mySht As String, c As Range
myDir = "P:" & ActiveSheet.Range("C16").Value
mySht = Range("C16").Value
On Error...