Search results 175

Sorted from new to old.

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

2018Aug12

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

CellSave_Hyperlink

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

2018Aug9

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9

DegreeC2K

Convert a Celsius temperature to a Kelvin temperature. To convert Fahrenheit ...

2018Jul25

UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25

CreateThumb_IrfanView

Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...

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

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

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

CreateFullTree

Creates full tree if not found

2018Jul9

1 2 ...9 10 11