• Home
  • VBA Tutorial
  • VBA Cheat Sheet
  • Excel SQL Add-In
  • VBA Time Saver
  • VBA Web Scraping Kit
  • Excel LOOKUP Wizard
  • Merch

Analyst Cave

Simply the best place to learn Excel and Analytics

  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video
  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video

Home » VBA Function – Reference of VBA Functions » VBA File Functions

VBA File Functions

Below listed are VBA functions supporting Files / Directories:

VBA ChDir function
VBA ChDrive function
VBA Dir function
VBA FileCopy function
VBA FileDateTime function
VBA FileLen function
VBA GetAttr function
VBA Kill function
VBA MkDir function
VBA Name Statement
VBA SetAttr function

VBA File Functions

Related useful links

  • VBA File Functions
  • VBA Reading Files
  • VBA Writing Files
  • Traversing Directories
  • VBA Working with XML files
  • VBA Downloading files
  • VBA Versioning files
  • VBA Merging CSV or TXT files

Download VBA Time Saver

VBA Time Saver Kit

Ready VBA Code snippets for Arrays, Strings, File Dialogs, Read/Write Files, Timers, Progress Bar

Download LOOKUP Wizard

Excel Lookup Wizard Book1

Lookup data from external Excel files and worksheets with the Excel LOOKUP Wizard AddIn!

Articles