Thank you very much for the help, worked great, except
The date they enter shows in the format 24/05/2012 whereas I need to use it in the file name as 'yyyy mmdd' with the space in the middle.
The bit of code I have is very simple.
Dim FBdate
FBdate = ActiveDocument.ContentControls(3).Range.Text
Do I need to specify FBdate as a date, and how do I then get the bits of it to get year, month, day or is there a function that does this.
As you can probably tell I am a novice at this.
Thanks
|