×

Saving

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 Save As Picture in Excel

VBA Code To Save As Picture in Excel

Not As Easy As You’d Think… One would think that saving something as a picture file (png, jpg, etc…) inside...

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...

Ask If User Wants To Save File Before Executing VBA Macro

Ask If User Wants To Save File Before Executing VBA Macro

What This VBA Code Does In Excel and Microsoft Word you cannot undo a macro once it has run. Sometimes...

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...