• Use the FileSystemObject, Luke! (VB/VBA)

    Home » Forums » AskWoody support » Productivity software by function » Visual Basic for Applications » Use the FileSystemObject, Luke! (VB/VBA)

    Author
    Topic
    #359047

    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. smile

    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 http://msdn.microsoft.com/scripting/.

    Here’s some links about the FileSystemObject

    http://support.microsoft.com/support/kb/ar…s/Q186/1/18.ASP

    http://msdn.microsoft.com/library/devprods…ystemObject.htm

    http://www.devx.com/gethelp/newinquiry.asp?ItemID=25129

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

    May the FileSystemObject be with you.

    Viewing 0 reply threads
    Author
    Replies
    Viewing 0 reply threads
    Reply To: Use the FileSystemObject, Luke! (VB/VBA)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: