Search results 105

Sorted from new to old.

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Zoomed iframe

Show iframe zoomed or in scale Thanks to

2023Aug4

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

DB Functions (By AI)

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

2023Apr23

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

1 2 ...6 7