Search results 257

  2. Search results
  3. Name
Sorted from new to old.
Card image
Excel recovered files

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

2023Mar31
Card image
Filename_Clean

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

2023Jan11
Card image
File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27
Card image
LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31
Card image
ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25
Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22
Card image
SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18
Card image
Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21
Card image
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19
Card image
Export2CSV

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

2022May16
Card image
GetHeaders

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

2022May5
Card image
DBTables

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

2022Apr28
Card image
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26
Card image
Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25
Card image
Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23
Card image
CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22
12...6...1617