is there something that i need to reference? how do i use this:
Dim fso As New FileSystemObject
Dim fld As Folder
Dim ts As TextStream
i am getting an error because it does not recognize these objects
is there something that i need to reference? how do i use this:
Dim fso As New FileSystemObject
Dim fld As Folder
Dim ts As TextStream
i am getting an error because it does not recognize these objects
These guys have excellent examples of how tto use the filesystem object http://www.w3schools.com/asp/asp_ref_filesystem.asp
<%
dim fs,fname
set fs=Server.CreateObject("Scripting.FileSystemObject")
set fname=fs.CreateTextFile("c:\test.txt",true)
fname.WriteLine("Hello World!")
fname.Close
set fname=nothing
set fs=nothing
%>
Within Excel you need to set a reference to the VB script run-time library. The relevant file is usually located at \Windows\System32\scrrun.dll