Search results 60

Sorted from new to old.
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
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 ...

Card image
FindFile

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

Card image
Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...