If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A question re corruption
Quite a lot has been written about avoiding corruption of documents, and
one piece of advice has been "do not save to A: from Word (though from Explorer is okay). I habitually save to a memory stick/flash drive in drive E and I would like to automate this with a VBA macro. Does anyone have any information on why saving to A: from Word causes corruption, and more importantly whether or not saving to E: poses the same danger? Alternatively (and OT) is it possible to write a VBA (or other) Macro to invoke this procedure from a hot key while in Windows Explorer (where I currently do this manually)? TIA |
#2
|
|||
|
|||
A question re corruption
I could try to give you the reason I've been told - but probably would end
up phrasing it wrong. All I know is that it has to do with the temp files created - and that it only takes a few more moments to do it correctly. -- JoAnn Paules MVP Microsoft [Publisher] wrote in message ... Quite a lot has been written about avoiding corruption of documents, and one piece of advice has been "do not save to A: from Word (though from Explorer is okay). I habitually save to a memory stick/flash drive in drive E and I would like to automate this with a VBA macro. Does anyone have any information on why saving to A: from Word causes corruption, and more importantly whether or not saving to E: poses the same danger? Alternatively (and OT) is it possible to write a VBA (or other) Macro to invoke this procedure from a hot key while in Windows Explorer (where I currently do this manually)? TIA |
#3
|
|||
|
|||
A question re corruption
The main problem with using floppies is that they don't offer much space.
Others are that they are a lot slower than disk access, and that the user might take the medium out before everything has been written and temp files have been cleaned up. I have heard from Microsoft that they did a lot of work on the issues with removable media (floppys, memory sticks...) in recent versions, and that it is less problematic today. Personally I still avoid to work on removeable media (including to open/save files on them directly from Word). You could write a macro, but I'm not sure it is worth the trouble. You can copy the file path from Word's File dialogs (right-click on the file, Properties Location), and paste it into the Explorer. Greetings, Klaus schrieb im Newsbeitrag ... Quite a lot has been written about avoiding corruption of documents, and one piece of advice has been "do not save to A: from Word (though from Explorer is okay). I habitually save to a memory stick/flash drive in drive E and I would like to automate this with a VBA macro. Does anyone have any information on why saving to A: from Word causes corruption, and more importantly whether or not saving to E: poses the same danger? Alternatively (and OT) is it possible to write a VBA (or other) Macro to invoke this procedure from a hot key while in Windows Explorer (where I currently do this manually)? TIA |
#4
|
|||
|
|||
A question re corruption
The reasons were mainly that floppies are (relatively) VERY slow to read or
write and not the most reliable media. When Word saves (especially in older versions), it needs to build up the saved file and it does this by creating a temporary file in the target folder gradually adding or overwriting bits until it has a complete file. This is then rewritten and saved as the document file. But the temp file is locked and active until the document is fully closed and Word/Windows releases the temp file. Problems become serious if the file is fairly large or the floppy is partially filled because the document file and the temp files may have insufficient room to co-exist on the floppy. To make matters worse, simultaneous reading and writing to the floppy is happening at the very slow rate of the floppy drive. So all in all, it was hardly surprising that floppies were a disaster with Word! The best and safest solution for you is to write your macro to save the file to the main HDD and then COPY or MOVE it to the mem stick. Although Word is not so demanding these days, problems still do occur. I have a colleague who has now twice corrupted large documents using a memory stick to move between home and work to continue working on a document. You now know the risks! -- Terry Farrell - Word MVP http://word.mvps.org/ wrote in message ... : Quite a lot has been written about avoiding corruption of documents, and : one piece of advice has been "do not save to A: from Word (though from : Explorer is okay). I habitually save to a memory stick/flash drive in : drive E and I would like to automate this with a VBA macro. Does anyone : have any information on why saving to A: from Word causes corruption, : and more importantly whether or not saving to E: poses the same danger? : Alternatively (and OT) is it possible to write a VBA (or other) Macro to : invoke this procedure from a hot key while in Windows Explorer (where I : currently do this manually)? : : TIA |
#5
|
|||
|
|||
A question re corruption
Thank you, Terry. I had part of it right but you said it ever so much better
than I would have. -- JoAnn Paules MVP Microsoft [Publisher] "TF" terryfarrell%40%6d%73%6e%2ecom wrote in message ... The reasons were mainly that floppies are (relatively) VERY slow to read or write and not the most reliable media. When Word saves (especially in older versions), it needs to build up the saved file and it does this by creating a temporary file in the target folder gradually adding or overwriting bits until it has a complete file. This is then rewritten and saved as the document file. But the temp file is locked and active until the document is fully closed and Word/Windows releases the temp file. Problems become serious if the file is fairly large or the floppy is partially filled because the document file and the temp files may have insufficient room to co-exist on the floppy. To make matters worse, simultaneous reading and writing to the floppy is happening at the very slow rate of the floppy drive. So all in all, it was hardly surprising that floppies were a disaster with Word! The best and safest solution for you is to write your macro to save the file to the main HDD and then COPY or MOVE it to the mem stick. Although Word is not so demanding these days, problems still do occur. I have a colleague who has now twice corrupted large documents using a memory stick to move between home and work to continue working on a document. You now know the risks! -- Terry Farrell - Word MVP http://word.mvps.org/ wrote in message ... : Quite a lot has been written about avoiding corruption of documents, and : one piece of advice has been "do not save to A: from Word (though from : Explorer is okay). I habitually save to a memory stick/flash drive in : drive E and I would like to automate this with a VBA macro. Does anyone : have any information on why saving to A: from Word causes corruption, : and more importantly whether or not saving to E: poses the same danger? : Alternatively (and OT) is it possible to write a VBA (or other) Macro to : invoke this procedure from a hot key while in Windows Explorer (where I : currently do this manually)? : : TIA |
#6
|
|||
|
|||
A question re corruption
I take it that you all see no problem in copying and pasting within
Windows Explorer then (rather than via a Macro in Word). Or, another thought, can one access Windows Explorer from Word, do it there, and come back again - all in a Macro? TF wrote: The reasons were mainly that floppies are (relatively) VERY slow to read or write and not the most reliable media. When Word saves (especially in older versions), it needs to build up the saved file and it does this by creating a temporary file in the target folder gradually adding or overwriting bits until it has a complete file. This is then rewritten and saved as the document file. But the temp file is locked and active until the document is fully closed and Word/Windows releases the temp file. Problems become serious if the file is fairly large or the floppy is partially filled because the document file and the temp files may have insufficient room to co-exist on the floppy. To make matters worse, simultaneous reading and writing to the floppy is happening at the very slow rate of the floppy drive. So all in all, it was hardly surprising that floppies were a disaster with Word! The best and safest solution for you is to write your macro to save the file to the main HDD and then COPY or MOVE it to the mem stick. Although Word is not so demanding these days, problems still do occur. I have a colleague who has now twice corrupted large documents using a memory stick to move between home and work to continue working on a document. You now know the risks! -- Terry Farrell - Word MVP http://word.mvps.org/ wrote in message ... : Quite a lot has been written about avoiding corruption of documents, and : one piece of advice has been "do not save to A: from Word (though from : Explorer is okay). I habitually save to a memory stick/flash drive in : drive E and I would like to automate this with a VBA macro. Does anyone : have any information on why saving to A: from Word causes corruption, : and more importantly whether or not saving to E: poses the same danger? : Alternatively (and OT) is it possible to write a VBA (or other) Macro to : invoke this procedure from a hot key while in Windows Explorer (where I : currently do this manually)? : : TIA |
#7
|
|||
|
|||
A question re corruption
No, because the file is then closed. There should also not be any problem
using a macro to copy a closed file. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP wrote in message ... I take it that you all see no problem in copying and pasting within Windows Explorer then (rather than via a Macro in Word). Or, another thought, can one access Windows Explorer from Word, do it there, and come back again - all in a Macro? TF wrote: The reasons were mainly that floppies are (relatively) VERY slow to read or write and not the most reliable media. When Word saves (especially in older versions), it needs to build up the saved file and it does this by creating a temporary file in the target folder gradually adding or overwriting bits until it has a complete file. This is then rewritten and saved as the document file. But the temp file is locked and active until the document is fully closed and Word/Windows releases the temp file. Problems become serious if the file is fairly large or the floppy is partially filled because the document file and the temp files may have insufficient room to co-exist on the floppy. To make matters worse, simultaneous reading and writing to the floppy is happening at the very slow rate of the floppy drive. So all in all, it was hardly surprising that floppies were a disaster with Word! The best and safest solution for you is to write your macro to save the file to the main HDD and then COPY or MOVE it to the mem stick. Although Word is not so demanding these days, problems still do occur. I have a colleague who has now twice corrupted large documents using a memory stick to move between home and work to continue working on a document. You now know the risks! -- Terry Farrell - Word MVP http://word.mvps.org/ wrote in message ... : Quite a lot has been written about avoiding corruption of documents, and : one piece of advice has been "do not save to A: from Word (though from : Explorer is okay). I habitually save to a memory stick/flash drive in : drive E and I would like to automate this with a VBA macro. Does anyone : have any information on why saving to A: from Word causes corruption, : and more importantly whether or not saving to E: poses the same danger? : Alternatively (and OT) is it possible to write a VBA (or other) Macro to : invoke this procedure from a hot key while in Windows Explorer (where I : currently do this manually)? : : TIA |
#8
|
|||
|
|||
A question re corruption
You can also do it from the File, Open or File, SaVeAs dialog from Word.
Right-click on the file and use Sent To, Drive X. Terry wrote in message ... :I take it that you all see no problem in copying and pasting within : Windows Explorer then (rather than via a Macro in Word). Or, another : thought, can one access Windows Explorer from Word, do it there, and : come back again - all in a Macro? : : : TF wrote: : : The reasons were mainly that floppies are (relatively) VERY slow to read or : write and not the most reliable media. When Word saves (especially in older : versions), it needs to build up the saved file and it does this by creating : a temporary file in the target folder gradually adding or overwriting bits : until it has a complete file. This is then rewritten and saved as the : document file. But the temp file is locked and active until the document is : fully closed and Word/Windows releases the temp file. : : Problems become serious if the file is fairly large or the floppy is : partially filled because the document file and the temp files may have : insufficient room to co-exist on the floppy. To make matters worse, : simultaneous reading and writing to the floppy is happening at the very slow : rate of the floppy drive. : : So all in all, it was hardly surprising that floppies were a disaster with : Word! The best and safest solution for you is to write your macro to save : the file to the main HDD and then COPY or MOVE it to the mem stick. : : Although Word is not so demanding these days, problems still do occur. I : have a colleague who has now twice corrupted large documents using a memory : stick to move between home and work to continue working on a document. : : You now know the risks! : : -- : Terry Farrell - Word MVP : http://word.mvps.org/ : : wrote in message ... : : Quite a lot has been written about avoiding corruption of documents, and : : one piece of advice has been "do not save to A: from Word (though from : : Explorer is okay). I habitually save to a memory stick/flash drive in : : drive E and I would like to automate this with a VBA macro. Does anyone : : have any information on why saving to A: from Word causes corruption, : : and more importantly whether or not saving to E: poses the same danger? : : Alternatively (and OT) is it possible to write a VBA (or other) Macro to : : invoke this procedure from a hot key while in Windows Explorer (where I : : currently do this manually)? : : : : TIA |
#9
|
|||
|
|||
A question re corruption
Sorry Guys, now I'm really confused! Surely it has been said here that
saving to A: or even E: direct from Word is likely to cause corruption. Therefore 'save as' is not right (which is what I used to do). But copying from C: to E: under Windows Explorer is OK away from Word. Then my question was: can we use a macro in Word to get temporarily out of it to Windows Explorer and then do the copy and then return, like System used to get you out of BASIC (shows age g) and let you do things in DOS and then return. Alternatively, can I make some form of macro that will operate from a hot key when in Windows Explorer? BTW, I have got VB5. This would be OK as I spend a lot of time in Explorer... TF wrote: You can also do it from the File, Open or File, SaVeAs dialog from Word. Right-click on the file and use Sent To, Drive X. Terry wrote in message ... :I take it that you all see no problem in copying and pasting within : Windows Explorer then (rather than via a Macro in Word). Or, another : thought, can one access Windows Explorer from Word, do it there, and : come back again - all in a Macro? : : : TF wrote: : : The reasons were mainly that floppies are (relatively) VERY slow to read or : write and not the most reliable media. When Word saves (especially in older : versions), it needs to build up the saved file and it does this by creating : a temporary file in the target folder gradually adding or overwriting bits : until it has a complete file. This is then rewritten and saved as the : document file. But the temp file is locked and active until the document is : fully closed and Word/Windows releases the temp file. : : Problems become serious if the file is fairly large or the floppy is : partially filled because the document file and the temp files may have : insufficient room to co-exist on the floppy. To make matters worse, : simultaneous reading and writing to the floppy is happening at the very slow : rate of the floppy drive. : : So all in all, it was hardly surprising that floppies were a disaster with : Word! The best and safest solution for you is to write your macro to save : the file to the main HDD and then COPY or MOVE it to the mem stick. : : Although Word is not so demanding these days, problems still do occur. I : have a colleague who has now twice corrupted large documents using a memory : stick to move between home and work to continue working on a document. : : You now know the risks! : : -- : Terry Farrell - Word MVP : http://word.mvps.org/ : : wrote in message ... : : Quite a lot has been written about avoiding corruption of documents, and : : one piece of advice has been "do not save to A: from Word (though from : : Explorer is okay). I habitually save to a memory stick/flash drive in : : drive E and I would like to automate this with a VBA macro. Does anyone : : have any information on why saving to A: from Word causes corruption, : : and more importantly whether or not saving to E: poses the same danger? : : Alternatively (and OT) is it possible to write a VBA (or other) Macro to : : invoke this procedure from a hot key while in Windows Explorer (where I : : currently do this manually)? : : : : TIA |
#10
|
|||
|
|||
A question re corruption
If the document is closed, you can right-click on the filename in Word's
File Open dialog and use Send To to send (copy) it to any drive (or any other location). that's on your Send To menu. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ... Sorry Guys, now I'm really confused! Surely it has been said here that saving to A: or even E: direct from Word is likely to cause corruption. Therefore 'save as' is not right (which is what I used to do). But copying from C: to E: under Windows Explorer is OK away from Word. Then my question was: can we use a macro in Word to get temporarily out of it to Windows Explorer and then do the copy and then return, like System used to get you out of BASIC (shows age g) and let you do things in DOS and then return. Alternatively, can I make some form of macro that will operate from a hot key when in Windows Explorer? BTW, I have got VB5. This would be OK as I spend a lot of time in Explorer... TF wrote: You can also do it from the File, Open or File, SaVeAs dialog from Word. Right-click on the file and use Sent To, Drive X. Terry wrote in message ... :I take it that you all see no problem in copying and pasting within : Windows Explorer then (rather than via a Macro in Word). Or, another : thought, can one access Windows Explorer from Word, do it there, and : come back again - all in a Macro? : : : TF wrote: : : The reasons were mainly that floppies are (relatively) VERY slow to read or : write and not the most reliable media. When Word saves (especially in older : versions), it needs to build up the saved file and it does this by creating : a temporary file in the target folder gradually adding or overwriting bits : until it has a complete file. This is then rewritten and saved as the : document file. But the temp file is locked and active until the document is : fully closed and Word/Windows releases the temp file. : : Problems become serious if the file is fairly large or the floppy is : partially filled because the document file and the temp files may have : insufficient room to co-exist on the floppy. To make matters worse, : simultaneous reading and writing to the floppy is happening at the very slow : rate of the floppy drive. : : So all in all, it was hardly surprising that floppies were a disaster with : Word! The best and safest solution for you is to write your macro to save : the file to the main HDD and then COPY or MOVE it to the mem stick. : : Although Word is not so demanding these days, problems still do occur. I : have a colleague who has now twice corrupted large documents using a memory : stick to move between home and work to continue working on a document. : : You now know the risks! : : -- : Terry Farrell - Word MVP : http://word.mvps.org/ : : wrote in message ... : : Quite a lot has been written about avoiding corruption of documents, and : : one piece of advice has been "do not save to A: from Word (though from : : Explorer is okay). I habitually save to a memory stick/flash drive in : : drive E and I would like to automate this with a VBA macro. Does anyone : : have any information on why saving to A: from Word causes corruption, : : and more importantly whether or not saving to E: poses the same danger? : : Alternatively (and OT) is it possible to write a VBA (or other) Macro to : : invoke this procedure from a hot key while in Windows Explorer (where I : : currently do this manually)? : : : : TIA |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
random sort my table | ADAM | Running & Setting Up Queries | 5 | December 30th, 2005 06:59 AM |
Question about reducing number of tables in a database | tlyczko | Database Design | 0 | October 27th, 2005 04:15 PM |
Search my question lost in the long list | Shrikant | General Discussion | 3 | August 26th, 2005 09:32 AM |
How to gray-out a question dialog box | S_Kaplan | General Discussion | 3 | October 26th, 2004 12:11 AM |
database design question | e-mid | Database Design | 9 | June 16th, 2004 09:42 PM |