Browse codes

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

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

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

May11

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

May5

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

Apr30

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

Apr28

2 functions to sort 5 Arrays or 7 Arrays respectively.

Apr23

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

Apr23

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

Apr22

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

Apr20

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

Apr14

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

Apr7

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

Apr5