<div>
shasunder showed how to do it with early binding. &nbsp;With late binding... 
 
 
 
Dim fso As Object 
Dim ts As Object 
 
Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot;) 
Set ts = fso.CreateTextFile(&quot;c:\folder\subfolder\text.txt&quot;, True) 
'Set ts = fso.OpenTextFile(&quot;c:\folder\subfolder\text.txt&quot;)
</div>

shasunder showed how to do it with early binding.  With late binding...



Dim fso As Object
Dim ts As Object

Set fso = CreateObject("Scripting.FileSystemObject")
Set ts = fso.CreateTextFile("c:\folder\subfolder\text.txt", True)
'Set ts = fso.OpenTextFile("c:\folder\subfolder\text.txt")

<div>
 &nbsp; &nbsp; 
 
I have an error that says Sub or Function not defined 
 
it is pointing on the ExecCmd &nbsp;any idea what's going on? 
 
&nbsp;ExecCmd &quot;\\Hudson\aas\AASProj\GE\DATA\DOWNLOAD\GEDecryptEncrypt\GEDecrypt.bat&quot;
</div>

   

I have an error that says Sub or Function not defined

it is pointing on the ExecCmd  any idea what's going on?

 ExecCmd "\\Hudson\aas\AASProj\GE\DATA\DOWNLOAD\GEDecryptEncrypt\GEDecrypt.bat"

<div>
<div class="content wysiwyg-content">
Hi, 
 
I am having an error if I declare ts as textStream 
 
and &nbsp;Dim fso As New FileSystemObject 
 
do I have to import something in order to user 
textStream and FileSystemObject? 
 
the error says 
 
user-defined type not defied. 
 
Thanks,
</div>
</div>

Hi,

I am having an error if I declare ts as textStream

and  Dim fso As New FileSystemObject

do I have to import something in order to user 
textStream and FileSystemObject?

the error says

user-defined type not defied.

Thanks,

Dim ts As TextStream

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.