Search results 60

Sorted from new to old.

Open different Filestypes

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

2019Jan9

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

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

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

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

1 2 3 4