Dir function Archives - ExcelBaby

Learn

Excel Macro: Bulk Insert Pictures in Cells and Resize Them

Think you have a price list to send to your customers, you need to insert multiple product pictures in Excel, of course […]

ImageMso Office RibbonX Editor IRibbonUI.ActivateTab method LineFormat.Visible property FillFormat.UserPicture method Shapes.AddShape method IsEmpty function Shape.Name property Application.ScreenUpdating property Workbook.Path property For Each...Next statement With statement If...Then...Else statement Dir function

Learn

Excel Macro: Search on Google

If you want to use VBA to open Google Chrome and search keywords on Google, the following Macro do this. Search on […]

Shell function Shell.ShellExecute method REPLACE function InputBox function MsgBox function If...Then...Else statement Call statement Dir function

Learn

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

Learn

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

Learn

Excel Macro: Rename a File or Folder

You can rename and move a specified file or folder using the built-in Name statement in VBA. Download this Excel macro now!

Name statement On Error statement Dir function

Learn

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

Docs

Dir function

Returns a String representing the name of a file, directory, or folder that matches a specified pattern or file attribute, or the […]

Learn

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