<div>
I've used this code snipet before to determine if a file is in use. &nbsp;I'm just going to change the &lt;&gt;&nbsp;70 to &lt;&gt;&nbsp;0, as this should be more robust. &nbsp;<br />
<br />
I'll repost if this doesn't fix it next week.
</div>


I've used this code snipet before to determine if a file is in use.  I'm just going to change the <> 70 to <> 0, as this should be more robust.  

I'll repost if this doesn't fix it next week.

<div>
Your right I forgot my <br />
<br />
Const ForReading = 1, ForWriting = 2, ForAppending = 8 <br />
<br />
row!<br />
<br />
Thanks!
</div>


Your right I forgot my

Const ForReading = 1, ForWriting = 2, ForAppending = 8

row!

Thanks!

<div>
Great, glad that helped!<br />
<br />
~bp
</div>


<div>
<div class="content wysiwyg-content">
Can anyone help me understand why this code isn't waiting for files to be released before trying to rename them?<br />
<br />

<pre><code id="code-10-27868959-1">For each objfile In files

'Test Code begins here

	on error resume next
	do
		Err.Clear
		Set fLog = objfso.OpenTextFile(objfile, ForAppending, false) 
	loop until Err.Number &lt;&gt; 70		
	on error goto 0

'End Test Code

	if right(objfso.getfilename(objfile),3) = &quot;prn&quot; then 
		objFSO.MoveFile objfile , folder.path &amp; &quot;\&quot; &amp; left(objfso.getfilename(objfile),len(objfso.getfilename(objfile))-3) &amp; &quot;pdf&quot;
	end if
Next</code></pre>
</div>
</div>


Can anyone help me understand why this code isn't waiting for files to be released before trying to rename them?

(CODE)

File in use VBS scripting question

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

Scripting Languages

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.