DB Functions (By AI)

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

Arabic in MySQL

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

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

MultiTrim

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

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

DropdownButton.zip

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

OpenAnyFile

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

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.