Search results 60

Sorted from new to old.

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

Save to, Read from, Delete registry key

Save into registry, read from registry or delete a key. Accessible to only ...

2019Jun15

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5

OpenOffice Macros

A pdf book, for macros in OpenOffice.org

2019Feb3

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

RoundMinutes

Rounds time into nearest quarter up or down, half up or down based on argument ...

2019Jan9

Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

2018Sep26

Posts Per Year

Create summary list If you have SQL table named Table_Name, with DateAdded ...

2018Sep22

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

2018Aug25

SetAttr

Sets an attribute to file or folder Needs to have variables defined as you see ...

2018Aug16

XLShortcut_EnableDisable

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

2018Aug16

Styles_DeleteNonStandard

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

2018Aug12

Bootstrap Modal variables

Bootstrap link to pass variables to modal content Used to build list of links ...

2018Aug10

1 2 3 4