> Insert headers and footers using VBA in Microsoft Excel 2010 Insert headers and footers using VBA in Microsoft Excel 2010 If you want to insert certain information in the header / footer of the worksheet like the file name / file path or the current date or page number, you can do so using the below code. 2) More important, how do I sum between any two perhaps widely spaced sheets in this workbook using VBA? Let’s say that I wanted cell B17 on my summary sheet to represent the sum contained with cell C19 from sheet #7 through sheet #37. How would one do this? Thank you very much! Mavericks 10.9.2. Excel for Mac 2011, version 14.3.9 (131030) VBA DIR Function – How to Use in Excel DIR is a very special function in VBA, its job is to return a string representing the name of a file, directory, or an archive that matches a specified pattern. How to read an Excel file using C# The following program illustrates how to open an existing Excel spreadsheet in C# using .NET Framework COM interop capability. Also you can see how to find Named Ranges in Excel and get the range of occupied cells (Used area) in excel sheet. Note: The Dir function supports the use of multiple character (*) and single character (?) wildcards to search for all different type of Excel files. 4. The variable fileName now holds the name of the first Excel file found in the directory. Add a Do While Loop.