Does anyone know a good resource to find a listing of the "Members of the File System"

I am trying to copy a file and do not know how to refer to the object

For example:

Dim fs As Object
Set fs = ?????this is what I don't know????
fs.CopyFile "c:\MyDocuments\*Kronos.txt", "c:\Processed\"

Thanks in advance.
Coby

I usually use something like this:

Dim objFSO As Variant

Set objFSO = CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists(c:\MyDocuments\Kronos.txt") Then
   objFSO.MoveFile "c:\MyDocuments\Kronos.txt", "c:\Processed\"
End If

It looks like you want to move a file, not copy it. If you want to copy it then do this instead of MoveFile:

objFSO.CopyFile "c:\MyDocuments\*Kronos.txt", "c:\Processed\Kronos.txt"

If you are searching for a file and are using a wildcard, what you need to do is take the filename, and then check the Right(sFileName, 10) = "Kronos.txt"

Then do this:

objFSO.MoveFile "c:\MyDocuments\" & sFileName, "c:\Processed\"


Did that help?



mmcdonal

Sorry, that should have been:

objFSO.CopyFile "c:\MyDocuments\Kronos.txt", "c:\Processed\Kronos.txt"

with no wildcard character.

mmcdonal

Yes! I am trying to move a file and this is very helpful.
I will try it. Where I was stuck before was trying to refer to the "MsWindows File System".
I didn't know what to call it. I am familiar with vba.filesystem or application. or access. etc, but not calling to windows.

Thanks.
Coby.

This is VBScript. It works within VBA, of course. So I always use it when I need to work with text files (reading data, moving, searching, etc.) Go to msdn and do a search for VBScript and there are all sorts of reference materials for free.


mmcdonal

That worked exactly how I wanted it to!

I appreciate your help.