Search results 57

  2. Search results
  3. .sql
Sorted from new to old.
Card image
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6
Card image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4
Card image
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3
Card image
DBTables

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

2022Apr28
Card image
File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15
Card image
Part of cells in Excel

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

2020Oct13
Card image
ANStrSort2

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

2020Sep24
Card image
Online JSON Formatter

Online JSON Formatter, helpful when you suck at json, found it during my search ...

2020Aug26
Card image
IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1
Card image
NextID_Reset

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

2020Mar31
Card image
DB_Connect

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

2020Mar20
Card image
Capitalize in JS

Convert text to all capital letters

2020Feb16
Card image
Reset ID Column

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

2020Feb9
Card image
Most recent in Oracle DB

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

2020Feb7
Card image
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3
Card image
Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3
1234