Search results 55

Sorted from new to old.

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

2018Aug16

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

2018Jul29

RemoveHTMLTags

Remove HTML tags from a string, note, this won't handle html encoding.

2018Jul15

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

2018Jul14

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

[TAB] inside textarea

Allow textarea's to accept TAB key (ASCII code 63) Could use some enhancements, ...

2018Jul6

Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

2018Jul3

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

Hex2Dec

Converts hexadecimal strings into decimals

2018Jun20

WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16

1 2 3 4