View Single Post
 
Old 05-24-2012, 12:55 AM
jillapass jillapass is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Dec 2011
Posts: 26
jillapass is on a distinguished road
Default

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
Reply With Quote