Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 05-24-2012, 12:55 AM
jillapass jillapass is offline Retrieving content control value Windows 7 32bit Retrieving content control value Office 2007
Novice
Retrieving content control value
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving content control value Move to next content control cksm4 Word VBA 13 07-02-2019 07:48 PM
retrieving notes in outlook that were deleted donbmar Outlook 0 05-21-2011 12:18 PM
Retrieving content control value content control Word 2007 TessaLee Word 1 03-11-2011 12:51 AM
Package for CD with links to Windows media player content and Flash Shockwave content hectorh PowerPoint 4 10-15-2009 12:22 PM
Templates: automatic text generation from Rich Text content control Chickenmunga Word 0 10-01-2008 11:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft