Random codes

Codes Required

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

ANmarAmdeen

FindFile

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

2018Jul11

ANmarAmdeen

Similar codes

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

ANmarAmdeen

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

ANmarAmdeen

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

ANmarAmdeen

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

ANmarAmdeen

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

ANmarAmdeen

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

ANmarAmdeen

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

Aug9

ANmarAmdeen

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

ANmarAmdeen

Run macro

Runs a macro from another workbook (Workbook has to be open).

2019Jan9

ANmarAmdeen

Recently by developer

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

Thu 3PM

ANmarAmdeen

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ANmarAmdeen

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

ANmarAmdeen

Counters

Finally, a neat simple js counter This one allows me to have negative counting, ...

2020Feb27

ANmarAmdeen

Bootstrap full calendar

Full, simple and powerful, with AJAX, and template systems From

2019Sep16

ANmarAmdeen

ViewSource

Display content of ASP file (any file for that matters)

2018Jul11

ANmarAmdeen