Search results 127

Sorted from new to old.

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

RemoveCommaBetween2Quotes

Removes comma between the first pair of quotations (RemoveCommaBetween2Quotes)

2018Jul24

ImageRotate_IrfanView

Rotates an image using irfanview (i_view32.exe attached) Rotated image can be ...

2018Jul22

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

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

1 2 ...7 8