MyDev

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

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

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

2023Apr22

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

2023Apr20

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

2023Apr14

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

2023Apr7

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

2023Apr5

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

2023Apr4