MyDevLib

Search results 59

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

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

2023Jul19

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

2023Apr23

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

2023Apr12

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

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

2022Sep25

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

Exports table into CSV from ASP Classic function.

2022May31

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28