Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Sheets to PDF pages

Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...

Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

XLThumbview.zip

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...