@manhng

Welcome to my blog!

VBA & Outlook

June 19, 2020 10:40

VBA & Outlook (edit)

Office developer documentation

https://developer.microsoft.com/en-us/office/docs

Outlook add-ins documentation

https://docs.microsoft.com/en-us/office/dev/add-ins/outlook/

Program VSTO Add-ins

https://docs.microsoft.com/en-us/visualstudio/vsto/programming-vsto-add-ins?view=vs-2017

private void ThisAddIn_Startup(object sender, System.EventArgs e) { ... }

VSTO Add-ins

https://docs.microsoft.com/en-us/visualstudio/vsto/walkthrough-creating-your-first-vsto-add-in-for-outlook?view=vs-2017

private void ThisAddIn_Startup(object sender, System.EventArgs e) { ... }

VSTO Add-ins for Office

https://docs.microsoft.com/en-us/visualstudio/vsto/create-vsto-add-ins-for-office-by-using-visual-studio?view=vs-2017

Outlook Object Model

https://docs.microsoft.com/en-us/visualstudio/vsto/outlook-object-model-overview?view=vs-2017

VBA

https://www.thoughtco.com/timer-in-office-vba-macros-3424056

Outlook

Launching Outlook at startup (in a smarter way)

https://www.msoutlook.info/question/442

10 tips for speeding up Outlook

https://www.techrepublic.com/blog/10-things/10-tips-for-speeding-up-outlook/

Top 10 annoyances and how to fix them

Annoyances: phiền toái

Annoyance No. 1: Outlook is too darn slow. How can I speed it up?

https://www.computerworld.com/article/2530153/hate-microsoft-outlook-top-10-annoyances-and-how-to-fix-them.html

Annoyance No. 2: Outlook's attachments make it massively bloated.

https://www.computerworld.com/article/2530153/hate-microsoft-outlook-top-10-annoyances-and-how-to-fix-them.html?page=2

Annoyance No. 3: Why can't I find where my $#%^(@"* Outlook data is stored?

Annoyance No. 8: Why can't I synchronize Outlook on multiple PCs?

https://www.computerworld.com/article/2530153/hate-microsoft-outlook-top-10-annoyances-and-how-to-fix-them.html?page=6

Annoyance No. 10: Why won't Outlook work seamlessly with Gmail?

https://www.computerworld.com/article/2530153/hate-microsoft-outlook-top-10-annoyances-and-how-to-fix-them.html?page=7

Tips & Tricks for Outlook

https://www.outlook-apps.com/outlook-tips/

Tutorials 

https://www.outlook-apps.com/tutorials/

https://www.howto-outlook.com/

Launching Outlook at startup (in a smarter way)

https://www.msoutlook.info/question/442

Outlook 2010

https://www.wikihow.com/Configure-Outlook-2010
https://www.wikihow.com/Access-Gmail-in-Outlook-2010
https://www.howtogeek.com/353584/how-to-use-gmail-with-microsoft-office/

Folder & Path

https://www.ryadel.com/en/microsoft-office-default-installation-folders-versions/

Outlook 2010:
C:\Program Files\Microsoft Office\Office14\
C:\Program Files (x86)\Microsoft Office\Office14\

Outlook 2013:
C:\Program Files\Microsoft Office\Office15\
C:\Program Files (x86)\Microsoft Office\Office15\

C:\Users\nvmanh\AppData\Roaming\Microsoft\Outlook\

C:\Users\nvmanh\Documents\Outlook Files\

Outlook Free Lancer

https://www.freelancer.co.za/projects/c-sharp-programming/complete-outlook-addin/

Code Samples

https://docs.microsoft.com/en-us/samples/browse/?redirectedfrom=MSDN-samples 

Office Add-ins Patterns and Practices (PnP)

Office 365 solution guidance with practices and patterns for Office Add-in development

https://github.com/OfficeDev/PnP-OfficeAddins/

Samples

https://docs.microsoft.com/en-us/azure/active-directory/develop/sample-v2-code

https://github.com/Azure-Samples/

