Search results 152

Sorted from new to old.

Shape_Select_or_CreateThenSelect

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

2022Jul21

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

SQL Related posts

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

2022Jul6

ANmaSQL_UpdateDateStatement

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

2022Jul4

ANmaSQL_InsertStatement

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

2022Jul3

GetHeaders

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

2022May5

New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

2022May3

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

CreateUniqueList

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

2022Apr26

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

2021Oct5

DateStamp-Simple

Simple Date stamp, calendar, day view whatever you call it. was looking for ...

2021Jun27

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

1 2 3 ...9 10