Search results 867

Sorted from new to old.

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

ChartMaxY + ChartMinY

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

2018Aug16

Hand.cur

A cursor file type of Hand. used inside VBA to show hand when user hover over ...

2018Aug14

Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

2018Aug12

Page2Setting

Read content of an html online page into setting value in Excel sheet. ...

2018Aug12

Thumbnail on fly

An aspx tool to generate thumbnail from an image, used to make page load faster ...

2018Aug10

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

Pagination call

How to read certain page from SQL table Originally from from http://social. ...

2018Aug10

IsThere1_Remote

Checks if a file is found from a URL, finds a file in a remote server

2018Aug10

IsThere1_Folder

Checks if a folder is found or not, can pass either mapped path or unmapped ...

2018Aug10

RunFromShared

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

2018Aug9

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

2018Aug8

DigitsORLettersOnly

Check if the string has special characters or not, only Letters or digits ...

2018Aug8

1 2 ...42 ...54 55