View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default execution speed issue when closing files

Anytime you modify/save files opened from an external location (network
share, usb stick, etc) the processing time will be significantly slower
due to having to write to the external drive location. The write
process invokes permissions checks and related background processing on
the network share that doesn't happen if you just open/close a file
without saving changes, or write back to an external drive plugged into
the local machine.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion