Search results 60

Sorted from new to old.

FrmRename

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

2023Jul7

Excel user name

Get application user name or change it Originally from

2023Jun14

ANmaInt

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

2023May2

Filename_Clean

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

2023Jan11

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

1 2 3 4