Search results 240

Sorted from new to old.

Refresh Table from View

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

2023Jul19

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

DB Functions (By AI)

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

2023Apr23

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

1 2 ...5 ...14 15