Hi, all I am still pretty fresh in the Macro writing world and hit a problem I can not seem to solve. Our Sales team creates a folder named as a sales order number on a shared drive, we save all of our drawings as a PDF into a subfolder within that folder. My goal is to have a macro that uses a custom property that is the sales order number and puts it into the file path. I have everything I need to do this except I can not get the variable that pulls my custom property to write as part of the file path. Here is what I tried.
Here is the section of Code I am referring too:
Set swDraw = swModel
Dim Rev As String
Dim Folder As String
Rev = swModel.CustomInfo("Revision")
Folder = swModel.CustomInfo("Sales Order")
Filepath = "C:\Users\jhixon\Desktop\%Folder%\Submittals\"
FileName = Left(swDraw.GetTitle, Len(swDraw.GetTitle) - 10)
swDraw.SaveAs (Filepath + FileName + " " + Rev + ".PDF")
What am I doing Wrong?
A lot of this code is thanks to Deepak Gupta