Search results 60

Sorted from new to old.

Long filename

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

2020Oct11

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Window off-screen

Window not shown while taskbar says it is on. Restore window position in ...

2020Mar17

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

WebBrowser control issue

Issue and fix in webbrowser control

2020Feb3

Parts-File2Page

A classic ASP include file to read txt file of list into a page using bootstrap ...

2019Oct6

Bootstrap Select

Multi-select drop-down in Bootstrap with customization From

2019Sep16

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1

Excel 2010 hyperlink issue fix

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

2019Jun16

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

Listbox height changing issue

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

2018Aug25

IsThere1_Folder

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

2018Aug10

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

1 2 3 4