Search results 117

Sorted from new to old.

GenerateRandom

Generates a random string, returns string passed, then full date, then 8-chars ...

2018Sep12

SQL Join

Different types of join in SQL. A good illustration image i found during my ...

2018Aug31

ANmaTimeline

Creates HTML timeline dynamically, using Bootstrap 4.0 and FontAwesome 5, in a ...

2018Aug26

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

2018Aug25

GetAttr

Reads attributes of a file using FSO. Return will be a string of RHSA ...

2018Aug12

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

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

1 2 ...6 7 8