Search results 60

Sorted from new to old.

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

Frm9 - Select workbook (or workbook/worksheet)

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

2019Apr3

SheetAdd_ANmar

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

2019Apr1

Porting Excel/VBA into OpenOffice Calc

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

2019Feb8

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

OpenOffice Calc

OpenOffice programming with Visual Basic Some document I had for my reference.

2019Jan5

Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

2018Sep26

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

CellSave_Hyperlink

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

2018Aug9

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

WorkbookClose_ANmar

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

2018Aug9

WorkbookOpenAsk_ANmar

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

2018Jul17

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

2018Jul14

MP3GetInfo

Returning information on an MP3 file. Returns a type containing information ...

2018Jul11

1 2 3 4