Search results 171

Sorted from new to old.

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

Old cell value

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

2021Dec30

ServerXMLHTTP stream

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

2021Aug3

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

2021Jun26

Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

2021May31

HTMLTagAttributeValue

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

2021May30

ShapeRange_BG

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

2021Mar27

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

2021Feb24

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

ASP to static HTML

Convert Dynamic ASP files into HTML (once daily) to make them faster when ...

2020Dec24

Save Excel range (or shape) to picture

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

2020Dec21

File2Body

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

2020Dec15

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

1 2 ...5 ...10 11