VBA-Excel 326

Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
Card image
ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

Card image
EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

Card image
ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

Card image
GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

Card image
Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

Card image
Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

Card image
AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

Card image
ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

Card image
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

Card image
NavigatePost

Reads content of webpage with optional post data two main differences from

Card image
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

Card image
Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

Card image
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image
Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...