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

FilesCount_Swift

Count how many files in a folder, with no loop, faster if you just need all ...

2019Feb2

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

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

Programming Languages

A nice illustration on different types of languages (the most famous ones only) ...

2018Aug31

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