Search results 110

Sorted from new to old.

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

USStandardToMetric

Converts US Standard Measure into a Metric Measure. Arguments: ...

2018Jul15

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

2018Jul14

CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...

2018Jul14

CreateFullTree

Creates full tree if not found

2018Jul9

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

2018Jul7

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6

[TAB] inside textarea

Allow textarea's to accept TAB key (ASCII code 63) Could use some enhancements, ...

2018Jul6

GetPapa

Gets folder name of a page using FSO

2018Jun24

ASCII_Read + ASCII_Save

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

2018Jun21

ScreenRes

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

2018Jun17

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

1 2 ...6 7