Search results 222

Sorted from new to old.

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

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

Protecting VBA code

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

2022Jul6

ASPUsers

Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...

2022May4

New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

2022May3

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

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

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

1 2 ...5 ...13 14