learn Archive - Page 13 of 15 - ExcelBaby

Excel Macro: Prevent the Workbook Closing If a Cell is Empty

If you want to to make sure the user has entered all the required fields before saving and closing Excel. This is where this macro comes in.

Workbook.Close method MsgBox function If...Then...Else statement

Excel Macro: Print All Workbooks in a Folder

Opening and printing each workbook in a folder is typically a time consuming manual process. This little macro takes care of that annoyance.

Worksheet.PrintOut method Workbook.Close method Workbooks.Open method Do...Loop statement Dir function

Excel Macro: Auto Save a Workbook Before Closing

This macro ensures that Excel automatically saves before closing the workbook. Get this VBA code now!

MsgBox function Workbook.BeforeClose event Workbook.Save method Select Case statement

Excel Macro: Creating a New Workbook

This Excel macro copies a range of cells from the active sheet and pastes the data into a new workbook. Get this VBA code now!

Application.DisplayAlerts property Workbooks.Add method Worksheet.Paste method Workbook.SaveAs method

Excel Macro: Determine If a Excel Workbook is Already Open

This Excel custom function can be used to determine if a excel workbook is already open or not. Get this VBA code now!

Err.Number property Function statement On Error statement

Excel Macro: Create, Copy, and Delete Folders

We can create, copy and delete specified folders using Folder object or FileSystemObject object in VBA. Get this VBA code now!

Err.Description property Copy method Folder.SubFolders property FileSystemObject.GetFolder method FileSystemObject.DeleteFolder method FileSystemObject.CreateFolder method FileSystemObject.CopyFolder method FileSystemObject.FolderExists method On Error statement

Excel Macro: Determine If a File Exists in a Directory

This Excel macro can determine if a file exists in a specific directory. Get this VBA code now!

FileSystemObject.FileExists method FileSystemObject.FolderExists method Dir function

Excel Macro: List All Files in Folders and Subfolders

This Excel macro can list files (include hidden files) in a specified folder and subfolders, or files with a specific extension. Get it now!

UCase function DateLastAccessed DateLastModified Collection object Collection.Add method Collection.Remove method Size property Attributes property DateCreated Property For Each...Next statement With statement FileSystemObject.GetFolder method Dir function

Excel Macro: Open All Workbooks in a Folder

Opening each workbook in a folder or directory is typically a time consuming manual process. This Excel macro takes care of that annoyance.

Workbook.Close method Application.ActiveWorkbook property Workbook.Name property Workbooks.Open method Do...Loop statement Dir function

Excel Macro: Open a Workbook to a Specific Sheet

Sometimes you need to open your workbook be started on a specific worksheet. This simple macro can help you. Get this VBA code now!

Worksheet.Select method Workbook.Open event

Excel Macro: Opening a Specific Workbook Chosen by the User

This macro opens a friendly dialog box, allowing you to browse for and open the Excel Workbook of your choosing. Get this VBA code now!

Workbooks.Open method Application.GetOpenFilename method

Excel Macro: Unprotect a Worksheet on Workbook Open

Sometimes you need to unprotect the worksheets in a workbook before continuing your work, this macro maybe help you. Get this VBA code now!

Worksheet.Unprotect method Workbook.Open event