Search results 70

Sorted from new to old.

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

Dynamic iframe height

Adjust iframe height to its content after loading page Needed this trick in ...

2023Apr29

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

LastRow_Remove

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

2022Aug16

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

UISetup + UIRestore

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

2022Jan28

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

2021Feb24

SumOf_3Filters

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

2021Jan29

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

Windows 10 video files and OneDrive

Fixing generating videos thumbnail in Windows 10 Download app from

2020Oct31

Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...

2020Jul22

Window off-screen

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

2020Mar17

1 2 3 4 5