Search results 60

Sorted from new to old.
Card image
Porting Excel/VBA into OpenOffice Calc

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

Card image
Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

Card image
RunRemote

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

Card image
OpenOffice Calc

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

Card image
SSTree

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

Card image
Permission Denied error

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

Card image
HTML and URL codes

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

Card image
XLShortcut_EnableDisable

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

Card image
CopyFormat

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

Card image
ApplyValidation_DropDown

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

Card image
CellSave_Hyperlink

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

Card image
FindFile_Word

Finds a file within open documents of current instance

Card image
WorkbookClose_ANmar

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

Card image
WorkbookOpenAsk_ANmar

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

Card image
Unzip_7Zip

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

Card image
MP3GetInfo

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