Search results 120

Sorted from new to old.

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Frm3

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

2023Jul30

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

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

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ANmaSQL_InsertStatement

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

2022Jul3

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

1 2 ...7 8