Search results 108

Sorted from new to old.

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

Subtotal_Indirects

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

2021Nov26

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Navigate_IE

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

2021May31

HTML5 tags cheatsheet

A simple graphic illustrates the new HTML5 tags and differences against old ones

2021Apr16

Bing Desktop wallpapers

Folder where

2021Mar5

Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

2020Dec20

FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

2020Nov11

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

2020Aug21

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

WinImage.dll

An old DLL library enables reading and writing to floppy disks (and/or images) ...

2020Jul18

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

1 2 3 ...6 7