Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
I'd like to convert 20K existing Works 7.0's "word processing" files to
Word 2007 simultaneously or at least automatically and consecutively. I've not been able to find any guidance about how to do this either in Word 2007's Web-based Help directory or by searching in Google Web. (The Word 2007 Help directory does offer a Web-based view of the "community" which seems to include all relevant news groups/forums.) Word 2007's Help texts provide excellent assistance but they only seem to discuss conversion of single files, "one at a time," or "one by one." The Help texts don't seem to discuss automatic conversion of *ALL* files of particular types. I suspect Word 2007 itself may not be able to make "mass conversions" of files from other applications. I suspect this may require an "add-in" or other types of separate software. I've seen some discussion of Aspose.Word, for example, but that seems to be a large-scale application which is intended for enterprise use. I'm surprised that I've not yet found any instructions about how to convert *ALL* files of particular types. I have seen some advice that Word 2007's built-in converters obviate actual conversions of files from other applications, but, as I explain in the optional text below my signature, I've "had it" with Works' "so-called" word processor, I've not been able to rely on it, and I don't want to use it any more, so I'd prefer to convert all of my files from that application to Word 2007. Thanks in advance for any assistance! Additional details are provided below my signature. Jeff Hook, NJ, USA I'm working at home on a non-networked system which is running the Home Edition of Windows XP. I made the mistake of relying on Works' "so-called word processor" when I wasn't able to operate Word years ago as a novice computer user and I compounded my error by continuing to use Works almost exclusively for ten years. I began with version 4.0 and I've used 7.0 since 2003 when I acquired it as an OEM installation. It was bundled with the Home Edition of Windows XP on a new Gateway system unit. Works 7.0 was an upgrade from Works 6.0 which I'd used with Windows 98se on a prior system unit. I'd been losing the contents of Works 6.0's Custom Dictionary regularly but 6.0 itself never crashed. (I was able to replace the dictionary's contents from a back-up TXT file.) Works 7.0 crashed when it was in its pristine state within an hour or two of my first using it on the new Gateway system unit. I may later have "tainted" Works 7.0 by using TweakUI incorrectly, in an attempt to bypass the Works "Task Launcher." (I installed my own standard-formatted "sample" Works "document" in the Windows Explorer File\New menu. This allowed me to create and to save new files at the ends of long file paths while I worked in the Windows Classic View in Windows Explorer. The Task Launcher saved all of its new files to the root of the My Documents folder, and it would have been necessary to "re-navigate" from there to the desired destination folder for each new file.) I abandoned the File\New menu when I created a large directory of differently-formatted "template" files. From that point forward I created each of my new Works 7.0 documents as a copy of one of my many templates and I gradually included entire small sub-directories of folders and files in my templates directory. I now often fill in new file paths by pasting copies of sub-directory templates to them. I subsequently reformatted my hard drive and I made no further use of TweakUI or of the File\New menu for the creation of new Works 7.0 documents, but the application continued to crash, although much less often. I've finally made the switch to a "real" word processor and, as a result of my bad experience with Works "word processor," I now want to convert *ALL* of the files which I've accumulated in that application to Word 2007. I don't work collaboratively with anyone else and, if I ever need to share a document with someone who's not running Word 2007, I can save a copy in RTF, so I'm hoping to be rid of Works' "word processor" once and for all. I've created a macro which automates the use of the Convert command in the Word 2007 Office menu. (Word 2007 Help doesn't even mention the "Office\Convert" option in its guidance about how to convert Works documents. It only discusses the "Office\Save As\Works Document" approach, which seems to be inferior. The "Convert" option seems to operate well and it also deletes the original Works file, which is a convenience because it eliminates confusion about whether files have been converted or not.) I'm using Steve Vest's FileLocator Pro for desktop searching. By running .\.wps as a "regular expression" in any folder of my data directory I can obtain a list of all of the Works "word processing" files in that path, and I can then work my way down the engine's list of files, opening each in Word 2007 by using its context menu in the search engine's GUI, and then hitting my macro on the Word 2007 Quick Access Toolbar when the Works file opens in Word 2007. The "Convert-Save-Close" macro seems to do all that I require, and each conversion only requires a few seconds but conversion of all files individually seems nuts when it must be possible to do this automatically, for all 20K+ files! JLH |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
I referred to "Steve Vest" in my previous message. The developer of the FileLocator Pro desktop search engine is *DAVE* Vest. (Sorry, Dave!) http://www.mythicsoft.com/Page.aspx?...rpro&page=home Jeff Hook ....I'm using Steve Vest's FileLocator Pro for desktop searching. By running .\.wps as a "regular expression" in any folder of my data directory I can obtain a list of all of the Works "word processing" files in that path, and I can then work my way down the engine's list of files, opening each in Word 2007 by using its context menu in the search engine's GUI, and then hitting my macro on the Word 2007 Quick Access Toolbar when the Works file opens in Word 2007. The "Convert-Save-Close" macro seems to do all that I require, and each conversion only requires a few seconds but conversion of all files individually seems nuts when it must be possible to do this automatically, for all 20K+ files! JLH |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
If you have the appropriate filter installed, Word will open Works documents
without problem. You can download the older Works filters from my web site. The latest filter is supplied with Office 2007. A sensible option would be open the Works files as you require them and save them as Word 2007 documents, but it would be possible to convert them as a batch process. The following macro will save all Works documents as Word docx format from a given folder. The original Works documents are unaffected, so you can return to the original if necessary. Sub SaveWorksWPSAsDOCX() Dim strFileName As String Dim strDocName As String Dim strPath As String Dim sPrompt As Boolean Dim oDoc As Document Dim fDialog As FileDialog Set fDialog = Application.FileDialog(msoFileDialogFolderPicker) With fDialog .Title = "Select folder and click OK" .AllowMultiSelect = False .InitialView = msoFileDialogViewList If .Show -1 Then MsgBox "Cancelled By User", , "List Folder Contents" Exit Sub End If strPath = fDialog.SelectedItems.Item(1) If Right(strPath, 1) "\" Then strPath = strPath + "\" End With If Documents.Count 0 Then Documents.Close SaveChanges:=wdPromptToSaveChanges End If sPrompt = Options.ConfirmConversions Options.ConfirmConversions = False If Left(strPath, 1) = Chr(34) Then strPath = Mid(strPath, 2, Len(strPath) - 2) End If strFileName = Dir$(strPath & "*.wps") While Len(strFileName) 0 Set oDoc = Documents.Open(strPath & strFileName) strDocName = ActiveDocument.FullName intPos = InStrRev(strDocName, ".") strDocName = Left(strDocName, intPos - 1) strDocName = strDocName & ".docx" oDoc.SaveAs FileName:=strDocName, _ FileFormat:=wdFormatDocumentDefault oDoc.Close SaveChanges:=wdDoNotSaveChanges strFileName = Dir$() Wend Options.ConfirmConversions = sPrompt End Sub http://www.gmayor.com/installing_macro.htm Jeffrey L. Hook wrote: I'd like to convert 20K existing Works 7.0's "word processing" files to Word 2007 simultaneously or at least automatically and consecutively. I've not been able to find any guidance about how to do this either in Word 2007's Web-based Help directory or by searching in Google Web. (The Word 2007 Help directory does offer a Web-based view of the "community" which seems to include all relevant news groups/forums.) Word 2007's Help texts provide excellent assistance but they only seem to discuss conversion of single files, "one at a time," or "one by one." The Help texts don't seem to discuss automatic conversion of *ALL* files of particular types. I suspect Word 2007 itself may not be able to make "mass conversions" of files from other applications. I suspect this may require an "add-in" or other types of separate software. I've seen some discussion of Aspose.Word, for example, but that seems to be a large-scale application which is intended for enterprise use. I'm surprised that I've not yet found any instructions about how to convert *ALL* files of particular types. I have seen some advice that Word 2007's built-in converters obviate actual conversions of files from other applications, but, as I explain in the optional text below my signature, I've "had it" with Works' "so-called" word processor, I've not been able to rely on it, and I don't want to use it any more, so I'd prefer to convert all of my files from that application to Word 2007. Thanks in advance for any assistance! Additional details are provided below my signature. Jeff Hook, NJ, USA I'm working at home on a non-networked system which is running the Home Edition of Windows XP. I made the mistake of relying on Works' "so-called word processor" when I wasn't able to operate Word years ago as a novice computer user and I compounded my error by continuing to use Works almost exclusively for ten years. I began with version 4.0 and I've used 7.0 since 2003 when I acquired it as an OEM installation. It was bundled with the Home Edition of Windows XP on a new Gateway system unit. Works 7.0 was an upgrade from Works 6.0 which I'd used with Windows 98se on a prior system unit. I'd been losing the contents of Works 6.0's Custom Dictionary regularly but 6.0 itself never crashed. (I was able to replace the dictionary's contents from a back-up TXT file.) Works 7.0 crashed when it was in its pristine state within an hour or two of my first using it on the new Gateway system unit. I may later have "tainted" Works 7.0 by using TweakUI incorrectly, in an attempt to bypass the Works "Task Launcher." (I installed my own standard-formatted "sample" Works "document" in the Windows Explorer File\New menu. This allowed me to create and to save new files at the ends of long file paths while I worked in the Windows Classic View in Windows Explorer. The Task Launcher saved all of its new files to the root of the My Documents folder, and it would have been necessary to "re-navigate" from there to the desired destination folder for each new file.) I abandoned the File\New menu when I created a large directory of differently-formatted "template" files. From that point forward I created each of my new Works 7.0 documents as a copy of one of my many templates and I gradually included entire small sub-directories of folders and files in my templates directory. I now often fill in new file paths by pasting copies of sub-directory templates to them. I subsequently reformatted my hard drive and I made no further use of TweakUI or of the File\New menu for the creation of new Works 7.0 documents, but the application continued to crash, although much less often. I've finally made the switch to a "real" word processor and, as a result of my bad experience with Works "word processor," I now want to convert *ALL* of the files which I've accumulated in that application to Word 2007. I don't work collaboratively with anyone else and, if I ever need to share a document with someone who's not running Word 2007, I can save a copy in RTF, so I'm hoping to be rid of Works' "word processor" once and for all. I've created a macro which automates the use of the Convert command in the Word 2007 Office menu. (Word 2007 Help doesn't even mention the "Office\Convert" option in its guidance about how to convert Works documents. It only discusses the "Office\Save As\Works Document" approach, which seems to be inferior. The "Convert" option seems to operate well and it also deletes the original Works file, which is a convenience because it eliminates confusion about whether files have been converted or not.) I'm using Steve Vest's FileLocator Pro for desktop searching. By running .\.wps as a "regular expression" in any folder of my data directory I can obtain a list of all of the Works "word processing" files in that path, and I can then work my way down the engine's list of files, opening each in Word 2007 by using its context menu in the search engine's GUI, and then hitting my macro on the Word 2007 Quick Access Toolbar when the Works file opens in Word 2007. The "Convert-Save-Close" macro seems to do all that I require, and each conversion only requires a few seconds but conversion of all files individually seems nuts when it must be possible to do this automatically, for all 20K+ files! JLH |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
**EXCELLENT**, Graham! THANKS!
1. If you have the appropriate filter installed, Word will open Works documents without problem. Yes, I can do that easily. I can open every one of the 20K Works 7.0 documents in Word 2007 instantly. That's never been a problem. 2. A sensible option would be open the Works files as you require them and save them as Word 2007 documents... I can also do that, but, as I explained, I've had such difficulty with Works 7.0's "word processor" that I want to be rid of the application and I'd rather convert all of its existing files to Word 2007 now, so I can avoid future use of the Works application. (I do appreciate Works' flat-file database.) Some users who find this thread in the future may wish to know how they can find and then convert all files of a type. I'll explain several methods below my signature. 3. The following macro will save all Works documents as Word docx format from a given folder. The original Works documents are unaffected, so you can return to the original if necessary... Thanks very much for the code. Please understand that my knowledge of macros in Word 2007 and of Visual Basic is just about nil. The simple "Convert-Save-Close" macro which I mentioned in my first message was my first macro. (This functionality isn't "supported" by Works' "word processor" so I had no prior experience of macros.) Here's the entirety of my first macro, from the Visual Basic GUI: *** Sub Macro3() ' ' Macro3 ' Automates the steps of the Conversion process within a Works 7.0 "word processing" file which has already been opened in Word 2007. ' ActiveDocument.Convert ActiveDocument.Save ActiveWindow.Close End Sub *** That's all there is, but it seems to work. I was able to install your macro. I could see from the code that the macro seemed to be focused on folders, and that seemed appropriate, because I hoped it would start at the "highest" folder in a given file path (closest to the root) and would "work its way to the end of the path." I assigned a Quick Access Toolbar button to the macro and I then ran it, on a "low-stakes" folder of content which I rarely use. (I should have copied a folder and run the macro on the copy, in case I bungled the installation and problems resulted, but I guess I could restore content from a back-up of my data directory if that were necessary.) I see that your macro displays a typical Windows browse-type dialog which is titled "Select folder and click OK." I assumed I should use the dialog's browse capability to navigate to a folder in which I wish to convert Works documents and I assumed I should then left-click the dialog's "OK" button. The dialog doesn't offer any display of content (i.e. of files in folders) unlike the Word 2007 "Open" dialog, which can be set to show "All Files (*.*)" in its "Files of type" field. Also, if I select a folder and then click "OK" the folder name doesn't appear in the macro's "Folder name" field, which remains empty, although I see that the field's drop-down list shows all folders in which I've used this macro, in reverse chronological order. These folders are only shown *after* the macro's been run in them. I'm "operating blind" with this macro because I can't see if any folder contains any files which I wish to convert. I could navigate simultaneously in Windows Explorer in order to locate Works 7.0 documents which I wish to convert while I also perform the same navigation in your macro, but I don't want to *double* my navigation! It's easier simply to open any Word 2007 file and then to navigate in that file's Open dialog via the file's Office menu, with the Open dialogue set to Files of all types, so I can see the contents of all folders but it's even easier than *that* for me to use my desktop search engine (Dave Vest's FileLocator Pro) in order to obtain a list of *ALL* Works 7.0 documents in any directory. That completely eliminates all navigation! As I explained in my first message I can reduce the amount of time which is required for each conversion to a few seconds by combining my desktop search engine with my own "quick and dirty" macro, but I still feel like it's a waste of time to convert files "one at a time" like this, even if each conversion only requires seconds. I'm looking for a way to automate the conversion of more than 20,000 files and to perform those conversions in as little time as possible. Your macro seems to operate only in one folder (at one "level" of a hierarchy) at a time. It doesn't seem to "drill down" along file paths and to work in all sub-folders. When I could see in its code that it was focused on folders I decided to operate it close to the end of a rarely-used file path in order to reduce the chance that it might do damage if I'd installed it incorrectly and if I'd "corrupted" it. I operated it a few levels above the end of the test path in the hope that it would convert all files in all sub-folders, but it never left the folder in which it was first operated. It therefore doesn't operate in the way which I desired. It also retains the original Works 7.0 files although I'd prefer to use Word 2007's "Convert" option, which deletes the original files, and which leaves only the newly-converted Word 2007 files. Are you at all inclined to modifiy the code in order to assure that the macro will: 1. move along complete file paths, working in all sub-folders and will 2. convert all Works documents in all folders, deleting the original files, and leaving only the newly-converted Word 2007 files, as results from the use of Word 2007's "Office\Convert" menu? Would you be willing to explain how your code limits this macro's function in these respects, so I could try to modify the code myself? I tried to change "False" to "True" in this context: ....With fDialog .Title = "Select folder and click OK" .AllowMultiSelect = True... but that didn't produce the sub-folder effect which I'd hoped to produce. Jeff Hook, NJ, USA (Additional comments below may be of interest to users who wonder how to locate and convert files of any type.) I've used these different methods to locate Works 7.0 files and to convert them to Word 2007. I've written an extremely simple macro in Word 2007 which merely automates the four-click process of opening each file's Office menu when the Works file is opened in Word 2007, left-clicking the "Convert" command in the Office menu, left-clicking the "Save" button on the Quick Access Toolbar, and then left-clicking the Windows "Close" button at the upper-right corner of each file's GUI. I installed my macro as a button on the Quick Access Toolbar so it appears in each file when each file is opened in Word 2007. Conversion is therefore a simple matter of opening each file in Word 2007 and then making a single left-click on the macro's button. The macro does the rest: A. I can open each Works 7.0 file individually in Word 2007 by right-clicking the file in the Contents Pane of Windows Explorer in the Windows Classic View in Windows XP, then left-clicking "Open With\Microsoft Office Word" in the context/"pop-up" menu. B. From within any Word 2007 file, I can use the Word 2007 Open command in the Office menu. This produces the Open dialog, in which I can navigate to the desired Works 7.0 files, which I'll be able to see in the dialog's Browse display if I've set the dialog's "Files of type" field to "All Files (*.*)" in the field's drop-down list. If I leave any Word 2007 file open after I've navigated to my first Works 7.0 file and have converted that file to Word 2007 the Open dialog will remain "set" to the last folder in which I worked. This helps me to navigate through directories in order to convert multiple files one-by-one. If I close all Word 2007 files, it'll be necessary to "re-set" the "Open" dialog from the system root, by navigating once again to the desired folders. C. A convenient way of converting all files systematically (but still only one-by-one) is to use a desktop search engine to obtain a list of all files of a given type in a given directory, as I explained in my first message. I can then convert each file in the search engine's "search results" list, by using each file's context menu, as I explained here in method "A" above. This method's helpful because it obviates navigating through the directory in search of the files which are to be converted; the engine lists them all and it's not necessary to look for them. JLH "Graham Mayor" wrote in message ... If you have the appropriate filter installed, Word will open Works documents without problem. You can download the older Works filters from my web site. The latest filter is supplied with Office 2007. (snipped) |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
The macro is simply a generic batch processing function that works at an
individual folder level, using built-in dialogs to enable the user to select the folder. It opens each file in the folder that matches the search string (here *.wps) and saves those documents as Word docx format. It has no ability to search across a range of folders. Because only you know what files you have on your hard drive and the lack of error trapping in the macro, it is not a good idea to include code to delete the wps files. It would be a simple job to search for them later with Windows Explorer and delete them, when you are sure that they have all been converted. However if you really want to take that approach change the section from While ... to ... Wend with While Len(strFileName) 0 Set oDoc = Documents.Open(strPath & strFileName) oDoc.Convert oDoc.Close SaveChanges:=wdSaveChanges strFileName = Dir$() Wend This will convert the documents and delete the originals in the process. I don't have the code to hand to iterate through all the possible sub folders, but if you wish to pursue this, then ask in the Word vba programming forum. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jeffrey L. Hook wrote: **EXCELLENT**, Graham! THANKS! 1. If you have the appropriate filter installed, Word will open Works documents without problem. Yes, I can do that easily. I can open every one of the 20K Works 7.0 documents in Word 2007 instantly. That's never been a problem. 2. A sensible option would be open the Works files as you require them and save them as Word 2007 documents... I can also do that, but, as I explained, I've had such difficulty with Works 7.0's "word processor" that I want to be rid of the application and I'd rather convert all of its existing files to Word 2007 now, so I can avoid future use of the Works application. (I do appreciate Works' flat-file database.) Some users who find this thread in the future may wish to know how they can find and then convert all files of a type. I'll explain several methods below my signature. 3. The following macro will save all Works documents as Word docx format from a given folder. The original Works documents are unaffected, so you can return to the original if necessary... Thanks very much for the code. Please understand that my knowledge of macros in Word 2007 and of Visual Basic is just about nil. The simple "Convert-Save-Close" macro which I mentioned in my first message was my first macro. (This functionality isn't "supported" by Works' "word processor" so I had no prior experience of macros.) Here's the entirety of my first macro, from the Visual Basic GUI: *** Sub Macro3() ' ' Macro3 ' Automates the steps of the Conversion process within a Works 7.0 "word processing" file which has already been opened in Word 2007. ' ActiveDocument.Convert ActiveDocument.Save ActiveWindow.Close End Sub *** That's all there is, but it seems to work. I was able to install your macro. I could see from the code that the macro seemed to be focused on folders, and that seemed appropriate, because I hoped it would start at the "highest" folder in a given file path (closest to the root) and would "work its way to the end of the path." I assigned a Quick Access Toolbar button to the macro and I then ran it, on a "low-stakes" folder of content which I rarely use. (I should have copied a folder and run the macro on the copy, in case I bungled the installation and problems resulted, but I guess I could restore content from a back-up of my data directory if that were necessary.) I see that your macro displays a typical Windows browse-type dialog which is titled "Select folder and click OK." I assumed I should use the dialog's browse capability to navigate to a folder in which I wish to convert Works documents and I assumed I should then left-click the dialog's "OK" button. The dialog doesn't offer any display of content (i.e. of files in folders) unlike the Word 2007 "Open" dialog, which can be set to show "All Files (*.*)" in its "Files of type" field. Also, if I select a folder and then click "OK" the folder name doesn't appear in the macro's "Folder name" field, which remains empty, although I see that the field's drop-down list shows all folders in which I've used this macro, in reverse chronological order. These folders are only shown *after* the macro's been run in them. I'm "operating blind" with this macro because I can't see if any folder contains any files which I wish to convert. I could navigate simultaneously in Windows Explorer in order to locate Works 7.0 documents which I wish to convert while I also perform the same navigation in your macro, but I don't want to *double* my navigation! It's easier simply to open any Word 2007 file and then to navigate in that file's Open dialog via the file's Office menu, with the Open dialogue set to Files of all types, so I can see the contents of all folders but it's even easier than *that* for me to use my desktop search engine (Dave Vest's FileLocator Pro) in order to obtain a list of *ALL* Works 7.0 documents in any directory. That completely eliminates all navigation! As I explained in my first message I can reduce the amount of time which is required for each conversion to a few seconds by combining my desktop search engine with my own "quick and dirty" macro, but I still feel like it's a waste of time to convert files "one at a time" like this, even if each conversion only requires seconds. I'm looking for a way to automate the conversion of more than 20,000 files and to perform those conversions in as little time as possible. Your macro seems to operate only in one folder (at one "level" of a hierarchy) at a time. It doesn't seem to "drill down" along file paths and to work in all sub-folders. When I could see in its code that it was focused on folders I decided to operate it close to the end of a rarely-used file path in order to reduce the chance that it might do damage if I'd installed it incorrectly and if I'd "corrupted" it. I operated it a few levels above the end of the test path in the hope that it would convert all files in all sub-folders, but it never left the folder in which it was first operated. It therefore doesn't operate in the way which I desired. It also retains the original Works 7.0 files although I'd prefer to use Word 2007's "Convert" option, which deletes the original files, and which leaves only the newly-converted Word 2007 files. Are you at all inclined to modifiy the code in order to assure that the macro will: 1. move along complete file paths, working in all sub-folders and will 2. convert all Works documents in all folders, deleting the original files, and leaving only the newly-converted Word 2007 files, as results from the use of Word 2007's "Office\Convert" menu? Would you be willing to explain how your code limits this macro's function in these respects, so I could try to modify the code myself? I tried to change "False" to "True" in this context: ...With fDialog .Title = "Select folder and click OK" .AllowMultiSelect = True... but that didn't produce the sub-folder effect which I'd hoped to produce. Jeff Hook, NJ, USA (Additional comments below may be of interest to users who wonder how to locate and convert files of any type.) I've used these different methods to locate Works 7.0 files and to convert them to Word 2007. I've written an extremely simple macro in Word 2007 which merely automates the four-click process of opening each file's Office menu when the Works file is opened in Word 2007, left-clicking the "Convert" command in the Office menu, left-clicking the "Save" button on the Quick Access Toolbar, and then left-clicking the Windows "Close" button at the upper-right corner of each file's GUI. I installed my macro as a button on the Quick Access Toolbar so it appears in each file when each file is opened in Word 2007. Conversion is therefore a simple matter of opening each file in Word 2007 and then making a single left-click on the macro's button. The macro does the rest: A. I can open each Works 7.0 file individually in Word 2007 by right-clicking the file in the Contents Pane of Windows Explorer in the Windows Classic View in Windows XP, then left-clicking "Open With\Microsoft Office Word" in the context/"pop-up" menu. B. From within any Word 2007 file, I can use the Word 2007 Open command in the Office menu. This produces the Open dialog, in which I can navigate to the desired Works 7.0 files, which I'll be able to see in the dialog's Browse display if I've set the dialog's "Files of type" field to "All Files (*.*)" in the field's drop-down list. If I leave any Word 2007 file open after I've navigated to my first Works 7.0 file and have converted that file to Word 2007 the Open dialog will remain "set" to the last folder in which I worked. This helps me to navigate through directories in order to convert multiple files one-by-one. If I close all Word 2007 files, it'll be necessary to "re-set" the "Open" dialog from the system root, by navigating once again to the desired folders. C. A convenient way of converting all files systematically (but still only one-by-one) is to use a desktop search engine to obtain a list of all files of a given type in a given directory, as I explained in my first message. I can then convert each file in the search engine's "search results" list, by using each file's context menu, as I explained here in method "A" above. This method's helpful because it obviates navigating through the directory in search of the files which are to be converted; the engine lists them all and it's not necessary to look for them. JLH "Graham Mayor" wrote in message ... If you have the appropriate filter installed, Word will open Works documents without problem. You can download the older Works filters from my web site. The latest filter is supplied with Office 2007. (snipped) |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Thanks for your reply, Graham. I was never a fan of Kurt Vonnegut. His writing seemed to me to be a type of literary slapstick which was too clownish for my taste. I read his novel "Cat's Cradle" many years ago and I remembered the concept of "Ice Nine." This was a modified form of water which melted at 114 degrees Fahrenheit. "Ice Nine" had a "contagious" effect so that the exposure of any amount of it to any water in the natural environment anywhere would begin an irreversible "chain reaction" which would quickly freeze all water around the entire world. The idea was ridiculous but it did impress itself on me as an example of an automatic process which produced undesirable results: http://www.google.com/search?hl=en&n...22&btnG=Search I was looking for an automatic conversion process which could have been started at the root of my data directory and which would have then worked down, or out, or up, or whatever the direction would be. I wondered if I'd "trip" a type of "Ice Nine" "chain reaction" if I began to run such a process. You also seem to be leery of unintended results but I'm only talking about conversion of data files from one application to another. I don't think an automatic conversion process could create a disaster. I routinely back up all of my files and I could create a back up immediately before I began an automated conversion of all Works documents in my data directory. If the process went awry I could replace the data directory with the back up copy. So far, my best method seems to be to use my desktop search engine (Dave Vest's "FileLocator Pro") to obtain a list of all Works 7.0 documents in my entire data directory or in any sub-directory. FileLocator Pro will list all such files from any folder in which I run it along all paths, in all sub-folders. I'll then be able to open each file in each of the the search engine's "search results list," one-by-one, by using each file's own context menu. I can then use my own simple macro in each file to convert, save, and close each file with a single mouse click. My macro uses the "Office\Convert" method, rather than the "Office\Save As\Word Document" method. The "Convert" method deletes the original Works file and only leaves the converted Word 2007 file. I can chip away at my backlog of Works 7.0 documents by using my method but I continue to think that, "Ice Nine" scenarios notwithstanding, the automatic conversion of many files of the same type from one application to another must be routine at the enterprise level. I assume this is done in large international organizations, for example, with hundreds of thousands or even millions of files. I'm a single home user who doesn't even have a home network. I'm only using a single system unit with two internal hard drives and four partitions, one of which is my "boot" partition and another of which is my "active data" partition but Word 2007 does seem to be designed for enterprise use, and I remain surprised that I haven't yet been able to find instructions about how to convert all of my Works 7.0 documents to Word 2007 "at the flip of a switch." Maybe Microsoft was also worried about unintended consequences of powerful automatic processes. I assume that "batch conversion" may be the jargon which IT professionals use to refer to the type of process which I'm seeking. Thanks again, Graham. Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... The macro is simply a generic batch processing function that works at an individual folder level, using built-in dialogs to enable the user to select the folder. It opens each file in the folder that matches the search string (here *.wps) and saves those documents as Word docx format. It has no ability to search across a range of folders. (snipped) |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
If you use the search function to find all the wps files Explorer will
display the foldernames that contain them. The revised version of the macro can then be used to process each named folder in turn and will indeed *convert* all the files in that folder. What it won't do is iterate through all the folders on your hard drive. A batch process is a process that runs on a group or batch of files. The macros I posted will run on a batch comprising all the files in a single folder. I regret I do not have a function to hand that works on the complete folder structure (though I will look into it). -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jeffrey L. Hook wrote: Thanks for your reply, Graham. I was never a fan of Kurt Vonnegut. His writing seemed to me to be a type of literary slapstick which was too clownish for my taste. I read his novel "Cat's Cradle" many years ago and I remembered the concept of "Ice Nine." This was a modified form of water which melted at 114 degrees Fahrenheit. "Ice Nine" had a "contagious" effect so that the exposure of any amount of it to any water in the natural environment anywhere would begin an irreversible "chain reaction" which would quickly freeze all water around the entire world. The idea was ridiculous but it did impress itself on me as an example of an automatic process which produced undesirable results: http://www.google.com/search?hl=en&n...22&btnG=Search I was looking for an automatic conversion process which could have been started at the root of my data directory and which would have then worked down, or out, or up, or whatever the direction would be. I wondered if I'd "trip" a type of "Ice Nine" "chain reaction" if I began to run such a process. You also seem to be leery of unintended results but I'm only talking about conversion of data files from one application to another. I don't think an automatic conversion process could create a disaster. I routinely back up all of my files and I could create a back up immediately before I began an automated conversion of all Works documents in my data directory. If the process went awry I could replace the data directory with the back up copy. So far, my best method seems to be to use my desktop search engine (Dave Vest's "FileLocator Pro") to obtain a list of all Works 7.0 documents in my entire data directory or in any sub-directory. FileLocator Pro will list all such files from any folder in which I run it along all paths, in all sub-folders. I'll then be able to open each file in each of the the search engine's "search results list," one-by-one, by using each file's own context menu. I can then use my own simple macro in each file to convert, save, and close each file with a single mouse click. My macro uses the "Office\Convert" method, rather than the "Office\Save As\Word Document" method. The "Convert" method deletes the original Works file and only leaves the converted Word 2007 file. I can chip away at my backlog of Works 7.0 documents by using my method but I continue to think that, "Ice Nine" scenarios notwithstanding, the automatic conversion of many files of the same type from one application to another must be routine at the enterprise level. I assume this is done in large international organizations, for example, with hundreds of thousands or even millions of files. I'm a single home user who doesn't even have a home network. I'm only using a single system unit with two internal hard drives and four partitions, one of which is my "boot" partition and another of which is my "active data" partition but Word 2007 does seem to be designed for enterprise use, and I remain surprised that I haven't yet been able to find instructions about how to convert all of my Works 7.0 documents to Word 2007 "at the flip of a switch." Maybe Microsoft was also worried about unintended consequences of powerful automatic processes. I assume that "batch conversion" may be the jargon which IT professionals use to refer to the type of process which I'm seeking. Thanks again, Graham. Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... The macro is simply a generic batch processing function that works at an individual folder level, using built-in dialogs to enable the user to select the folder. It opens each file in the folder that matches the search string (here *.wps) and saves those documents as Word docx format. It has no ability to search across a range of folders. (snipped) |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Graham: Thanks for your continued interest and for your contribution of code. I admit my near-complete ignorance of these topics. I also acknowledge that you seem to know far more about all of this than I do. You're an MVP and I'm a "noodnick"! I'm grateful for your participation in this discussion. I don't want to give any offense but I want to be sure that we keep these details in mind: I wanted an automatic method by which I could convert 20K WPS files to DOCX "in one fell swoop" or at least in one continuous unattended process, which might need to run for hours, etc. I explained that I'd already reduced the time which is required for the conversion of each file to *a few seconds* by using a desktop search engine (Dave Vest's FileLocator Pro) in combination with my own crude "Convert-Save-Close" macro. My method completely eliminates any manual searching for WPS files; that's all done quickly and automatically by the search engine, which then gives me a helpful list of all 20K + WPS files, one after the other, all together in one place. I'm not required to look for the files; they're all lined up neatly in one long list. I can open each of them from that list by using its context menu, and, once each file opens in Word 2007, I can convert, save, and close the file with one mouse click, by using my own crude macro. The original WPS files are deleted because I'm using Word 2007's Office\Convert command. My method seems to be quick, but it's not nearly quick enough. Each file must be opened manually, "one at a time" in the search engine's list, and I must run my macro in each file by manually clicking the macro's control button on each file's Quick Access Toolbar. This requires far too much time for the conversion of so many files. Your method also automates the conversion, saving, and closing of each file, but it operates manually in all other respects. Your macro doesn't automatically "aggregate" all WPS files, as the FileLocator Pro search engine does. Your macro requires me either to locate all WPS files myself ("manually" or "visually" in Windows Explorer, which is both time-consuming and inaccurate because it's so disorienting to try to coordinate Windows Explorer with your macro's navigational display) or else your macro must be run in every one of the 52K folders of my data directory, "as a precaution," in *case* each folder contains one or more WPS files, because your macro's display interface only displays folders; it doesn't show any files of any types! I've explained that I'm using a method which gives me a convenient list of WPS files. The search engine's list completely obviates all searching for the files (that's done automatically by the engine) and it gives me direct access to the files, but, in response to my inquiry about a better, fully automatic method, you've suggested a method which doesn't display any files of any type and which might require me to "rummage around blindly" from folder to folder, navigating my system manually without being able to see any contents of any folders. How does this help, and how is this superior to my own method? You've now suggested that I could navigate in Windows Explorer to the folders which had been identified in the search engine's list as containing WPS files, so I could run your macro in those folders! Why would I want to do that when the very files are already directly in front of me in the search engine's list?! Yes, it's possible that some folders might contain large enough numbers of WPS files so that the substantial additional amount of time which would be necessary to leave the files behind in the list, to navigate to the relevant folders wherever they might be in my far-flung, sprawling data directory, to run your macro there, and then to return to the search engine's list *might* be less than the total time which would be necessary to "bang away" in the list itself, spending a couple seconds converting each file in succession, individually, but that's extremely unlikely. My file paths are long, my data directory is complex, and few of my folders contain large enough numbers of WPS files to make this "detour" worthwhile. Your suggestion seems likely to take far more time than would be necessary simply to keep moving through the search engine's list, one file at a time. It's worth stressing that I'm NOT using Windows XP Home's own awful "Search Companion." I'm using a shareware desktop search engine, which I obtained from an independent developer. It's also relevant that this engine, FileLocator Pro, effectively "extracts" all WPS files from wherever they may be, it displays them in a convenient list, and allows me to open each file from its own context menu in the list. The last file which I opened in that list remains selected when I return to the list in order to open and to convert the next file, so I don't "lose my place" in the list. This helps me to move along as quickly as possible even though a fully-automatic method would clearly be far superior. I'm glad that you're investigating how to enable your conversion macro to move through all folders in a directory. Please notice that FileLocator Pro seems to do this when it finds all of the WPS files in any directory. You previously suggested I might consider converting WPS files on an "as needed" basis or whenever I encounter them in Windows Explorer during my normal navigation of my data directory. That may be the the most practical idea, although I'd prefer to complete the conversion of all of the files at the same time. I can open individual WPS files in Word 2007 easily by using their own context menus in Windows Explorer's Contents Pane, and I can then complete the conversions of those files with one mouse click on their Quick Access Toolbars when the files open in Word 2007. I can't say this with any "pride of authorship" because I'm only bumbling along in all of this, but my own half-baked method seems to be best until I can find a true "turn-key," fully-automatic alternative. I remain confident that such methods are used constantly at the enterprise level. Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... If you use the search function to find all the wps files Explorer will display the foldernames that contain them. The revised version of the macro can then be used to process each named folder in turn and will indeed *convert* all the files in that folder. What it won't do is iterate through all the folders on your hard drive. A batch process is a process that runs on a group or batch of files. The macros I posted will run on a batch comprising all the files in a single folder. I regret I do not have a function to hand that works on the complete folder structure (though I will look into it). (snipped) |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
The advantage of the macro I posted, over yours, was that mine runs on a
complete folder, whereas yours runs on a single file. If your files are not scattered haphazardly over the hard drive, then the documents will be in a limited number of places which should be easy to identify. Unfortunately what you propose is not quite as simple to execute as you imagine. However true to my word, I have investigated further and I have located a procedure which I believe will do what you propose. As it is somewhat complex, I have decided not to post the code here, but have incorporated it as an add-in for Word 2007. You can download it from my web site via the following link. http://www.gmayor.com/Extras/WorksConverter.dotm Save to the Word startup folder as defined at Word Options Advanced File locations Startup (by default - C:\Documents and Settings\%username%\Application Data\Microsoft\Word\STARTUP) and it will load with Word When loaded it puts a button on the Developer Tab of the ribbon (Convert Works WPS format). If the developer tab is not displayed add it from Word Options Popular. I have tested it with a limited number of wps files and it will convert them to docx in the manner already discussed. It will also access the sub folders under the folder you select from the initial dialog when the macro is run. However, searching for 20k files across a complete hard drive is uncharted waters and not something I have been able to test. However you may set the folder to search from as the root of the drive and it will search the whole drive. While running, it may blank the Word screen, and when run on a large drive it will take some time to find the files in question, let alone process them. When finished it will return to the Word screen, with no document open, at the Home tab. I offer the add-in 'as seen' and accept no responsibility for any problems that you may encounter when running it. Fellow MVP Greg Maxey has a different function available on his web site - http://gregmaxey.mvps.org/Process_Batch_Folder.htm which has a 'User Defined' process option that could be modified to convert the files, should you wish to investigate another approach. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jeffrey L. Hook wrote: Graham: Thanks for your continued interest and for your contribution of code. I admit my near-complete ignorance of these topics. I also acknowledge that you seem to know far more about all of this than I do. You're an MVP and I'm a "noodnick"! I'm grateful for your participation in this discussion. I don't want to give any offense but I want to be sure that we keep these details in mind: I wanted an automatic method by which I could convert 20K WPS files to DOCX "in one fell swoop" or at least in one continuous unattended process, which might need to run for hours, etc. I explained that I'd already reduced the time which is required for the conversion of each file to *a few seconds* by using a desktop search engine (Dave Vest's FileLocator Pro) in combination with my own crude "Convert-Save-Close" macro. My method completely eliminates any manual searching for WPS files; that's all done quickly and automatically by the search engine, which then gives me a helpful list of all 20K + WPS files, one after the other, all together in one place. I'm not required to look for the files; they're all lined up neatly in one long list. I can open each of them from that list by using its context menu, and, once each file opens in Word 2007, I can convert, save, and close the file with one mouse click, by using my own crude macro. The original WPS files are deleted because I'm using Word 2007's Office\Convert command. My method seems to be quick, but it's not nearly quick enough. Each file must be opened manually, "one at a time" in the search engine's list, and I must run my macro in each file by manually clicking the macro's control button on each file's Quick Access Toolbar. This requires far too much time for the conversion of so many files. Your method also automates the conversion, saving, and closing of each file, but it operates manually in all other respects. Your macro doesn't automatically "aggregate" all WPS files, as the FileLocator Pro search engine does. Your macro requires me either to locate all WPS files myself ("manually" or "visually" in Windows Explorer, which is both time-consuming and inaccurate because it's so disorienting to try to coordinate Windows Explorer with your macro's navigational display) or else your macro must be run in every one of the 52K folders of my data directory, "as a precaution," in *case* each folder contains one or more WPS files, because your macro's display interface only displays folders; it doesn't show any files of any types! I've explained that I'm using a method which gives me a convenient list of WPS files. The search engine's list completely obviates all searching for the files (that's done automatically by the engine) and it gives me direct access to the files, but, in response to my inquiry about a better, fully automatic method, you've suggested a method which doesn't display any files of any type and which might require me to "rummage around blindly" from folder to folder, navigating my system manually without being able to see any contents of any folders. How does this help, and how is this superior to my own method? You've now suggested that I could navigate in Windows Explorer to the folders which had been identified in the search engine's list as containing WPS files, so I could run your macro in those folders! Why would I want to do that when the very files are already directly in front of me in the search engine's list?! Yes, it's possible that some folders might contain large enough numbers of WPS files so that the substantial additional amount of time which would be necessary to leave the files behind in the list, to navigate to the relevant folders wherever they might be in my far-flung, sprawling data directory, to run your macro there, and then to return to the search engine's list *might* be less than the total time which would be necessary to "bang away" in the list itself, spending a couple seconds converting each file in succession, individually, but that's extremely unlikely. My file paths are long, my data directory is complex, and few of my folders contain large enough numbers of WPS files to make this "detour" worthwhile. Your suggestion seems likely to take far more time than would be necessary simply to keep moving through the search engine's list, one file at a time. It's worth stressing that I'm NOT using Windows XP Home's own awful "Search Companion." I'm using a shareware desktop search engine, which I obtained from an independent developer. It's also relevant that this engine, FileLocator Pro, effectively "extracts" all WPS files from wherever they may be, it displays them in a convenient list, and allows me to open each file from its own context menu in the list. The last file which I opened in that list remains selected when I return to the list in order to open and to convert the next file, so I don't "lose my place" in the list. This helps me to move along as quickly as possible even though a fully-automatic method would clearly be far superior. I'm glad that you're investigating how to enable your conversion macro to move through all folders in a directory. Please notice that FileLocator Pro seems to do this when it finds all of the WPS files in any directory. You previously suggested I might consider converting WPS files on an "as needed" basis or whenever I encounter them in Windows Explorer during my normal navigation of my data directory. That may be the the most practical idea, although I'd prefer to complete the conversion of all of the files at the same time. I can open individual WPS files in Word 2007 easily by using their own context menus in Windows Explorer's Contents Pane, and I can then complete the conversions of those files with one mouse click on their Quick Access Toolbars when the files open in Word 2007. I can't say this with any "pride of authorship" because I'm only bumbling along in all of this, but my own half-baked method seems to be best until I can find a true "turn-key," fully-automatic alternative. I remain confident that such methods are used constantly at the enterprise level. Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... If you use the search function to find all the wps files Explorer will display the foldernames that contain them. The revised version of the macro can then be used to process each named folder in turn and will indeed *convert* all the files in that folder. What it won't do is iterate through all the folders on your hard drive. A batch process is a process that runs on a group or batch of files. The macros I posted will run on a batch comprising all the files in a single folder. I regret I do not have a function to hand that works on the complete folder structure (though I will look into it). (snipped) |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Once again, Graham, thank you very much for your attention to this topic! (I'm sure many other users will appreciate this also because, as I reported at the start of this thread, I looked around extensively and I couldn't find any instructions about how to achieve this result but I'm sure many users wish to make such mass or batch conversions.) I should clarify that I didn't think would be "simple to execute"! With *NO* abilities of my own in this area at all, I don't regard *any* of this as simple! I'll download the code from your site and I'll also check Greg Maxey's user-defined batch code. This will help me learn about batch programs. My data directory occupies its own partition of c. 32.25 GB on one of my two internal hard drives but, as I explained, it's extensively branched, with more than 52K folders and 94K files. I'll want to back up my entire data directory first and I'll then try your code on a few sub-directories before I "let it rip" from the root. Yes, I fully understand that I'll use this code at my own risk and without any recourse to you. I'll let you know how this works out. Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... The advantage of the macro I posted, over yours, was that mine runs on a complete folder, whereas yours runs on a single file. If your files are not scattered haphazardly over the hard drive, then the documents will be in a limited number of places which should be easy to identify. Unfortunately what you propose is not quite as simple to execute as you imagine. However true to my word, I have investigated further and I have located a procedure which I believe will do what you propose. As it is somewhat complex, I have decided not to post the code here, but have incorporated it as an add-in for Word 2007. You can download it from my web site via the following link. http://www.gmayor.com/Extras/WorksConverter.dotm Save to the Word startup folder as defined at Word Options Advanced File locations Startup (by default - C:\Documents and Settings\%username%\Application Data\Microsoft\Word\STARTUP) and it will load with Word When loaded it puts a button on the Developer Tab of the ribbon (Convert Works WPS format). If the developer tab is not displayed add it from Word Options Popular. I have tested it with a limited number of wps files and it will convert them to docx in the manner already discussed. It will also access the sub folders under the folder you select from the initial dialog when the macro is run. However, searching for 20k files across a complete hard drive is uncharted waters and not something I have been able to test. However you may set the folder to search from as the root of the drive and it will search the whole drive. While running, it may blank the Word screen, and when run on a large drive it will take some time to find the files in question, let alone process them. When finished it will return to the Word screen, with no document open, at the Home tab. I offer the add-in 'as seen' and accept no responsibility for any problems that you may encounter when running it. Fellow MVP Greg Maxey has a different function available on his web site - http://gregmaxey.mvps.org/Process_Batch_Folder.htm which has a 'User Defined' process option that could be modified to convert the files, should you wish to investigate another approach. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
I have found a minor bug in the add-in whilst testing, now fixed and updated
on the web site. It shouldn't affect the process, but I took the opportunity to remove some superfluous code. It seems reliable even running it on my full C drive of 200 gb without drama! If it works for you, let me know and I'll post a permanent link on my web site. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jeffrey L. Hook wrote: Once again, Graham, thank you very much for your attention to this topic! (I'm sure many other users will appreciate this also because, as I reported at the start of this thread, I looked around extensively and I couldn't find any instructions about how to achieve this result but I'm sure many users wish to make such mass or batch conversions.) I should clarify that I didn't think would be "simple to execute"! With *NO* abilities of my own in this area at all, I don't regard *any* of this as simple! I'll download the code from your site and I'll also check Greg Maxey's user-defined batch code. This will help me learn about batch programs. My data directory occupies its own partition of c. 32.25 GB on one of my two internal hard drives but, as I explained, it's extensively branched, with more than 52K folders and 94K files. I'll want to back up my entire data directory first and I'll then try your code on a few sub-directories before I "let it rip" from the root. Yes, I fully understand that I'll use this code at my own risk and without any recourse to you. I'll let you know how this works out. Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... The advantage of the macro I posted, over yours, was that mine runs on a complete folder, whereas yours runs on a single file. If your files are not scattered haphazardly over the hard drive, then the documents will be in a limited number of places which should be easy to identify. Unfortunately what you propose is not quite as simple to execute as you imagine. However true to my word, I have investigated further and I have located a procedure which I believe will do what you propose. As it is somewhat complex, I have decided not to post the code here, but have incorporated it as an add-in for Word 2007. You can download it from my web site via the following link. http://www.gmayor.com/Extras/WorksConverter.dotm Save to the Word startup folder as defined at Word Options Advanced File locations Startup (by default - C:\Documents and Settings\%username%\Application Data\Microsoft\Word\STARTUP) and it will load with Word When loaded it puts a button on the Developer Tab of the ribbon (Convert Works WPS format). If the developer tab is not displayed add it from Word Options Popular. I have tested it with a limited number of wps files and it will convert them to docx in the manner already discussed. It will also access the sub folders under the folder you select from the initial dialog when the macro is run. However, searching for 20k files across a complete hard drive is uncharted waters and not something I have been able to test. However you may set the folder to search from as the root of the drive and it will search the whole drive. While running, it may blank the Word screen, and when run on a large drive it will take some time to find the files in question, let alone process them. When finished it will return to the Word screen, with no document open, at the Home tab. I offer the add-in 'as seen' and accept no responsibility for any problems that you may encounter when running it. Fellow MVP Greg Maxey has a different function available on his web site - http://gregmaxey.mvps.org/Process_Batch_Folder.htm which has a 'User Defined' process option that could be modified to convert the files, should you wish to investigate another approach. |
#12
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Graham: I'll comment about three topics in this message. I'll number them for your reference in case you wish to scroll right through my typical "overkill" from one topic to another: 1. THANKS UPON THANKS I can't thank you enough for your sustained attention to this topic. Please realize that I *greatly* appreciate your assistance. I see from your comments on your home page that you're a Usenet "true believer" and I'm therefore confident that you agree with me about the value of providing this type of guidance for the use of *everyone* in the entire *global* community! I'm sure that this one effort will help unseen users for years and this one "transaction" is only one of many to which you've contributed. That's why you were designated as an MVP in the first place and that's why you've *remained* an MVP, one year at a time! 2. UNABLE TO OBTAIN CODE I'm happy to see that you've altered the code since you first reported its availability, because I've not yet been able to obtain it. I'll therefore obtain the updated version when I finally succeed. You can probably see from the differences in our respective local times that I was up late last night. (I'm in the NYC area on the US east coast.) I'll not be able to "dig in" to this effort immediately and I'll want to perform system maintenance first, including a data directory back-up, which will take some time, so I'll need to catch up with you later, but I thought I'd let you know now what happens when I try to obtain the code. Let me say at the outset that these problems *may* result from some "excess of caution" by my browser, IE7, but I've *not* been shown any security warnings or other explanations. When I attempt to use this URL in your prior message: ...As it is somewhat complex, I have decided not to post the code here, but have incorporated it as an add-in for Word 2007. You can download it from my web site via the following link. http://www.gmayor.com/Extras/WorksConverter.dotm ... I'm shown the usual "File not found" error page: +++ The page cannot be found The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. -------------------------------------------------------------------------------- Please try the following: a.. Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly. b.. If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted. c.. Click the Back button to try another link. HTTP Error 404 - File or directory not found. Internet Information Services (IIS) +++ Notice I'm not told that access to the page has been blocked for security reasons or for other purposes. The message seems only to suggest that the desired content can't be found. I select, copy, and paste your file name: WorksConverter.dotm into the Google Site Search data-entry field at your home page, and I'm told: +++ Your search - WorksConverter.dotm - did not match any documents. +++ I remove the file extension from the file name, I try the search again, and I'm taken to: http://www.google.com/custom?hl=en&s...w.gmay or.com where I'm told: +++ No standard web pages containing all your search terms were found. Your search - WorksConverter - did not match any documents. +++ but I'm asked: +++ Did you mean: Works Converter +++ (Note the space which has been included between the two words.) I exploit that hyperlinked Google Search suggestion and I'm taken to: http://www.google.com/custom?hl=en&s...verter&spell=1 where I'm shown: +++ a.. Downloadable files Add filters for a variety of applications. WordStar (for DOS) converter for Word - 117kb. Works converters for Word - 186kb ... www.gmayor.com/downloads.htm - Similar pages a.. What's New? Added the Microsoft Works and Word Perfect text converters to the downloads page and a couple of extra new house photos. Some changes to the layout of the ... www.gmayor.com/Whats_New.htm - Similar pages a.. Copy Vinyl or Tape Recordings to CDR ... signal to the sound card on the PC and its analogue to digital converter. ... The Shure cartridge works fine in the SME arm and the arm works well with ... www.gmayor.com/copy_vinyl_to_CDR.htm - Similar pages a.. Microsoft Word Tips File converter dialog shows garbage when opening documents in Word ..... This is due to a bug in the Works add-in. This page explains how to deal with it. ... www.gmayor.com/Word_pages.htm - Similar pages +++ I don't see the "Extras" page at your site which is named in the full file path in the URL which you provided for the code but, on the Downloads page, at: http://www.gmayor.com/downloads.htm I do see that this Works item is the last citation in the File converter downloads list. That suggests this is the most recent offering and that it *may* be the item you're referring to: +++ Works converters for Word - 186kb +++ I downloaded that item. It's a WinZip archive which includes: +++ 4 CNV files, modified on 6-20-02 and 6-16-03 1 REG file, modified on 11-17-04 1 Read Me TXT file, also modified on 11-17-04 +++ This is the complete text of the 187 byte Read Me file: +++ Extract the cnv files to the folder C:\Program Files\Common Files\Microsoft Shared\TextConv and merge the reg file into the registry (right click in Windows Explorer and select 'merge') +++ The modification dates suggest that I've not obtained the Works converter you offered to me. Am I correct? 3. BASIC MACRO QUESTIONS WHICH YOU *MAY* WISH TO ANSWER I've admitted that I'm completely new to macros and to Visual Basic. I don't claim to have any understanding of either topic. Your statement that your new macro/add-in is "complex" gives me some pause, as does the reference to the Registry in the above-mentioned Works converter, which may or may not be the new item which you're offering for my use now. I previously showed you the complete text of my own supposed "Convert-Save-Close" macro. I'll include it again in this message, below. It's the first functional macro I've ever created, in Word 2007 or in any other application. I followed the Windows 2007 Help instructions about how to "Record a Macro" but my initial efforts weren't successful; I didn't record any code on my first attempt and my second macro wouldn't "run." I used the Edit interface from the Macro menu on the Developer tool bar or ribbon or tab or whatever it's called, and I could see that the code which had been written for my failed second attempt included several lines which seemed to refer to the "Save As" option. I didn't copy any of the Visual Basic (?) text from the Edit interface, but I did take some screen shots of it, and I extracted the Plain Text which I show below from one of those images, by using OCR. I ran through the process of opening, converting, saving, and then closing four consecutive files from my desktop search engine's list of WPS files, which began at the root of my data directory. I assumed I was "showing the macro recorder" what I wanted the macro to do. I hoped the macro-recording capability would function like a "keylogger," and I hoped this would allow the macro to be able to repeat what I'd done, automatically, although I was skeptical, because this seemed far too much to ask of such a simple "program." I realized I'd not given the macro any instructions about how to operate the desktop search engine, about how to obtain a list of all WPS in a directory, about how to move through such a list, etc. Nonetheless, I hoped the macro would be able to operate automatically, as I've discussed with you. I hoped it would be able to "run through" the search engine's list of WPS files, opening each file in succession, converting each file from Works 7.0 to Word 2007, saving the file, closing the file, returning to the search engine list for the next file, and repeating the process until all of the files in the list had been converted, so that's what I "demonstrated" for the macro, "manually." I'm sure it'll amuse you that, in my absolute ignorance, I "demonstrated" this process for the macro recorded four times, "just to be sure" that the recorder could see what I'd done... The code began this way, for the first of the four "demonstrations" of what I wanted the macro to do: +++ Sub Macro2() ' ' Macro2 Macro ' Automatically locates and then converts all extant Works "word processing" files to Word 2007. ' ActiveDocument.Convert ActiveDocument.SaveAs FileName:= _ "(The full file path and file names of the four files which I converted "for the benefit of the macro" were each indicated here, inside this set of quotation marks, with one such entry of this type for each of the four files, each with a DOCX extension.)" FileFormat:=wdFormatXMLDocument, LockComments:=False, Password:="", _ AddToRecentFiles:=True, WritePassword:="", ReadOnlyRecommended:=False, _ EmbedTrueTypeFonts:=False, SaveNativePictureFormat:=False, SaveFormsData _ :=False, SaveAsAOCELetter:=False ActiveDocument.Save ActiveWindow.Close ActiveDocument.Convert ActiveDocument.SaveAs FileName:=... +++ That type of code was recorded for each of the four "demonstrations" and then the code ended this way. (I've included the last two lines of the fourth of the four "entries," plus the last line of code): +++ ...ActiveDocument.Save ActiveWindow.Close End Sub +++ I never expected this would work, and I wasn't surprised when this code "didn't run" when I tried to operate it via its new control button on the Word 2007 Quick Access Toolbar of any WPS file which was opened in Word 2007. I noticed the reference to the "Save As" dialog in the unsuccessful code. I assumed that reference could be causing the macro to "fixate" on the specific full file paths and file names of the four files which had already been converted. I assumed that alone could disable the macro and I didn't want to use the "Save As" option anyway; I wanted to use the "Convert" option, then the "Save" option, rather than the "Save As" option. So, in my blissfully ignorant way, I simply used basic word processing techniques to select all code other than what *seemed* to be references to the desired "controls," I deleted my selection, and I was left with this (which includes my rewritten "description" in the apparent "Comment" code, at the start. I'd assumed that the macro itself wouldn't be able to open and then convert, save, and close an endless series of files in the search engine's list automatically, as I'd hoped, I assumed it would be necessary for me to run the macro "manually" from each file's Quick Access Toolbar once I'd "manually opened" each file, and I re-wrote the "description" on the basis of that assumption): +++ Sub Macro3() ' ' Macro3 ' Automates the steps of the Conversion process within a Works 7.0 "word processing" file which has already been opened in Word 2007. ' ActiveDocument.Convert ActiveDocument.Save ActiveWindow.Close End Sub +++ (I reported this code in this thread previously.) I nearly "fell off my desk chair" when, to my great surprise, that puny little "macro" actually WORKED! I'm now wondering: A. Is such "skimpy" code potentially problematical? It does *seem* to achieve the desired results even if, as you pointed out, it must be operated manually in each file, "one-by-one." It's not able to run automatically, as I'd hoped it would. Am I "living in a fool's paradise" because I'm building up greater and greater potential for future problem on some "future day of reckoning" the more I use such "stripped-down" code? Did I remove critical code from this "skeletal" macro? B. If my minimal code is "OK," then is it possible to achieve more complex results (such as the automatic operation which we've been discussing, in all sub-folders of directories) with code which isn't much more complicated, or do I demonstrate my "blissful ignorance" by asking such a stupid question? My "real or imagined macro" does at least *seem* to be working, and, as I say, it consists only of the apparent "operative" elements: the "controls" themselves, or at least "coded references" to the controls. I'm not even attempting to question your statement that your code is much more complex. I assume that may indeed be required, but I'm wondering about the Registry and about other "deep" features which might cause problems. I stress my appreciation of all you've done so far and I'm not asking you to answer these questions unless they interest you! THANKS AGAIN, Graham! Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... I have found a minor bug in the add-in whilst testing, now fixed and updated on the web site. It shouldn't affect the process, but I took the opportunity to remove some superfluous code. It seems reliable even running it on my full C drive of 200 gb without drama! If it works for you, let me know and I'll post a permanent link on my web site. (snipped) |
#13
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Jeffrey L. Hook wrote:
Graham: 1. THANKS UPON THANKS You are welcome 2. UNABLE TO OBTAIN CODE As dotm files may be used to carry malicious code, I suspect it may have been blocked by Windows security. I have compressed the file to zip format and re-added it to the web site. I have checked this new link and it works from here - http://www.gmayor.com/Zips/WorksConverter.zip. Extract the file from the zip to the Word startup folder. The zip file is NOT linked to my web site. The only link is that in this message. 3. BASIC MACRO QUESTIONS WHICH YOU *MAY* WISH TO ANSWER You are not a man of few words The macro is complex in that it uses several functions in different modules, that make providing an add-in a lot less effort than reproducing it in a text message with explanations on how to apply it. The code is not protected if you wish to open the template in Word and examine it. It is based on code from http://www.vbaexpress.com/kb/getarticle.php?kb_id=246 and http://www.vbaexpress.com/kb/getarticle.php?kb_id=245 Simply click the button on the developer toolbar and select a start folder. The macro will run from that start location, its sub folders and their sub folders. Start with a sample folder low down the directory tree if you wish. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#14
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
The following was lost in the fog
Jeffrey L. Hook wrote: I'm now wondering: A. Is such "skimpy" code potentially problematical? It does *seem* to achieve the desired results even if, as you pointed out, it must be operated manually in each file, "one-by-one." It's not able to run automatically, as I'd hoped it would. Am I "living in a fool's paradise" because I'm building up greater and greater potential for future problem on some "future day of reckoning" the more I use such "stripped-down" code? Did I remove critical code from this "skeletal" macro? Your last effort is a perfectly viable macro. It provides a simple series of functions which it achieves. That is all a macro is required to do - process functions to save manual effort. The complexity arrives when the functions you want to process are not so simple, when there are alternatives to consider or potential errors to account for. B. If my minimal code is "OK," then is it possible to achieve more complex results (such as the automatic operation which we've been discussing, in all sub-folders of directories) with code which isn't much more complicated, or do I demonstrate my "blissful ignorance" by asking such a stupid question? The core of the code (your macro) is simple enough. My earlier macros demonstrated how to process the current folder. It is the processing of all the potential sub folders that is more complicated My "real or imagined macro" does at least *seem* to be working, and, as I say, it consists only of the apparent "operative" elements: the "controls" themselves, or at least "coded references" to the controls. I'm not even attempting to question your statement that your code is much more complex. I assume that may indeed be required, but I'm wondering about the Registry and about other "deep" features which might cause problems. The macros (yours and mine) do not write to the registry. It is possible to write to the registry from a macro (there are examples on my web site) but that is something to leave until you are more proficient with vba and the potential consequences of what you are doing. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#15
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Graham, "you are a gentleman and a scholar." With respect to your accurate observation that You are not a man of few words and your wry comment that The following was lost in the fog I must thank you for stating the problem diplomatically. My intentions are good, but my "unstinting" efforts are often pretty pathological. I may be in the terminal stages of a case of acute obsessive-compulsive disorder. It drives me to be sure that I've "covered" everything and the resulting excessiveness so powerfully annoys most people that I'm all the more appreciative of your willingness to "hang in here" and to stay with this thread. Lesser men would have given up on this long ago. "Hey MVP Certification Committee! Are you *reading* this? Has this guy EARNED a 'distinguished service' award, or *WHAT*?!" Thanks for clarifying in your last message that your code wasn't linked to your Web site. I could have provided far less information about my inability to obtain the code, but I wanted you to have the texts of the error messages, etc. You'll look around for something hard which you can throw at my head when I say this, but it's almost "fun" to see how much I can "pack in" to an unformatted Plain Text message by using "text dividers," like this: +++ +++ by numbering and capitalizing "topic headings," and by moving some content below my signature as "optional" text. (The below-the-signature-gambit may be "the last resort of a scoundrel," to paraphrase Dr. Johnson.) These tactics may preserve legibility, just barely, but, as you point out, overloading messages does create "fog." It also provokes "extreme reader resentment"... I have obtained your code. I'm delighted that you not only created a tool for my use (and, of course, for the use of hundreds of other "unseen" users who'll benefit from your macro in the future) but that you explained the code and that you also answered my questions so responsively and so thoughtfully. You've done all the work but I'm going to give myself some time off today. I'll proceed anon as I explained previously. Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... The following was lost in the fog (snipped) |
#16
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Graham: I've tested your macro. The macro seemed to work well. Its icon button was displayed on the Developer ribbon when the DOTM file was opened directly from within the WinZip archive and I thought I could run the macro there if I could see it. When I clicked the macro's button I was shown the "Browse" dialogue, I selected the desired starting folder, and I clicked the "OK" button but the macro wouldn't run until I'd extracted it to the Word\STARTUP system folder which you identified. I tested the macro on a "straight copy" of my entire data directory which I'd pasted to an external USB2 hard drive on February 8th of this year. (That content had simply been copied via the Windows Explorer Edit\Copy and Edit\Paste menus from the data partition of one of the two internal hard drives to the data backup partition of the external hard drive.) The USB connection may have slowed the macro down but the speed seemed to be pretty good. I assume the macro may operate more quickly in the current directory on the internal hard drive. The macro didn't blacken the screen. It seemed to close all Word 2007 files which had been open when I ran it, asking me if I wished to save any unsaved changes, and closing without comment files which had no unsaved changes. It then operated "under cover of" the apparent "basic GUI" of the Word 2007 executable, the standard Word 2007 interface which was identified as Microsoft Word non-commercial use on its Title Bar. Text along the bottom of the Word GUI identified the files and indicated whether they were being converted or saved. The macro did "drill down" along file paths, through sub-directories. The only problem resulted not from any defect of your code but from a larger than expected number of old Works 4.0 files. I wonder if any macro could be written to evade this problem. For each of those old files the conversion process was stopped, an annoying sounder was played, and I was shown a "Microsoft Office Word" "yellow triangle and black exclamation point" security warning. I was told the file "needs to be opened by the Works 4.0 for Windows text converter, which may pose a security risk if the file you are opening is a malicious file." It was necessary to left-click the security warning's "OK" button to proceed for each file. These files popped up persistently in the older sections of my directory. I wasn't given a "Yes to all" option, so the repeated displays of this warning slowed the batch coversion down and precluded the unattended automatic operation which your code would otherwise have been able to complete. If I'd left the system, hoping the conversion would have continued unattended until all files were converted, I'd have returned to find that the entire process had stopped as soon as the first of those old files was encountered. I'd been seeing those same security warnings when I was "banging through" lists of files which had been displayed by my desktop search engine. I may be able to set the desktop engine to look only for WPS files which were modified between dates which may be old enough to catch many of the old files. I can then use my own method of opening those files in Word 2007 by using their context menus directly in the search engine's list, and I can use my own simple "one at a time" macro to convert, save, and close each file from its Quick Access Toolbar in Word 2007. I can then return to the search engine's list for the next file, etc. Thanks again, Graham! Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... ....I have found a minor bug in the add-in whilst testing, now fixed and updated on the web site. It shouldn't affect the process, but I took the opportunity to remove some superfluous code. It seems reliable even running it on my full C drive of 200 gb without drama! If it works for you, let me know and I'll post a permanent link on my web site... |
#17
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
The security warning will occur for any old files that don't use the current
Works converter and is out of my control. Microsoft has identified what it believes to be a potential security issue with the old converter and thus prompts for each such document. I have made a few minor modifications to the macro code concerned with presentation (that won't affect the security issue) and posted it with instructions to my web site - http://www.gmayor.com/Works_Batch_Converter.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jeffrey L. Hook wrote: Graham: I've tested your macro. The macro seemed to work well. Its icon button was displayed on the Developer ribbon when the DOTM file was opened directly from within the WinZip archive and I thought I could run the macro there if I could see it. When I clicked the macro's button I was shown the "Browse" dialogue, I selected the desired starting folder, and I clicked the "OK" button but the macro wouldn't run until I'd extracted it to the Word\STARTUP system folder which you identified. I tested the macro on a "straight copy" of my entire data directory which I'd pasted to an external USB2 hard drive on February 8th of this year. (That content had simply been copied via the Windows Explorer Edit\Copy and Edit\Paste menus from the data partition of one of the two internal hard drives to the data backup partition of the external hard drive.) The USB connection may have slowed the macro down but the speed seemed to be pretty good. I assume the macro may operate more quickly in the current directory on the internal hard drive. The macro didn't blacken the screen. It seemed to close all Word 2007 files which had been open when I ran it, asking me if I wished to save any unsaved changes, and closing without comment files which had no unsaved changes. It then operated "under cover of" the apparent "basic GUI" of the Word 2007 executable, the standard Word 2007 interface which was identified as Microsoft Word non-commercial use on its Title Bar. Text along the bottom of the Word GUI identified the files and indicated whether they were being converted or saved. The macro did "drill down" along file paths, through sub-directories. The only problem resulted not from any defect of your code but from a larger than expected number of old Works 4.0 files. I wonder if any macro could be written to evade this problem. For each of those old files the conversion process was stopped, an annoying sounder was played, and I was shown a "Microsoft Office Word" "yellow triangle and black exclamation point" security warning. I was told the file "needs to be opened by the Works 4.0 for Windows text converter, which may pose a security risk if the file you are opening is a malicious file." It was necessary to left-click the security warning's "OK" button to proceed for each file. These files popped up persistently in the older sections of my directory. I wasn't given a "Yes to all" option, so the repeated displays of this warning slowed the batch coversion down and precluded the unattended automatic operation which your code would otherwise have been able to complete. If I'd left the system, hoping the conversion would have continued unattended until all files were converted, I'd have returned to find that the entire process had stopped as soon as the first of those old files was encountered. I'd been seeing those same security warnings when I was "banging through" lists of files which had been displayed by my desktop search engine. I may be able to set the desktop engine to look only for WPS files which were modified between dates which may be old enough to catch many of the old files. I can then use my own method of opening those files in Word 2007 by using their context menus directly in the search engine's list, and I can use my own simple "one at a time" macro to convert, save, and close each file from its Quick Access Toolbar in Word 2007. I can then return to the search engine's list for the next file, etc. Thanks again, Graham! Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... ...I have found a minor bug in the add-in whilst testing, now fixed and updated on the web site. It shouldn't affect the process, but I took the opportunity to remove some superfluous code. It seems reliable even running it on my full C drive of 200 gb without drama! If it works for you, let me know and I'll post a permanent link on my web site... |
#18
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Graham: I've just finished running your excellent code on my entire data directory. Thanks to you, I've been able to convert all but 47 of those pesky WPS so far. The DOCX count is now 23,985. I think your code performed very well. If by changing the "presentation" you mean that you added some progress/activity display, I think that would be good. The lack of a clear display of what was happening was a little disconcerting, but Task Manager's Performance tab showed high CPU-use and its Applications tab did show names of files which were being processed. The best source of information was the Recycle Bin. Because your code used the Office\Convert converstion method, as I'd requested, rather than the Office\Save As\Word Document method, the WPS files were all pitched in the dust bin, as you might say, and it was actually fun to watch them accumulate there. This also showed how your mighty macro was plowing through the hierarchy. I indulged myself by trying to intercept it as it whizzed by. By noting the file names on the Applications tab in Task Manager I could expand some paths in the Folder pane of Windows Explorer in the Windows Classic View, and it was fun to see the WPS files shift to DOCX, so to speak, "as the train went by." An added benefit of the pitching of WPS files into the Recycle Bin is the option of sorting the bin's contents by date and time of deletion. This allowed me to select all items which had been deleted, for example, at 3:08 AM, starting with the first item with that minute value, and ending with the last items before 3:09 AM. I then deleted all selected files from the bin by using the context menu of the selected files, and Windows asked me if I wished to delete all XX items. Your "machine" ran at speeds of up to 75 conversions per minute in the light sections of my hierarchy. I was able to use my desktop search engine to work around the annoying security warnings for which no "Yes to all" response option was given. (I agree that none of that aggravation is your doing.) I checked my records of when I installed Works 6.0 as an upgrade of 4.5a and I found that, as I'd suspected, the "Works 4.0" security warnings were also given for all 4.5a files which hadn't previously been saved to 6.0 or 7.0 but they stopped as soon as I'd installed Works 6.0 so that showed me the chronological cut-off point for those warnings. There were 636 files which all produced the warnings and I was forced to convert them all "semi-manually" and individually using their context menus in the search list of my search engine and then using my own "one-shot" macro on each file in Word 2007. Once those truly annoying security warnings were out of its way your macro ran beatifully but the major impediment to this process was my own ignorance. The train metaphor seems to be good. I must admit "I left a lot of debris on the track." It derailed your macro many times. I'd been worrying about "propagating a taint" from Works to Word and I'd actually planned only to retain converted WPS files temporarily, until I could paste their converted contents to "clean, untainted" DOCX templates, which hadn't been converted from WPS and which had been created exclusively "from the keyboard" in Word 2007. I'd added a file-name suffix -Delete to the names of the WPS files so that, when they were converted to DOCX I'd be able to recognize them as possibly tainted, and as appropriate only as a source of converted content. I'd dutifully used the Office\Save As\Word Document conversion method which had been recommened by Word 2007's Help directory for a while, and that had left the original WPS files behind, so there were enough of these screwball situations that Word was hopelessly confused when it attempted to convert those files; it found DOCX files with the same name had already been created and that halted the process. I was able to use my desktop engine to search for files by name and, when I found both a WPS and DOCX file with the same name in the engine's search-results list, I simply deleted the WPS parts of those "pairs" right in the engine's list. Another problem wasn't in any way caused by your code. I do think excellent Help is provided on-line for Word 2007 but I'm not so happy about the organization of the information. I've found myself often "dumped" at a Table of Contents type Web page when I'm looking for guidance, as if I've been led to the library door and told to look for myself. The conversion process was many times interrupted by "serious problems" which crashed Word when Word attempted to convert some old corrupted Works junk. This lead to "recovery" of files and Word stubbornly insisted on showing me a lengthening list of such files, which it seemed to be insisting should be "Saved As" with new file names each time the conversion process was resumed. I admit I didn't have the foggiest idea of what was happening, but I wasn't given good guidance, and I didn't want to suspend this project while I invested a week browsing around widely-scattered on-line Help texts. I admit that I may have stressed Works' word processor by mistakes which I may have made in my past use of several versions of the application, but I also think Works is not as stable as it could be. I'm happy this is done at last. Thanks, Graham. I will be interested to check out your presentation of the code at your site, but right now I'm finally going to turn in "for the night" as dawn is breaking! Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... The security warning will occur for any old files that don't use the current Works converter and is out of my control. Microsoft has identified what it believes to be a potential security issue with the old converter and thus prompts for each such document. I have made a few minor modifications to the macro code concerned with presentation (that won't affect the security issue) and posted it with instructions to my web site - http://www.gmayor.com/Works_Batch_Converter.htm |
#19
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
I avoided the use of a progress indicator as this would have only slowed the
process further - and you would still be up watching it run Glad you found it useful. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jeffrey L. Hook wrote: Graham: I've just finished running your excellent code on my entire data directory. Thanks to you, I've been able to convert all but 47 of those pesky WPS so far. The DOCX count is now 23,985. I think your code performed very well. If by changing the "presentation" you mean that you added some progress/activity display, I think that would be good. The lack of a clear display of what was happening was a little disconcerting, but Task Manager's Performance tab showed high CPU-use and its Applications tab did show names of files which were being processed. The best source of information was the Recycle Bin. Because your code used the Office\Convert converstion method, as I'd requested, rather than the Office\Save As\Word Document method, the WPS files were all pitched in the dust bin, as you might say, and it was actually fun to watch them accumulate there. This also showed how your mighty macro was plowing through the hierarchy. I indulged myself by trying to intercept it as it whizzed by. By noting the file names on the Applications tab in Task Manager I could expand some paths in the Folder pane of Windows Explorer in the Windows Classic View, and it was fun to see the WPS files shift to DOCX, so to speak, "as the train went by." An added benefit of the pitching of WPS files into the Recycle Bin is the option of sorting the bin's contents by date and time of deletion. This allowed me to select all items which had been deleted, for example, at 3:08 AM, starting with the first item with that minute value, and ending with the last items before 3:09 AM. I then deleted all selected files from the bin by using the context menu of the selected files, and Windows asked me if I wished to delete all XX items. Your "machine" ran at speeds of up to 75 conversions per minute in the light sections of my hierarchy. I was able to use my desktop search engine to work around the annoying security warnings for which no "Yes to all" response option was given. (I agree that none of that aggravation is your doing.) I checked my records of when I installed Works 6.0 as an upgrade of 4.5a and I found that, as I'd suspected, the "Works 4.0" security warnings were also given for all 4.5a files which hadn't previously been saved to 6.0 or 7.0 but they stopped as soon as I'd installed Works 6.0 so that showed me the chronological cut-off point for those warnings. There were 636 files which all produced the warnings and I was forced to convert them all "semi-manually" and individually using their context menus in the search list of my search engine and then using my own "one-shot" macro on each file in Word 2007. Once those truly annoying security warnings were out of its way your macro ran beatifully but the major impediment to this process was my own ignorance. The train metaphor seems to be good. I must admit "I left a lot of debris on the track." It derailed your macro many times. I'd been worrying about "propagating a taint" from Works to Word and I'd actually planned only to retain converted WPS files temporarily, until I could paste their converted contents to "clean, untainted" DOCX templates, which hadn't been converted from WPS and which had been created exclusively "from the keyboard" in Word 2007. I'd added a file-name suffix -Delete to the names of the WPS files so that, when they were converted to DOCX I'd be able to recognize them as possibly tainted, and as appropriate only as a source of converted content. I'd dutifully used the Office\Save As\Word Document conversion method which had been recommened by Word 2007's Help directory for a while, and that had left the original WPS files behind, so there were enough of these screwball situations that Word was hopelessly confused when it attempted to convert those files; it found DOCX files with the same name had already been created and that halted the process. I was able to use my desktop engine to search for files by name and, when I found both a WPS and DOCX file with the same name in the engine's search-results list, I simply deleted the WPS parts of those "pairs" right in the engine's list. Another problem wasn't in any way caused by your code. I do think excellent Help is provided on-line for Word 2007 but I'm not so happy about the organization of the information. I've found myself often "dumped" at a Table of Contents type Web page when I'm looking for guidance, as if I've been led to the library door and told to look for myself. The conversion process was many times interrupted by "serious problems" which crashed Word when Word attempted to convert some old corrupted Works junk. This lead to "recovery" of files and Word stubbornly insisted on showing me a lengthening list of such files, which it seemed to be insisting should be "Saved As" with new file names each time the conversion process was resumed. I admit I didn't have the foggiest idea of what was happening, but I wasn't given good guidance, and I didn't want to suspend this project while I invested a week browsing around widely-scattered on-line Help texts. I admit that I may have stressed Works' word processor by mistakes which I may have made in my past use of several versions of the application, but I also think Works is not as stable as it could be. I'm happy this is done at last. Thanks, Graham. I will be interested to check out your presentation of the code at your site, but right now I'm finally going to turn in "for the night" as dawn is breaking! Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... The security warning will occur for any old files that don't use the current Works converter and is out of my control. Microsoft has identified what it believes to be a potential security issue with the old converter and thus prompts for each such document. I have made a few minor modifications to the macro code concerned with presentation (that won't affect the security issue) and posted it with instructions to my web site - http://www.gmayor.com/Works_Batch_Converter.htm |
#20
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
It's probably a bit late to help you, but I believe I have resolved the
security warning issue. The revised version is on my web site. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Graham Mayor wrote: I avoided the use of a progress indicator as this would have only slowed the process further - and you would still be up watching it run Glad you found it useful. Jeffrey L. Hook wrote: Graham: I've just finished running your excellent code on my entire data directory. Thanks to you, I've been able to convert all but 47 of those pesky WPS so far. The DOCX count is now 23,985. I think your code performed very well. If by changing the "presentation" you mean that you added some progress/activity display, I think that would be good. The lack of a clear display of what was happening was a little disconcerting, but Task Manager's Performance tab showed high CPU-use and its Applications tab did show names of files which were being processed. The best source of information was the Recycle Bin. Because your code used the Office\Convert converstion method, as I'd requested, rather than the Office\Save As\Word Document method, the WPS files were all pitched in the dust bin, as you might say, and it was actually fun to watch them accumulate there. This also showed how your mighty macro was plowing through the hierarchy. I indulged myself by trying to intercept it as it whizzed by. By noting the file names on the Applications tab in Task Manager I could expand some paths in the Folder pane of Windows Explorer in the Windows Classic View, and it was fun to see the WPS files shift to DOCX, so to speak, "as the train went by." An added benefit of the pitching of WPS files into the Recycle Bin is the option of sorting the bin's contents by date and time of deletion. This allowed me to select all items which had been deleted, for example, at 3:08 AM, starting with the first item with that minute value, and ending with the last items before 3:09 AM. I then deleted all selected files from the bin by using the context menu of the selected files, and Windows asked me if I wished to delete all XX items. Your "machine" ran at speeds of up to 75 conversions per minute in the light sections of my hierarchy. I was able to use my desktop search engine to work around the annoying security warnings for which no "Yes to all" response option was given. (I agree that none of that aggravation is your doing.) I checked my records of when I installed Works 6.0 as an upgrade of 4.5a and I found that, as I'd suspected, the "Works 4.0" security warnings were also given for all 4.5a files which hadn't previously been saved to 6.0 or 7.0 but they stopped as soon as I'd installed Works 6.0 so that showed me the chronological cut-off point for those warnings. There were 636 files which all produced the warnings and I was forced to convert them all "semi-manually" and individually using their context menus in the search list of my search engine and then using my own "one-shot" macro on each file in Word 2007. Once those truly annoying security warnings were out of its way your macro ran beatifully but the major impediment to this process was my own ignorance. The train metaphor seems to be good. I must admit "I left a lot of debris on the track." It derailed your macro many times. I'd been worrying about "propagating a taint" from Works to Word and I'd actually planned only to retain converted WPS files temporarily, until I could paste their converted contents to "clean, untainted" DOCX templates, which hadn't been converted from WPS and which had been created exclusively "from the keyboard" in Word 2007. I'd added a file-name suffix -Delete to the names of the WPS files so that, when they were converted to DOCX I'd be able to recognize them as possibly tainted, and as appropriate only as a source of converted content. I'd dutifully used the Office\Save As\Word Document conversion method which had been recommened by Word 2007's Help directory for a while, and that had left the original WPS files behind, so there were enough of these screwball situations that Word was hopelessly confused when it attempted to convert those files; it found DOCX files with the same name had already been created and that halted the process. I was able to use my desktop engine to search for files by name and, when I found both a WPS and DOCX file with the same name in the engine's search-results list, I simply deleted the WPS parts of those "pairs" right in the engine's list. Another problem wasn't in any way caused by your code. I do think excellent Help is provided on-line for Word 2007 but I'm not so happy about the organization of the information. I've found myself often "dumped" at a Table of Contents type Web page when I'm looking for guidance, as if I've been led to the library door and told to look for myself. The conversion process was many times interrupted by "serious problems" which crashed Word when Word attempted to convert some old corrupted Works junk. This lead to "recovery" of files and Word stubbornly insisted on showing me a lengthening list of such files, which it seemed to be insisting should be "Saved As" with new file names each time the conversion process was resumed. I admit I didn't have the foggiest idea of what was happening, but I wasn't given good guidance, and I didn't want to suspend this project while I invested a week browsing around widely-scattered on-line Help texts. I admit that I may have stressed Works' word processor by mistakes which I may have made in my past use of several versions of the application, but I also think Works is not as stable as it could be. I'm happy this is done at last. Thanks, Graham. I will be interested to check out your presentation of the code at your site, but right now I'm finally going to turn in "for the night" as dawn is breaking! Jeff Hook, NJ, USA "Graham Mayor" wrote in message ... The security warning will occur for any old files that don't use the current Works converter and is out of my control. Microsoft has identified what it believes to be a potential security issue with the old converter and thus prompts for each such document. I have made a few minor modifications to the macro code concerned with presentation (that won't affect the security issue) and posted it with instructions to my web site - http://www.gmayor.com/Works_Batch_Converter.htm |
#21
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Graham:
It's probably a bit late to help you, but I believe I have resolved the security warning issue. The revised version is on my web site. You've helped me tremendously. I'd now like to try to help other users who will find this thread in the future and who'll want to complete their own "mass" or "batch" conversions of large numbers of files. I'd therefore like to clarify two remaining topics. I've captioned them and I've put clarification of the first topic below my signature, as optional text: 1. PROBLEM OF THE INTERRUPTION OF THE MACRO'S AUTOMATIC OPERATION BY THE SECURITY-WARNINGS: I used my "semi-manual" method to convert nearly 636 WPS files which had last been modified in Works 4.0 and in Works 4.5a. I only afterward wondered if I'd "blown it": You say this at the instructions page for your batch converter: http://www.gmayor.com:80/Works_Batch_Converter.htm +++++ ....The add-in requires the Works converter to be installed prior to running the macro. Word 2007 comes with a converter that will open recent versions of Works WPS format. Older Works file versions require earlier converters which you can download from the downloads page of this site... +++++ You also say this at your "Downloadable files" page, at the top of the page, in your discussion of the batch converter: http://www.gmayor.com/downloads.htm +++++ ....Batch converter for Works WPS format to DOCX - 27kb - An add-in for Word 2007 to batch convert Works WPS format documents to Word 2007 DOCX format and a dedicated page of user instructions. For old Works documents, you may also require the Works converters that you will find below... +++++ Two questions about this topic: A. Could I have eliminated this problem entirely by running your old-file converter in order to convert the Works 4.0 and 4.5a files first, before I ran the batch-converter? B. Did you solve the security warning problem by incorporating your old-file conversion code into the batch converter? 2. OBSERVING THE CODE OF THE LATEST VERSION OF THE BATCH CONVERTER: I've also downloaded this version, although I've not run it because, as you realized, the first version completed my project for me. I would like to observe the code of this version, however. I previously reported how I used the "Edit" button on the right side of the "Macros" dialog from the left end of the Developer ribbon to view the code of the first batch converte in the VBA GUI. I see that the current version is an Add-in and that it appears on the Add-in ribbon, rather than on the Developer ribbon. Is it possible to view the code of the current macro? Can you explain how I can do this? Thanks for all your excellent assistance. Jeff Hook, NJ, USA (**Optional** clarification of the security warning problem is below.) I explained in my message of April 30th how conversion of older Works WPS files interrupted the *automatic* operation of the batch-conversion macro. A security warning was displayed for each old file. The warning explained "This file needs to be opened by the Works 4.0 for Windows text converter, which may pose a security risk if the file you are opening is a malicious file." The warning incorporated this Help text: +++++ You are trying to open a file with a converter that may pose a security risk. The following converters, which were included in earlier versions of Microsoft Office Word, may pose a security risk if the file that you are opening is not from a trusted source: Text with Layout (*.ans) Microsoft Excel Worksheet (*.xls) Microsoft Word 6.0/95 (*.doc) Microsoft Word 4.0 for Macintosh (*.mcw) Microsoft Word 5.0 for Macintosh (*.mcw) Microsoft Word 5.1 for Macintosh (*.mcw) Microsoft Word 2.x for Windows (*.doc) Microsoft Works 2000 (*.wps) **Microsoft Works 4.0 for Windows (*.wps)** For more information, see Microsoft Knowledge Base article 837011. +++++ The Knowledge Base article is at: http://support.microsoft.com/?kbid=837011 No "Yes to all" response option was given. It was necessary to left-click the "Yes" button in each warning for each file. The batch-conversion macro couldn't operate automatically until all of these old files were converted. Clicking the "Yes" button on the security warning allowed me to open each file in Word 2007, where I was then able to convert, save, and close each file with a single mouse click on my own "Convert-Save-Close" macro, for which I'd installed an icon button on the Word 2007 Quick Access Toolbar. This therefore could be regarded as a "semi-manual" conversion method: It was necessary to convert each file individually; files couldn't be converted automatically, in an "unattended" process, but part of the process was automated by my own simple macro. The security warnings referred specifically to the "Works 4.0 for Windows text converter" but I suspected the warnings were also shown for Works 4.5a files. My original OEM copy of Works 4.0 was upgraded to Works 4.5a by the Microsoft Y2K CD in late 1999 and I installed Works 6.0 on February 3rd, 2001. I used my desktop search engine to search for all WPS files which had been modified before March 1st, 2001, I sorted the list of files by modification date. I found that files which had still last been modified in Works 4.0 and in Works 4.5a files produced the security warning. Files which had been modified after Works 6.0 was installed didn't produce the warning. JLH "Graham Mayor" wrote in message ... It's probably a bit late to help you, but I believe I have resolved the security warning issue. The revised version is on my web site. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org (snipped) |
#22
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How To Convert Thousands of Works 7.0 Files to Word 2007 Simultaneously
Jeffrey L. Hook wrote:
Two questions about this topic: A. Could I have eliminated this problem entirely by running your old-file converter in order to convert the Works 4.0 and 4.5a files first, before I ran the batch-converter? No. The old converters on my web site merely allow Word to open the older files. You would have got the security warning with these files when running the macro I originally supplied. B. Did you solve the security warning problem by incorporating your old-file conversion code into the batch converter? No - I found a means of suppressing the warning. The macro is independent of the converters. I previously reported how I used the "Edit" button on the right side of the "Macros" dialog from the left end of the Developer ribbon to view the code of the first batch converter in the VBA GUI. I see that the current version is an Add-in and that it appears on the Add-in ribbon, rather than on the Developer ribbon. Is it possible to view the code of the current macro? Can you explain how I can do this? You will need the Office 2007 Custom UI Editor to view and edit the code relating to the Ribbon. I moved the button to the Add-ins ribbon as that seemed a more logical place for it. http://microsoft-office-2007-custom-....informer.com/ Thanks for all your excellent assistance. You are welcome -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert a batch of .wpd files to Word 2007 files? | New Users | |||
how do I convert Works files into Word 2003 running Vista? | Microsoft Word Help | |||
Can Word convert Macintoch Works files? | Microsoft Word Help | |||
Convert older works files to word 2003 | Microsoft Word Help | |||
Opening many word files simultaneously | Microsoft Word Help |