VBA-Excel 380

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

Sorted from new to old.

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

2023Aug2

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

Excel user name

Get application user name or change it Originally from

2023Jun14

SubZero

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

2023May23

Range22DimArray

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

2023May11

ForegroundColor

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

2023May5

ReadBinaryBuffer

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

2023Apr30

1 2 ...10 ...23 24