Search results 529

Sorted from new to old.

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

CopyDynamicRangeValue

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

2023Aug10

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

Web.config redirect

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

2023Aug5

ANmaHTMLImgDownload

Downloads image from src of < img html tag after searching for list of ...

2023Aug2

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

Between_HTMLtag

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

2023Jul22

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

ANmaHTMLContent

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

2023Jul1

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

Excel user name

Get application user name or change it Originally from

2023Jun14

1 2 ...11 ...33 34