CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

CopyFiles.zip

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Win10 ThisPC Virtual locations

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

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

SettingRead_Ajax + SettingRead_Ajax_IntoObject

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

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.