Search results 59

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

Sep21

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

Aug11

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Feb25

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Feb8

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

List_of_Names + DeleteNames

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

2023Jul9

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

Excel user name

Get application user name or change it Originally from

2023Jun14

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

DB Functions (By AI)

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

2023Apr23

WordPress - Excel functions (AI)

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

2023Apr22

Arabic in MySQL

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

2023Apr12

Filename_Clean

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

2023Jan11

1 2 3 4