Search results 172

Sorted from new to old.

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

2024Jan18

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

2024Jan16

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

HTMLPaddingMargin_v2

Finds the padding or margin from a style statement for an HTML tag. Passing ...

2024Jan5

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

2023Aug5

Frm3

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

2023Jul30

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

ForegroundColor

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

2023May5

1 2 ...4 ...10 11