×

VBA Files

Prevent SaveAs Prompt When Overriding File With VBA

Prevent SaveAs Prompt When Overriding File With VBA

What This VBA Code Does You may find yourself needing to override a current Excel file with changes using VBA...

VBA Code To Select A Folder Path

VBA Code To Select A Folder Path

What This VBA Code Does This VBA code will show you how to allow your user to select a folder...

VBA Code To Validate A File Path

VBA Code To Validate A File Path

What This VBA Code Does This VBA function will accept a file path text string and confirm if the file...

VBA Code To Find And Replace Words Within Specific File Names In A Folder

VBA Code To Find And Replace Words Within Specific File Names In A Folder

What This VBA Code Does I often have a routine of copying files from one month to another. The only...

VBA Macro Code To Create Monthly Folders Inside A Parent Folder

VBA Macro Code To Create Monthly Folders Inside A Parent Folder

What This VBA Code Does I often find myself needing to set up monthly folders for routine reports. Instead of...

VBA To Quickly Save As PDF Document From Selected Excel Worksheets

VBA To Quickly Save As PDF Document From Selected Excel Worksheets

What This VBA Macro Code Does The business world has increasingly become more reliant on mobile computing with devices such as...

The VBA Guide To Interacting With Text (.Txt) Files

The VBA Guide To Interacting With Text (.Txt) Files

Automating Text Files With VBA Useful? Text files can be a very fast and simple way to read and store...

The VBA Guide To Sending Excel Attachments Through Outlook

The VBA Guide To Sending Excel Attachments Through Outlook

Quickly Emailing Your Spreadsheets I absolutely love using the Email As Attachment functionality provided by Excel. It's great for quickly...

VBA Code To Save As A New Version If File Already Exists

VBA Code To Save As A New Version If File Already Exists

Version Control Keeping track of different versions of a file has always been a pain for me.  I am grateful...

Loop Through All Currently Open Workbooks And Modify Them

Loop Through All Currently Open Workbooks And Modify Them

What This VBA Code Does This bit of VBA code shows you how to loop through all currently open Excel...

Loop Through All Worksheets In All Currently Open Workbooks

Loop Through All Worksheets In All Currently Open Workbooks

What This VBA Code Does This VBA macro code will cycle through each worksheet in every currently open Excel workbook...

Loop Through All Excel Files In A Given Folder

Loop Through All Excel Files In A Given Folder

What This VBA Code Does This VBA macro will let you select a folder path and loop through each of...

Retrieving The File Name & Extension From A File Path String

Retrieving The File Name & Extension From A File Path String

What This VBA Code Does This macro will show you how to manipulate a file path in order to extract...

Loop Through All Sheets and Worksheets in Excel File With VBA

Loop Through All Sheets and Worksheets in Excel File With VBA

What This VBA Code Does Need to do a task on every sheet or worksheet in your workbook?  Use one...

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

X