Export To SQL

Export To SQL DESCRIPTION: This macro exports stock daily data: FINRA Reg SHO Daily Files(FINRA/NASDAQ TRF Carteret) to SQL server. http://regsho.finra.org/regsho-Index.html   Export To SQL

    Ratings:

Read More

Import From SQL Server

Import From SQL  DESCRIPTION: This macro imports stock daily data: FINRA Reg SHO Daily Files(FINRA/NASDAQ TRF Carteret) from SQL server. http://regsho.finra.org/regsho-Index.html   Import From SQL  

    Ratings:

Read More

Outlook Automation

Outlook Automation  DESCRIPTION: To export emails to ExcelSheet by using Outlook macro and Excel macro. Basically, the logic of the codes of the two are similar. The only major differences is using different references. When you run macro in outlook, you need to Excel application references. On the other hand, if you run macro in […]

Read More

PowerShellDetail

CMDLET: Get_Childitem DESCRIPTION: To list any empty directory full name

  I spoke to Rose on Wednesday, before Game 3 of the Finals, which he was covering from Oakland. I had been interested in talking about his basketball and media career, but I started by asking him about the analytics movement, which has revolutionized […]

Read More

Binding

Binding DESCRIPTION: The difference between EARLY Binding and LATE Binding. EARLY Binding 1. New requires that a type library is reference (Microsoft Internet Control Reference Library) 2. IntelliSense available LATE Binding 1. CreateObject uses the registry. No reference needed 2. No IntelliSense available   Early/Late Binding

    Ratings:

Read More

Class

Class DESCRIPTION: Example of Class module implementation to populate Grade column.   Procedure

  Class

  Ratings:

Read More

Collection

Collection DESCRIPTION: VBA Collection is a simple native data structure available in VBA to store (collect as you wish) objects. VBA Collections are more flexible than VBA Arrays as they are not limited in their size at any point in time and don’t require manual re-sizing. Collections are also useful when you don’t want to […]

Read More

Last Row and Column

Find Last Row and Column DESCRIPTION: There are certain situations where we perform some tasks by finding last used Row with data in a Column. For examples, There may be many columns with data and each column may have different number of items (rows). In this situation we need to find exact number of rows […]

Read More

Reference

Reference DESCRIPTION: As a programmer, it’s a good practice to add references you need on the body of the codes rather than manually added to the application. This gives an assurance that the application always work whenever new implementation is done. There are 2 ways to add references in VBA: 1. Via GUID 2. Via […]

Read More