Search results 35

Sorted from new to old.

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

VBA vs ASP Classic

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

2019Jun2

DirTree.xlsb

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

2019May20

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

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

XLShortcut_EnableDisable

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

2018Aug16

ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

2018Jul26

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

1 2 3