Search results 125

  2. Search results
  3. base
Card image cap
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13
Card image cap
Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20
Card image cap
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3
Card image cap
WorkbookSave_ANmar

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

2023Aug9
Card image cap
Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1
Card image cap
Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25
Card image cap
Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20
Card image cap
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19
Card image cap
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10
Card image cap
DB connection driver

What is the Driver part in ConnectionString

2023Jun2
Card image cap
ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5
Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23