Search results 63

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

ANmaRead_1stFile

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

Aug11

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

EdgarCIK

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

Feb25

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

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5

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

Filename_Clean

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

2023Jan11

Export2CSV

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

2022May16

DBTables

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

2022Apr28

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

1 2 3 4