Search results 31

Sorted from new to old.

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

2024Oct26

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

fNMRPrgs, Full-form progress bar (frm77)

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

2021Oct5

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

Modify volume using nircmd

Batch file to lower volume of computer system (using nircmd.exe).

2021Jan1

Register OCX in 64 and 32 bit

Copy and register ocx using cmd (DOS batch) in Windows 32bit and 64bit.

2020Feb9

1 2