Hello,
I have a job at the moment to automate the generation of a lot of PDF's from various files and I have come across a problem. The files in question change every month so I have had to get creative with the formula so the cell always has the correct file names. The issue I have is this example below which as you can see is looking at a file path but all the variables have to be coded such as the year / month folder and the file name its self.
Now the file name is the part which is having the issue so an example file name is "19,05,10 SecuredFundingAgenda.docx".
The first part of the file 19,05,10 is the part that always changes. The 19,05 is easy as you can see I've got it looking at a cell which will contain this section but its the 10 that is causing a problem I have put "**" as I thought the ** would indicate 2 random numbers which I will never know what they will be and that tells Excel when its looking for that file path via VBA the numbers will vary so look for the numbers you know to be the beginning and then fill in that blank. However it is not working it simply doesn't pick up the name. where am I going wrong?
="\\companyname\department\team\Secured Funding Committee Meetings\Agenda"&TEXT(EDATE(TODAY(),-1),"YYYY")&""&$D$6&","&"**"&" SecuredFundingAgenda.docx"
Thanks in advance
I have a job at the moment to automate the generation of a lot of PDF's from various files and I have come across a problem. The files in question change every month so I have had to get creative with the formula so the cell always has the correct file names. The issue I have is this example below which as you can see is looking at a file path but all the variables have to be coded such as the year / month folder and the file name its self.
Now the file name is the part which is having the issue so an example file name is "19,05,10 SecuredFundingAgenda.docx".
The first part of the file 19,05,10 is the part that always changes. The 19,05 is easy as you can see I've got it looking at a cell which will contain this section but its the 10 that is causing a problem I have put "**" as I thought the ** would indicate 2 random numbers which I will never know what they will be and that tells Excel when its looking for that file path via VBA the numbers will vary so look for the numbers you know to be the beginning and then fill in that blank. However it is not working it simply doesn't pick up the name. where am I going wrong?
="\\companyname\department\team\Secured Funding Committee Meetings\Agenda"&TEXT(EDATE(TODAY(),-1),"YYYY")&""&$D$6&","&"**"&" SecuredFundingAgenda.docx"
Thanks in advance