Search results 265

Sorted from new to old.

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

Refresh Table from View

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

2023Jul19

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

Excel user name

Get application user name or change it Originally from

2023Jun14

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

MapPath_SafeComma

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

2023May19

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

Arabic in MySQL

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

2023Apr12

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Range2Block

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

2023Mar6

Filename_Clean

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

2023Jan11

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13

Dropdown button commands

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

2022Oct12

1 2 ...6 ...16 17