Recent content by ponger

Oh no Paul, don't move aside! Ridders, the line is: MyFilename = "RESALL" & "_" & PIN & "_" & Format(Date, "yyyy-mm-dd") & "__" & Format(Date, "yyyy") & "_" & "WAIVER" & ".pdf" Minty, how should I add it in?? Sorry, I am complete novice when it comes to VBA.

The error message is: "The expression you entered refers to an object that is closed or doesn't exist" I updated my code with your recommendation Ridders but no luck. Thank you though! The double underscore and repeat of current year is needed because it correlates with the file formatting our...

I am trying to split my report into individual files using a specific naming format. I am able to run it correctly for the most part, however, whenever I add current date to the code it won't run anymore. I am getting a Run-Time error '2467'. Can someone help me find out why my date code is...