Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Use the FileSystemObject, Luke! (VB/VBA)

    How can I tell if a file/folder/drive exits?
    How can I get a list of all files in a folder?
    How do I delete a file/folder?
    Create a text file?
    Create a folder?
    Copy a file/folder?
    How about doing some of these things recursively?

    Use the FileSystemObject. Let go. Feel the FileSystemObject flow through you. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    It's a Swiss army knife of basic file manipulation. VB has all these different commands to manipulate files and folders, but the FileSystemObject is your one-stop shop for file/folder manipulation.

    If your user's PC has Win98 or newer, or IE5 or newer, or Office 2000 or newer, then it probably has the scripting runtime already, scrrun.dll. If not, you can get it at <A target="_blank" HREF=http://msdn.microsoft.com/scripting/>http://msdn.microsoft.com/scripting/</A>.

    Here's some links about the FileSystemObject

    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q186/1/18.ASP>http://support.microsoft.com/support/kb/ar...s/Q186/1/18.ASP</A>

    <A target="_blank" HREF=http://msdn.microsoft.com/library/devprods/vs6/vbasic/vbenlr98/vaobjFileSystemObject.htm>http://msdn.microsoft.com/library/devprods...ystemObject.htm</A>

    <A target="_blank" HREF=http://www.devx.com/gethelp/newinquiry.asp?ItemID=25129>http://www.devx.com/gethelp/newinquiry.asp?ItemID=25129</A>

    Also the book VB/VBA In A Nutshell by Paul Lomax covers the FileSystemObject.

    May the <font color=6495ed>FileSystemObject</font color=6495ed> be with you.

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Use the FileSystemObject, Luke! (VB/VBA)

    <img src=/S/yep.gif border=0 alt=yep width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •