Tutorials

.

Advanced Excel VBA Tutorial

  1. Connect to HP QC using Excel VBA
  2. Create Folder Structure in Test Lab and Pull test Cases from Test Plan
  3. Download Test Cases from HP QC with Design Steps
  4. Download Test Cases from HP QC without Design Steps
  5. How to connect to Access Database – ADO Connection String
  6. SQL Connection using Excel Macros
  7. Oracle Connection String in VBA
  8. Query Database and Spreading the Records in Excel – VBA Code
  9. ADO RecordCount Property – RecordSet Object
  10. Calculate distance between two places in Excel [With Fun]
  11. VBA to Add Static Google Map in Excel Sheet

40 Useful Excel VBA Code with Examples

1. Create a New Excel Workbook using Excel Macro
2. Open an existing Excel Workbook using Excel Macro
3. Close a workbook without saving the changes using Excel Macro
4. Close a workbook by saving the changes using Excel Macro
5. Save or SaveAs a workbook using Excel Macro
6. Delete a workbook using Excel Macro
7. Add a new worksheet in a workbook using Excel Macro
8. Add a worksheet at a specified position using Excel Macro
9. Rename a worksheet using Excel Macro
10. Delete a worksheet using Excel Macro
11. Change the tab color of a worksheet using Excel Macro
12. Copy a worksheet within same workbook using Excel Macro
13. Copy a worksheet as a new Workbook using Excel Macro
14. Copy a worksheet by providing sheet name of your choice using Excel Macro
15. Hide a worksheet using Excel Macro
16. Hide all worksheets except activeSheet using Excel Macro
17. Unhide a worksheet using Excel Macro
18. Unhide all worksheets in a workbook using Excel Macro
19. Check if a sheet with particular name exists in a workbook using Excel Macro
20. Sort all worksheet alphabetically using Excel Macro
21. Insert a row in a worksheet using Excel Macro
22. Insert a column in a worksheet using Excel Macro
23. Delete a row in a worksheet using Excel Macro
24. Delete a column in a worksheet using Excel Macro
25. Hide a row in worksheet using Excel Macro
26. Hide a column in worksheet using Excel Macro
27. Unhide a row in worksheet using Excel Macro
28. Unhide a column in worksheet using Excel Macro
29. Copy and insert copied row before a specific row using Excel Macro
30. Copy and insert copied column before a specific column using Excel Macro
31. Protect a worksheet without any password using Excel Macro
32. Protect a worksheet with a password using Excel Macro
33. Unprotect a protected worksheet using Excel Macro
34. Unprotect a password protected worksheet using Excel Macro
35. Protect a workbook with password using Excel Macro
36. Open a password protected workbook using Excel Macro
37. Clear contents of a Range without clearing formatting using Excel Macro
38. Clear content of a range with formatting using Excel Macro
39. Clear contents of a worksheet using Excel Macro
40. Clear all the comments using Excel Macro

Send Email Tutorials

  1. Send Sheet as a PDF attachment in Email
  2. How to Send Chart Picture as an Attachment in email
  3. How to Send Chart Picture embedded in email Body
  4. How to Send more than one sheet of the current workbook in email(Send more than One Sheet)
  5. How to Send email with the Active Sheet attached in the mail. (Send One Sheet)
  6. How to Send an Email using Excel Macro from Gmail or Yahoo
  7. How to send email from Excel Macro from Outlook
  8. How to Send ActiveWorkbook as attachment in Email
  9. Excel Macro Application to Send Multiple Emails (Download available)
  10. How to Send Email Automatically from Excel (Download available in the Article)
  11. How to insert Outlook Signature in Email by Excel VBA
  12. How to Send a HTML Email using Word Email Template using Excel Macro
  13. Send Image of a Range from Excel embedded in Mail [Inline Image in Mail]

VBA Programming Tutorial

  1. VBA Programming : Variables in Excel VBA
  2. Implicit and Explicit declaration of variables in Excel Macro
  3. Important : Declaring multiple Variables with one Dim Statement
  4. For Next Loop in Excel Macro
  5. While Loop and Do While Loop in Excel VBA
  6. VBA Programming : If Then Statements / If else Statements
  7. VBA Programming : Decision – Select Case in Excel VBA

Tutorial for Beginners

  1. What is Excel Macro ?
  2. How to Record / Run Excel Macro ?
  3. How Add Developer’s Tab in Excel 2007 / 2010
  4. How to add different types of controls like Text Box, Radio button, button etc. in Excel
  5. Visual Basic Editor in Excel
  6. VBA Control Property
  7. How to write Excel Macro – Your First Excel Macro
  8. How to Run you code in Debug Mode?
  9. What is Break Point and how to use it?
  10. What is Compile Error?
  11. Excel Macro Tutorial : Excel User Form
  12. VBA Spin Button
  13. Toggle Button in Excel
  14. ComboBox / Drop Down List In Excel
  15. ListBox In Excel
  16. How to Open Excel Workbook using Excel Macro
  17. Using RANGE Object in Excel Macro
  18. What is difference between CELLS() and RANGE()

.

.

Recent Articles

Join and get a FREE! e-Book

Don't miss any articles, tools, tips and tricks, I publish here

You have Successfully Subscribed!

Pin It on Pinterest