Search results 60

Sorted from new to old.

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

ShapeName clicked

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

2022Feb4

CSVs2Sheets

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

2021Oct5

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

ConcaUFO_RowsfromSheets

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

2020Nov11

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

WebBrowser control issue

Issue and fix in webbrowser control

2020Feb3

1 2 3 4