Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Document Date Change
My office is using Office 2000 (Word) on XP Pro. I have created many, many
form files/documents that "merge" with Excel via DDE to a finished/new document that is saved to various other folders under a new file name. The form files and excel database are located on our server for every user to access. I originally inserted a date field (via the insert menu) into each new form file I created. However, that causes a problem at the saving end of the newly created document. We need the document to maintain its date at creation and not have the date updated automatically upon reopening the file a month later. I removed the inserted date field from each form file manually (one at a time) and now the process is that each user opening the form file has to type in the correct month, day, and periodically year. That would be reasonable except that the form files are "read only" for everyone but the administrator. So if you open the same file several times in the same day, you have to retype the correct date each time you open it. Frustrating for those that are under the "read only" choice. Is there a way to either globally change the date on all of the form files without causing the DDE link to drop with the database? It would be great if there were an auto date update that once the "new" document was created and saved would not auto update with each new opening of that "new" document that was saved. Can anyone point me in the direction to deal with this problem. We have hundreds of form files. I do not want to manually change the month on each file individually with each new month of the year. Thank you, -- John R. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Document Date Change
Change the DATE fields to CREATEDATE fields. It's going to be a nuisance for
the documents already created, but easy to fix for the future. How did you come to create "many, many" documents without testing that your system worked? "John" wrote in message ... My office is using Office 2000 (Word) on XP Pro. I have created many, many form files/documents that "merge" with Excel via DDE to a finished/new document that is saved to various other folders under a new file name. The form files and excel database are located on our server for every user to access. I originally inserted a date field (via the insert menu) into each new form file I created. However, that causes a problem at the saving end of the newly created document. We need the document to maintain its date at creation and not have the date updated automatically upon reopening the file a month later. I removed the inserted date field from each form file manually (one at a time) and now the process is that each user opening the form file has to type in the correct month, day, and periodically year. That would be reasonable except that the form files are "read only" for everyone but the administrator. So if you open the same file several times in the same day, you have to retype the correct date each time you open it. Frustrating for those that are under the "read only" choice. Is there a way to either globally change the date on all of the form files without causing the DDE link to drop with the database? It would be great if there were an auto date update that once the "new" document was created and saved would not auto update with each new opening of that "new" document that was saved. Can anyone point me in the direction to deal with this problem. We have hundreds of form files. I do not want to manually change the month on each file individually with each new month of the year. Thank you, -- John R. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Document Date Change
I was just plucked and assigned with a very, very short time frame -
tomorrow!. This is not my area of interest or expertise, just the busiest person in the office and expected to "add" to my responsibilities. Not complaining as I have managed to learn all sorts of new things. But, not having time to actually research, understand, play, and test things makes the job a bit more challenging! Thank you for your help. I will give your suggestion a try. John "Jezebel" wrote: Change the DATE fields to CREATEDATE fields. It's going to be a nuisance for the documents already created, but easy to fix for the future. How did you come to create "many, many" documents without testing that your system worked? "John" wrote in message ... My office is using Office 2000 (Word) on XP Pro. I have created many, many form files/documents that "merge" with Excel via DDE to a finished/new document that is saved to various other folders under a new file name. The form files and excel database are located on our server for every user to access. I originally inserted a date field (via the insert menu) into each new form file I created. However, that causes a problem at the saving end of the newly created document. We need the document to maintain its date at creation and not have the date updated automatically upon reopening the file a month later. I removed the inserted date field from each form file manually (one at a time) and now the process is that each user opening the form file has to type in the correct month, day, and periodically year. That would be reasonable except that the form files are "read only" for everyone but the administrator. So if you open the same file several times in the same day, you have to retype the correct date each time you open it. Frustrating for those that are under the "read only" choice. Is there a way to either globally change the date on all of the form files without causing the DDE link to drop with the database? It would be great if there were an auto date update that once the "new" document was created and saved would not auto update with each new opening of that "new" document that was saved. Can anyone point me in the direction to deal with this problem. We have hundreds of form files. I do not want to manually change the month on each file individually with each new month of the year. Thank you, -- John R. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Document Date Change
Try the following macro on *copies* of your documents in a dedicated folder
for the purpose. It opens each document, changes the Date fields to Createdate fields and updates that revised field. If the field is indeed a Date field and not a linked field, this should do the job. Sub FixAllDates() Dim myFile As String Dim PathToUse As String Dim MyDoc As Document Dim iFld As Integer Dim i As Long With Dialogs(wdDialogCopyFile) If .Display 0 Then PathToUse = .Directory Else MsgBox "Cancelled by User" Exit Sub End If End With If Documents.Count 0 Then Documents.Close SaveChanges:=wdPromptToSaveChanges End If If Left(PathToUse, 1) = Chr(34) Then PathToUse = Mid(PathToUse, 2, Len(PathToUse) - 2) End If myFile = Dir$(PathToUse & "*.doc") While myFile "" Set MyDoc = Documents.Open(PathToUse & myFile) ActiveWindow.View.ShowFieldCodes = True For iFld = ActiveDocument.Fields.Count To 1 Step -1 With ActiveDocument.Fields(iFld) If .Type = wdFieldDate Then .Code.Text = replace(.Code.Text, "DATE", "CREATEDATE") .Update End If End With Next iFld ActiveWindow.View.ShowFieldCodes = False MyDoc.Close SaveChanges:=wdSaveChanges myFile = Dir$() Wend End Sub John wrote: I was just plucked and assigned with a very, very short time frame - tomorrow!. This is not my area of interest or expertise, just the busiest person in the office and expected to "add" to my responsibilities. Not complaining as I have managed to learn all sorts of new things. But, not having time to actually research, understand, play, and test things makes the job a bit more challenging! Thank you for your help. I will give your suggestion a try. John "Jezebel" wrote: Change the DATE fields to CREATEDATE fields. It's going to be a nuisance for the documents already created, but easy to fix for the future. How did you come to create "many, many" documents without testing that your system worked? "John" wrote in message ... My office is using Office 2000 (Word) on XP Pro. I have created many, many form files/documents that "merge" with Excel via DDE to a finished/new document that is saved to various other folders under a new file name. The form files and excel database are located on our server for every user to access. I originally inserted a date field (via the insert menu) into each new form file I created. However, that causes a problem at the saving end of the newly created document. We need the document to maintain its date at creation and not have the date updated automatically upon reopening the file a month later. I removed the inserted date field from each form file manually (one at a time) and now the process is that each user opening the form file has to type in the correct month, day, and periodically year. That would be reasonable except that the form files are "read only" for everyone but the administrator. So if you open the same file several times in the same day, you have to retype the correct date each time you open it. Frustrating for those that are under the "read only" choice. Is there a way to either globally change the date on all of the form files without causing the DDE link to drop with the database? It would be great if there were an auto date update that once the "new" document was created and saved would not auto update with each new opening of that "new" document that was saved. Can anyone point me in the direction to deal with this problem. We have hundreds of form files. I do not want to manually change the month on each file individually with each new month of the year. Thank you, -- John R. |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Document Date Change
Thank you. I will give it a try.
-- John R. "Graham Mayor" wrote: Try the following macro on *copies* of your documents in a dedicated folder for the purpose. It opens each document, changes the Date fields to Createdate fields and updates that revised field. If the field is indeed a Date field and not a linked field, this should do the job. Sub FixAllDates() Dim myFile As String Dim PathToUse As String Dim MyDoc As Document Dim iFld As Integer Dim i As Long With Dialogs(wdDialogCopyFile) If .Display 0 Then PathToUse = .Directory Else MsgBox "Cancelled by User" Exit Sub End If End With If Documents.Count 0 Then Documents.Close SaveChanges:=wdPromptToSaveChanges End If If Left(PathToUse, 1) = Chr(34) Then PathToUse = Mid(PathToUse, 2, Len(PathToUse) - 2) End If myFile = Dir$(PathToUse & "*.doc") While myFile "" Set MyDoc = Documents.Open(PathToUse & myFile) ActiveWindow.View.ShowFieldCodes = True For iFld = ActiveDocument.Fields.Count To 1 Step -1 With ActiveDocument.Fields(iFld) If .Type = wdFieldDate Then .Code.Text = replace(.Code.Text, "DATE", "CREATEDATE") .Update End If End With Next iFld ActiveWindow.View.ShowFieldCodes = False MyDoc.Close SaveChanges:=wdSaveChanges myFile = Dir$() Wend End Sub John wrote: I was just plucked and assigned with a very, very short time frame - tomorrow!. This is not my area of interest or expertise, just the busiest person in the office and expected to "add" to my responsibilities. Not complaining as I have managed to learn all sorts of new things. But, not having time to actually research, understand, play, and test things makes the job a bit more challenging! Thank you for your help. I will give your suggestion a try. John "Jezebel" wrote: Change the DATE fields to CREATEDATE fields. It's going to be a nuisance for the documents already created, but easy to fix for the future. How did you come to create "many, many" documents without testing that your system worked? "John" wrote in message ... My office is using Office 2000 (Word) on XP Pro. I have created many, many form files/documents that "merge" with Excel via DDE to a finished/new document that is saved to various other folders under a new file name. The form files and excel database are located on our server for every user to access. I originally inserted a date field (via the insert menu) into each new form file I created. However, that causes a problem at the saving end of the newly created document. We need the document to maintain its date at creation and not have the date updated automatically upon reopening the file a month later. I removed the inserted date field from each form file manually (one at a time) and now the process is that each user opening the form file has to type in the correct month, day, and periodically year. That would be reasonable except that the form files are "read only" for everyone but the administrator. So if you open the same file several times in the same day, you have to retype the correct date each time you open it. Frustrating for those that are under the "read only" choice. Is there a way to either globally change the date on all of the form files without causing the DDE link to drop with the database? It would be great if there were an auto date update that once the "new" document was created and saved would not auto update with each new opening of that "new" document that was saved. Can anyone point me in the direction to deal with this problem. We have hundreds of form files. I do not want to manually change the month on each file individually with each new month of the year. Thank you, -- John R. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do my document change date every time I open them | Microsoft Word Help | |||
can sending a word document as an attactment cause a date change | Microsoft Word Help | |||
How do I change the created date in a Word document? | Microsoft Word Help | |||
How do you change a repeated date on the same document without ch. | Microsoft Word Help | |||
Why does the original date change upon opening a document? | Microsoft Word Help |