Search results 28

Styles_DeleteNonStandard

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


CopyFormat

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


SheetDelete_ANmar

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


CellSave_Hyperlink

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


WorkbookNew_ANmar

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


WorkbookClose_ANmar

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


CreateThumb_IrfanView

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


WorkbookSaveAsk_ANmar

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


WorkbookOpenAsk_ANmar

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


CreateZipFile_7Zip

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


CreateZipFolder_7Zip

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


FindName

Finds if a name (Range name) is found in a certain workbook or not Workbook is ...