Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

Frm9.zip

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

OpenOffice Macros

A pdf book, for macros in OpenOffice.org

Run macro

Runs a macro from another workbook (Workbook has to be open).

SheetName

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

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 ...