MM0003 - 16/12/19 - Working With Another File In VBA

Perhaps you've created some macros that do cool stuff within a file.  But, many time-consuming tasks in Excel involve multiple files, and opening / closing them repeatedly causes frustration.  Let's explore how to do it at the 'click of a button' using Excel VBA

Topics

  •  | VBA To Open Another File
  •  | Variables - String Variable Example
  •  | Work With Multiple Files - File Setup
  •  | Workbook.Path Property
  •  | Discussion: Dataset Size Management
  •  | With … End With
  •  | .End(xldown)
  •  | Application.WorksheetFunction.COUNTIF
  •  | COUNTIF
  •  | How To Do Testing
  •  | Application.WorksheetFunction.MATCH
  •  | MATCH
  •  | Inserting Symbols
  •  | Message Box - Dynamic
  •  | VBA Can Change Your Life!
  •  | IF Statement - IF - ELSE - END IF
1 Lesson