Random codes

Similar codes

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

ANmarAmdeen

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

ANmarAmdeen

Porting Excel/VBA into OpenOffice Calc

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

2019Feb8

ANmarAmdeen

SheetAdd_ANmar

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

2019Apr1

ANmarAmdeen

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

ANmarAmdeen

Modal form open Workbook

Do not open workbook from userform after .show

Aug3

ANmarAmdeen

FindFile

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

2018Jul11

ANmarAmdeen

GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

2018Jun22

ANmarAmdeen

GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...

2018Jun22

ANmarAmdeen

Recently by developer

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Tue 8AM

ANmarAmdeen

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

ANmarAmdeen

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

ANmarAmdeen

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

ANmarAmdeen

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

ANmarAmdeen

CutString9

Cuts from CutFrom starting from any of items found from ...

Jan7

ANmarAmdeen

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

ANmarAmdeen

Login screen background

2019Jan17

ANmarAmdeen