I have some reports that i need to pdf and then distribute. Is there a bit of code that can help me with the naming of the files? it is just manual right now, and that defeats the purpose really. Each file will be named based on the sheet (province names, ONT, NB, NS, SK, MP) name and the current date.
I've worked through the printing a PDF macro (not rocket science) but the naming is a little trickier (it's computer science).
Any suggestions for ways to do this?
Thanks very much,
Rob
I've worked through the printing a PDF macro (not rocket science) but the naming is a little trickier (it's computer science).
Any suggestions for ways to do this?
Thanks very much,
Rob