Search results 25

Card image cap
Protecting VBA code

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

Card image cap
ANmaSQL_InsertStatement

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

Card image cap
Subtotal_Indirects

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

Card image cap
merge2Arrays

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

Card image cap
Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

Card image cap
Navigate_IE

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

Card image cap
Card image cap
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

Card image cap
JSON-VBA

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

JSON-VBA.zip

Card image cap
ANmaRedirect_Plus1

Function to log the redirects that happen into website It is merely used with ...

Card image cap
ANmaRedirect

Simple redirecting function, used to direct users from one domain into another ...

ANmaRedirect_v3.zip

Card image cap
Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic