Add date to existing output of pdf file

[ipbr21054]

Hi,

Here is the partial piece of code that is working & in use.

strFileName = "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY INVOICES\" & Range("N4").Value & ".pdf"

The file above once saved would be like 146.pdf

Now to expand a little there is a date i cell N13

Can you advise what the new line of code would be which would also include the date so it would be like

146_14/07/2019.pdf

Many thanks

 

[John_w]

'/' is invalid in file names, so you could have this:

    strFileName = "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY INVOICES\" & Range("N4").Value & Format(Date, "_dd-mm-yyyy") & ".pdf"

 

[ipbr21054]

Thanks I will tray that in the morning.
Can you advise a macro which can change all the other 145 files to match the same format other than me manually doing them one by one.

 

[ipbr21054]

Works well thanks