Search results 198

Sorted from new to old.

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

Shape_Select_or_CreateThenSelect

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

2022Jul21

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

GetHeaders

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

2022May5

DBTables

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

2022Apr28

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

tag_add

Add to textbox from listbox (select option) ensure its uniqueness

2021Aug24

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

Modify volume using nircmd

Batch file to lower volume of computer system (using nircmd.exe).

2021Jan1

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

1 2 ...5 ...12 13