Search results 46

Sorted from new to old.

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

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

WinImage.dll

An old DLL library enables reading and writing to floppy disks (and/or images) ...

2020Jul18

Detect if Browser supports Flash

Detect if Browser supports Flash or not ( using ShockwaveFlash.ShockwaveFlash) ...

2019Jun2

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

fnGenerateRandomString

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

2019May5

1 2 3