<div>
OK, I'm nearly there, I have created the text file but the part that checks if it exits crashes on line 6 with &quot;Error number 424 Object required: 'fso'<br />
<br />

<pre><code id="code-20-38408926-1">Dim SavFil 
Dim fso, MyFile
SavFil = &quot;C:\Temp\&quot; &amp; PurchaseOrder &amp; &quot;.txt&quot;
msgbox SavFil

If fso.FileExists(SavFil) Then
   msgbox SavFil &amp; &quot; Already Created&quot;
exit sub
End If

'Create file to flag order

   Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot;)
   Set MyFile = fso.CreateTextFile(SavFil, True)
   MyFile.WriteLine(&quot;This is a test.&quot;)
   MyFile.Close</code></pre>
</div>


OK, I'm nearly there, I have created the text file but the part that checks if it exits crashes on line 6 with "Error number 424 Object required: 'fso'



Dim SavFil 
Dim fso, MyFile
SavFil = "C:\Temp\" & PurchaseOrder & ".txt"
msgbox SavFil

If fso.FileExists(SavFil) Then
   msgbox SavFil & " Already Created"
exit sub
End If

'Create file to flag order

   Set fso = CreateObject("Scripting.FileSystemObject")
   Set MyFile = fso.CreateTextFile(SavFil, True)
   MyFile.WriteLine("This is a test.")
   MyFile.Close

<div>
Needed to move &nbsp;Set fso = CreateObject(&quot;Scripting.Fi<wbr />leSystemOb<wbr />ject&quot;) further up in my code!!
</div>


Needed to move  Set fso = CreateObject("Scripting.FileSystemObject") further up in my code!!

<div>
<div class="content wysiwyg-content">
Our Accounts package has some basic vb scripting functionality. <br />
<br />
I have created a function that works when a purchase receipt is posted, it emails users if a parameter is true.<br />
<br />
I only want to send one message per order so I thought I would create a text file in C:\Temp.<br />
e.g 'Ordernumber.txt'. On subsequent receipts I can check if the file exists to prevent duplicate emails being sent.<br />
<br />
Can anyone help with the syntax?
</div>
</div>


Our Accounts package has some basic vb scripting functionality. 

I have created a function that works when a purchase receipt is posted, it emails users if a parameter is true.

I only want to send one message per order so I thought I would create a text file in C:\Temp.
e.g 'Ordernumber.txt'. On subsequent receipts I can check if the file exists to prevent duplicate emails being sent.

Can anyone help with the syntax?

Create text file vbs

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.