GET UP TO SPEED WITH VSTO

Hello everyone, I'm Lung Pamai, and in this new series, I'll bring you up to speed with VSTO. VSTO has always been one of my favourite technologies. Millions of people use Office Apps daily. With VSTO, you can create applications for them. Follow this new series to know everything you need to begin building solutions that take advantage of the .NET Framework features, in the UI your users are familiar with.

VSTO stands for 'Visual Studio Tools for Office'. As the name suggests, it provides tools in Visual Studio to extend Office applications using the .NET Framework. These applications are also called Office solutions and are available for Office 2003 and above versions and you either use Visual Basic or Visual C# to program and you can visual designers to create custom user interfaces.

It can be frustrating if you're coming from VBA Programming background because most examples or demonstration are done using C#, they are very high level and are not beginners-friendly, so I hope these videos will help you guys get started.

If you haven't please do not forget to subscribe and hit the bell icon for the latest updates and to support my channel. Also if you want me to make more of these videos please do not forget to leave a like and comment as well.

To follow these videos, you'll need MS Office and Visual Studio. Please check the video description for link to download Visual Studio. If you've previously installed it, use the Installer to ensure that the Office/SharePoint development workload is installed.

If you were following the 'Office Add-ins platform' series you probably have it.

I will add more resources as we go further in series. thanks for your support.

Subscribe Now!
New videos every Weekend!

Like what I do? Donate

Did I help you? Did one of my tutorials save you sometime?

You can say thank you by buying me a cup of coffee, I go through a lot of it.

Help keep Greater Good resources free for everyone. Please donate today.

Tutorial Links

Episode 01 - https://youtu.be/KPSuvRSwgh4
Episode 02 - https://youtu.be/JbufItFGU8k
Episode 03 - https://youtu.be/pJJpKc7lRJg
Episode 04 - https://youtu.be/A7q4FSbUVHM
Episode 05 - https://youtu.be/ta1ri-TQBOI

Episode 06 - https://youtu.be/x25j4Ix7Pr4

Episode 07 to 12 - https://www.youtube.com/watch?v=C-F_hLt-goA

Episode 13 - https://www.youtube.com/watch?v=6Mfp2EXmVNI
Episode 14 - https://www.youtube.com/watch?v=8x2yFqC8_Ws

Visual Studio Download

I use Visual Studio Community Version: https://visualstudio.microsoft.com/

Sample Data

https://bit.ly/2VVCDfk

Sample Code

Imports Microsoft.Office.Tools.Ribbon

Public Class Ribbon1
    Private Sub Button3_Click_1(sender As Object, e As RibbonControlEventArgs) Handles Button3.Click

        Dim wb As Excel.Workbook

        Dim sSh As Excel.Worksheet = Globals.ThisWorkbook.Application.Worksheets("Clients")

        Dim sRng As Excel.Range = sSh.Range("A1:K501")


        Dim cltName As String
        cltName = Me.EditBox1.Text

        sSh.Activate()
        sSh.AutoFilterMode = False

        sRng.AutoFilter(Field:=1, Criteria1:=cltName, Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlAnd)
        sRng.SpecialCells(Microsoft.Office.Interop.Excel.XlCellType.xlCellTypeVisible).Copy()


        wb = Globals.ThisWorkbook.Application.Workbooks.Add
        Dim dSh As Excel.Worksheet = wb.Worksheets("Sheet1")

        wb.Activate()
        dSh.Activate()
        dSh.Range("A1").PasteSpecial(Microsoft.Office.Interop.Excel.XlPasteType.xlPasteValuesAndNumberFormats)
        Globals.ThisWorkbook.Application.CutCopyMode = False

        wb.SaveAs("C:\output_clt.xlsx")
        wb.Close()
    End Sub
End Class

Youtube.com/VbaA2z (subscribe for new videos every weekend!)

Search

Visual Studio Tools for Office - Get up to speed with VSTO / .NET (VBA Developers friendly)