Categories: Projects, .Net, ASP, Visual Basic, Silverlight, 3D, SQL Server, 2005, 2008, VBA
Iterating through Excel Named Ranges
Simple code to iterate through named ranges Dim fm as Form Dim nm As Name Dim val As Double For Each nm In ActiveWorkbook.Names 'Check MacroType and Sheet References (in Name and Value) 'If (nm.MacroType < 0 And InStr… more »
Iterating through Workbook Tables
Nothing special just want to put a culmination of information available out there into one useful code-snippet Dim wb As Workbook Set wb = ActiveWorkbook Dim ws As Worksheet Dim lo As ListObject Dim lc As ListColumn Dim lr As Li… more »
SQL Agent Jobs - Non Maint Plan
While doing some development found a need to find non-Maintenance Plan Jobs for doing some reporting. After couple minutes searching Google and some other sites, there is a huge lack of information or queries that effectively show how to obtain or tie s… more »
Acquire SQL Service Account
LinkBack: Found this nice little code snippet for researching the SQL Agent running account. Left a linkback to the original site, but it was seriously laggy due to some backend stuff.DECLARE @SrvAccount varchar(100)set @SrvAccount =''… more »
Linked Server....
Well today, I started the fun filled adventure of managing data from/to a LinkedServer.
During this learning curve, I found plenty of information about how to query from and instert into a Linked server but most of them utilized the OpenQuery TSQL Sta… more »
:: Next >>