Browse codes

Search results 107

Forces Excel to not convert numbers during moving them across sheets, or ...

May23

MapPath version expecting comma in filename or folder. Just because we might ...

May19

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

Apr3

Returns cleaned file name of invalid characters. Needs to be modified if used ...

Jan11

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

2022Dec3

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

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

2022Jul4

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

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

2022Apr28

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22