Search results 71

Sorted from new to old.

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ForegroundColor

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

2023May5

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

GetAmazonPrice

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

2023Apr3

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

2021Oct5

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

1 2 3 4 5