Calling an ASP.NET Core Web API from a WPF application using Azure AD V2

https://docs.microsoft.com/en-us/samples/azure-samples/active-directory-dotnet-webapp-webapi-openidconnect-aspnetcore/calling-a-web-api-in-an-aspnet-core-web-application-using-azure-ad/

https://docs.microsoft.com/en-us/samples/azure-samples/active-directory-dotnet-native-aspnetcore-v2/calling-an-aspnet-core-web-api-from-a-wpf-application-using-azure-ad-v2/

https://docs.microsoft.com/en-us/samples/azure-samples/active-directory-dotnetcore-console-up-v2/aad-username-password-graph/

https://github.com/Azure-Samples/active-directory-dotnet-webapp-openidconnect-aspnetcore

Web API calling a downstream API on behalf of the user using the Microsoft identity platform (formerly named Azure AD) v2.0 enpoint

https://github.com/Azure-Samples/ms-identity-aspnet-webapi-onbehalfof

Calling a ASP.NET Core Web API from a WPF application using Azure AD v2.0

https://github.com/Azure-Samples/active-directory-dotnet-native-aspnetcore-v2/

Office Add-ins platform overview

See also

https://docs.microsoft.com/en-us/office/dev/add-ins/overview/office-add-ins

Excel VBA delete row if contains certain strings

June 9, 2020 09:36

Excel VBA delete row if contains certain strings (edit)

https://excel.officetuts.net/en/vba/delete-a-row-if-cell-contains

https://analysistabs.com/vba/delete-row-if-cell-contains-string-excel-macro-example-code/

https://stackoverflow.com/questions/26683163/excel-vba-delete-row-if-contains-certain-strings-or-has-a-delete-flag-set

What is VBA?

The acronym VBA stands for Visual Basic for Applications. It is an integration of the Visual Basic with Microsoft Office applications (MS Excel, MS PowerPoint, MS Access, MS Word and MS Outlook). By running VBA within the Microsoft Office applications, you can automate repetitive tasks.

Getting Started With VBA

https://www.guru99.com/creating-your-first-visual-basic-for-applications-vba-in-excel.html

https://riptutorial.com/excel-vba

https://www.listendata.com/2014/05/excel-macro-beginner-tutorial-make-your.html

https://www.i-programmer.info/ebooks/automating-excel/1264-getting-started.html

Getting Started With VBA Automation

https://spreadsheet1.com/getting-started-with-vba.html

open Visual Basic Editor

Open The Visual Basic Editor

You can open the Visual Basic Editor (VBE) using the ALT-F11 shortcut or from the Developer Tab, click 'Visual Basic'

https://www.thespreadsheetguru.com/

https://www.ozgrid.com/forum/

http://excelexperts.com/forum

http://excelexperts.com/Free-Excel-Training-Videos

What are excel macros?

https://www.listendata.com/2014/05/excel-macro-beginner-tutorial-make-your.html

5 Different Ways to Find The Last Row or Last Column Using VBA

https://www.thespreadsheetguru.com/blog/2014/7/7/5-different-ways-to-find-the-last-row-or-last-column-using-vba

Copy & Paste Multiple Excel Ranges To Separate PowerPoint Slides With VBA

https://www.thespreadsheetguru.com/blog/2014/6/30/copy-paste-multiple-excel-ranges-to-separate-powerpoint-slides-with-vba

Code Sample

Giả sử cột A có những Row chứa chuỗi cần Delete cả dòng đó, ta thực hiện như sau:

  1. Press Alt + F11
  2. Go to menu Insert > Module
  3. Paste the following code
  4. F5 to delete entire row
Sub DeleteEntireRow()

Dim i As Long, searchString As String

For i = Range("A" & Rows.Count).End(xlUp).Row To 1 Step -1

searchString = LCase(Range("A" & i))

If (InStr(1, searchString, ".exe") > 0) Or _
(InStr(1, searchString, ".png") > 0) Or _
(InStr(1, searchString, ".jpg") > 0) Then
Rows(i).Delete
End If

NextRow:
Next i

End Sub

Categories

Recent posts