VBA-Excel 329

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

Sorted from new to old.

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

ScanFolder

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

2023Apr7

EmailSend_Outlook

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

2023Apr5

ScrapeURL_ToSheet

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

2023Apr4

GetAmazonPrice

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

2023Apr3

Excel recovered files

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

2023Mar31

Zip_Folder

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

2023Mar29

AskForFolder

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

2023Mar23

ImportCSVs - 1st AI Code

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

2023Mar20

Convert_Dash_to_Zero

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

2023Mar14

Range2Block

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

2023Mar6

Range_Add_or_Subtract

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

2023Feb18

NavigatePost

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

2023Jan14

ANmaVLookup

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

2022Dec23

1 2 ...8 ...20 21