VBA-Excel 154 Visual basic for applications that works only in Microsoft Excel, aka macros

Card image cap
FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

Card image cap
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

Card image cap
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

Card image cap
IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

Card image cap
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

Card image cap
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

Card image cap
Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

Card image cap
DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

Card image cap
Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

Card image cap
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

Card image cap
ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

Card image cap
Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...