Advanced Modeling Techniques

Week 10: Files & Folders

Write to and Read from a Text File (Demo File; zillowDF.csv)

PPT: Files & Folders

Dialog Boxes for File Operations (Demo File)

Scripting.FileSystemObject (Demo File)

YouTube Videos
Looping through Multiple Files in a Folder

Make a File Folder

Check if a File/Folder Exists

Readings
Write Statement (Microsoft Documentation)

Input Statement (Microsoft Documentation)

FileSystemObject (Microsoft Documentation)

FileDialog Property (Microsoft Documentation)

Practice Files & Folders on your own with these exercises
Exercise: Solution
Home
Subscribe to: Posts (Atom)

Search This Blog

week

  • Home
  • Week 00: Introduction
  • Week 01: Programming with Flowcharts
  • Week 02: Subroutines & Functions
  • Week 04: Loops
  • Week 05: Do Loops & Ranges
  • Week 06: Debugging & Exam Review
  • Week 08: Arrays
  • Week 09: User Forms
  • Week 10: Files & Folders
  • Week 12: Applications - Portfolio Optimization
  • Week 13: MBA Presentations
  • Week 14: UG Presentations
  • Team Project
  • Excel Resources
  • Access Excel VBA from a Remote Computer (especially for Mac Users)

Report Abuse

Awesome Inc. theme. Powered by Blogger.