Search results 59

Sorted from new to old.

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

Jun18

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

MatchIF5

Searching for rows having 5 values in 5 columns Like

2024May6

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

2024Jan12

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

SqlExec

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

2023Sep3

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

ReadBinaryBuffer

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

2023Apr30

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

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

1 2 3 4