Search results 203

Sorted from new to old.

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7

FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Window off-screen

Window not shown while taskbar says it is on. Restore window position in ...

2020Mar17

Online Wordpress password hash generator

An online tool to generate password hash for wordpress, tried it just today ...

2020Feb13

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

1 2 ...6 ...12 13