Search results 101

Sorted from new to old.

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

ContainerHTMLTag_Index

Returns location of the tag that enclosing the location provided inside HTML ...

2023Oct22

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

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

1 2 ...6 7