I need a way to monitor a file in a folder (created by an external application, such as Word or Acrobat), and verify that the process of writing to the file has completed (in Windows 2000 or XP). I.e., that the file is finished, and can be opened by Excel. It's easy to verify that the file exists, and what it's file length is, but the file length continues to increase as the file is written to (especially for a large file). Anyone know of a way in VBA to verify that the file is complete I assume that Windows sets some kind of bit in the file to indicate completion. Thanks...
Verifying completion of a file's creation from VBA
Hot Topic
- Switch graphic on/off in Excel
- Scripting
- Control Break Trap will not work whilst Userform is displayed
- Search string
- what OS are included in MSDN OS subscription?
- Outputting to a Listbox
- what OS are included in MSDN OS subscription?
- Power-on 1, Start 2, Keep 3
- Help to create a new table using VBA codes
- Updating text in a text box on an Excel Graph
Verifying completion of a file's creation from VBA
MariamCR