Using the same techniques shown in part 2, I can construct a T-SQL statement that will be sent to the SQL server via PowerShell and gather all of the information that we needs.

More on This Topic: PowerShell Trend Reporting, Part 1: Data Gathering PowerShell Trend Reporting, Part 2: Send and Receive SQL Server Data So far in this series, we have looked at querying systems ...

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.