Code Snippets Visual Basic .NET

Short texts Visual Basic .NET 🧑‍💻 Code snippets Visual Basic .NET ✍️ Reading lists Visual Basic .NET 👀

ページのタイトルを指定してEdgeのタブを閉じるマクロ.vb

Option Explicit Public Sub Sample1() CloseEdgeWindow “Yahoo” ‘ページタイトルに「Yahoo」が含まれるタブをすべて閉じる End Sub Public Sub Sample2() CloseEdgeWindow ‘Microsoft Edgeのウィンドウをすべて閉じる End Sub Private Sub CloseEdgeWindow(Optional ByVal pageTitle As String = “”) Dim uiAuto As CUIAutomation Dim elmRoot As IUIAutomationElement Dim elmEdgeWindow As IUIAutomationElement Dim elmTabBar As IUIAutomationElement Dim elmTabStrip As IUIAutomationElement Dim elmTab As IUIAutomationElement Dim elmTabCloseButton As IUIAutomationElement […]

Pause using Threading.Sleep

/// /// Pause for a short period of time /// /// Seconds, Minutes, Hours as public void Pause(ref TimeSpan delay) { int milliseconds; // DateTime dMark = DateTime.Add(TimeInterval, TimeLength, DateTime.Now); var dMark = DateTime.Now.Add(delay); if (delay.TotalSeconds >= 60 * 60) { // delaying hours or more milliseconds = 30000; // 30 seconds } else if […]

An extensive excel vba documentation for creating large-scale apps without a total mess

# Excel VBA Many times you want to fiddle around with amazing tech like [React](https://facebook.github.io/react/) or [RustLang](https://www.rust-lang.org/) that are pushing the boundaries of what is possible. Back to the real world, there are still cases where an Excel sheet is more appropiate. Especially when companies previously built around it and have existing legacy code. Maybe […]

An extensive excel vba documentation for creating large-scale apps without a total mess

# Excel VBA Many times you want to fiddle around with amazing tech like [React](https://facebook.github.io/react/) or [RustLang](https://www.rust-lang.org/) that are pushing the boundaries of what is possible. Back to the real world, there are still cases where an Excel sheet is more appropiate. Especially when companies previously built around it and have existing legacy code. Maybe […]

An extensive excel vba documentation for creating large-scale apps without a total mess

# Excel VBA Many times you want to fiddle around with amazing tech like [React](https://facebook.github.io/react/) or [RustLang](https://www.rust-lang.org/) that are pushing the boundaries of what is possible. Back to the real world, there are still cases where an Excel sheet is more appropiate. Especially when companies previously built around it and have existing legacy code. Maybe […]