Similar codes

Card image cap
ConcaUFO_RowsfromSheets

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

2020Nov11

ANmarAmdeen
Card image cap
FixENTERS_File

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

2018Jul7

ANmarAmdeen
Card image cap
Porting Excel/VBA into OpenOffice Calc

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

2019Feb8

ANmarAmdeen
Card image cap
SheetAdd_ANmar

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

2019Apr1

ANmarAmdeen
Card image cap
TeeOpen_ProtectTee + TeeOpen_UnprotectTee

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

2019Jun2

ANmarAmdeen
Card image cap
Modal form open Workbook

Do not open workbook from userform after .show

Aug3

ANmarAmdeen
Card image cap
FindFile

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

2018Jul11

ANmarAmdeen
Card image cap
GetTimeZone

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

2018Jun22

ANmarAmdeen
Card image cap
GetUTC

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

2018Jun22

ANmarAmdeen

Recently by developer

See more
Card image cap
Files_FoundHours

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

Tue 7AM

ANmarAmdeen
Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

ANmarAmdeen
Card image cap
ANString_Location

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

Apr23

ANmarAmdeen
Card image cap
SettingSave + SettingRead for NumberFormat

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

Apr19

ANmarAmdeen

Random Codes

See more
Card image cap
ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

ANmarAmdeen
Card image cap
Open Window

Open another window with java script (_blank) Setting up width, height, ...

2021Mar22

ANmarAmdeen
Card image cap
UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

ANmarAmdeen
Card image cap
GetExtension

Gets the extension of file from its filename

2018May12

ANmarAmdeen