 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / September 2007Date Format
I have a form with a bookmark called currentdate. I want to use VBA to add the current date in the format of September 27, 2007. Everything I have tried has given me an error. Can someone help with the syntax on this? Thanks for your help. >I have a form with a bookmark called currentdate. I want to use VBA to add >the current date in the format of September 27, 2007. Everything I have >tried has given me an error. Can someone help with the syntax on this? > >Thanks for your help. If the bookmark's name is myDate, this will do it: ActiveDocument.Bookmarks("myDate").Range.Text = _ Format(now,"MMMM dd, yyyy") If you want the bookmark to still be available afterwards, see http://www.word.mvps.org/FAQs/MacrosVBA/InsertingTextAtBookmark.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. Jay, thanks so much for your response. I just knew that was what I needed . Unfortunately I put it in my code and I am getting the same error as before. The error that I am getting is: Wrong number of arguments or invalid property assignment. It stops with "Format" highlighted. This is the part of the code that I thinks affects this: Dim odoc As Word.Document Set odoc = Documents("allnotices.doc") odoc.Bookmarks("currentDate").Range.Text = FORMAT(Now, "MMMM dd, yyyy") I have several other variables and bookmarks and they are all working OK. But a simple date has got me stumped. Can you tell what I am missing from this? There is one issue that might also affect it. I am working with a document called Allnotices. Under certain circumstances, another document is inserted into my current document (thus becoming part of Allnotices.) That inserted document is the one that has the bookmarks. Would the fact that the second part of the document is not there when it compiles have any effect on this? It does not seem to affect any of the other variables, but they are all inputs of one sort or another. Hopefully I just don't have something declared and it will be a simple fix. (Or maybe there is a better way to do this. What I am trying to avoid is having the user input the date.) Thanks for your help. > >I have a form with a bookmark called currentdate. I want to use VBA to add > >the current date in the format of September 27, 2007. Everything I have [quoted text clipped - 15 lines] > Microsoft Word MVP FAQ: http://word.mvps.org > Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. I don't believe the location of the bookmarks has anything to do with the error. If VBA couldn't find the bookmark, you'd get a different error, "The requested member of the collection does not exist". The Format function is built into VBA. If you put the cursor on the word Format in your code and press F1, you should get the Help topic about the function, which shows the proper syntax. It has one required argument and three optional ones, so passing the first two ("expression" and "format" in the syntax statement, corresponding to Now and "MMMM dd, yyyy" in your code) is completely OK. What could be happening -- though it's a low probability -- is that you have another Format function defined by some code in your template or a global add-in, and VBA is looking at the argument list in that function's definition. Does the word FORMAT really appear in all caps in your code? If so, that's a clue that something like that is wrong, as the built-in function's name is automatically changed to Format.  SignatureRegards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. > Jay, thanks so much for your response. I just knew that was what I > needed . Unfortunately I put it in my code and I am getting the same [quoted text clipped - 47 lines] >> Email cannot be acknowledged; please post all follow-ups to the >> newsgroup so all may benefit. If it is a form field that you want to insert the date into then ActiveDocument.FormFields("myDate").Result _ = Format(Now, "MMMM dd, yyyy") will do that Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I have a form with a bookmark called currentdate. I want to use VBA > to add the current date in the format of September 27, 2007. > Everything I have tried has given me an error. Can someone help with > the syntax on this? > > Thanks for your help.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.