Search results 39

Sorted from new to old.

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

StartApp-IfNotStarted

Checks if application is already running, returns 1 or 0 My first function

2024Aug3

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

RunOnTime

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

2022Sep29

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

ANmaSQL_InsertStatement

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

2022Jul3

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

UISetup + UIRestore

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

2022Jan28

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

1 2 3