Search results 97

Sorted from new to old.
Card image
Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

Card image
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

Card image
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

Card image
IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

Card image
FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

Card image
FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

Card image
GetTempFileName

Returns temp file name using FSO

Card image
DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

Card image
CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

Card image
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

Card image
DeleteTree

Deletes tree of files

Card image
ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

Card image
File_MostRecent

Getting most recent file in a folder

Card image
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

Card image
DeleteAllShapes

Delete all shapes in a sheet

Card image
CopyText2Clipboard

Copies text to clipboard using MSForms