Search results 97

Sorted from new to old.

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

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

GetHeaders

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

2022May5

BrowserSetting

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

2022Apr29

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

ServerXMLHTTP stream

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

2021Aug3

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Hiding chart in Excel

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

2020Dec31

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

1 2 ...6 7