Search results 84

Sorted from new to old.

OpenOffice Calc

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

2019Jan5

SSTree

Tree code, driven by Access DB A code I found somewhere online that I enhanced ...

2019Jan3

Permission Denied error

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

2018Sep26

HTML and URL codes

Always find my self needing to know those quickly to continue working, so ...

2018Sep24

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

2018Aug25

Scrolly

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

2018Aug25

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

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

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

Unzip_7Zip

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

2018Jul14

1 2 ...4 5 6