Search results 149

Sorted from new to old.

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

Bootstrap Modal variables

Bootstrap link to pass variables to modal content Used to build list of links ...

2018Aug10

Pagination call

How to read certain page from SQL table Originally from from http://social. ...

2018Aug10

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

CreateAnchor

Creates an anchor by passing its arguments (used to be called URL2A), can ...

2018Jul17

myURLDecode

Decode a URL, opposite of Server.URLEncode

2018Jul15

getDaysInMonth

Gets number of days in a certain month

2018Jul15

CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za.exe (found in ...

2018Jul14

CreateZipFolder_7Zip

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

2018Jul14

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

oShellRun1

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

2018Jul6

Num2En

Convert number to English words, convert 450 to 4 hundreds and fifty dollars

2018Jul6

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

2018Jul3

SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

2018Jun30

1 2 ...8 9 10