Search results 58

  2. Search results
  3. update table
Sorted from new to old.
Card image
ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13
Card image
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19
Card image
DB Functions (By AI)

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

2023Apr23
Card image
Arabic in MySQL

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

2023Apr12
Card image
ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4
Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25
Card image
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16
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
DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31
Card image
DBTables

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

2022Apr28
Card image
Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23
Card image
AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23
Card image
UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28
Card image
ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12
Card image
Android Apps and SD memory

List of apps that can be moved to SD Card in Android OS (Tablet).

2020Aug18
1234