The Daily Dose

I use a product called SQL Prompt from Redgate in SSMS. Honestly I can’t image life without it. They added a new feature to the grid right-click menu called Open in Excel.

It’s very handy and definitely worth the trip over to my mouse. My only complaint about it is that it adds the resulting workbook to the MRU. That muddies up my KwikOpen Addin (original, update) particularly when I’m searching for “exported” or “results”.

I don’t think they should be adding that to the MRU and I’ve told them so. But in the meantime I’m going to exclude it from my list of files. Here’s the relevant part of the Fill method in the CRcntFiles class.

For Each rf In Application.RecentFiles
        If Not rf.Path Like "*\Local\Temp\*Exported results *.xlsx" Then
            Set clsRcntFile = New CRcntFile
            clsRcntFile.FullName = rf.Path
            Me.Add clsRcntFile
        End If
    Next rf

I really need to build an exclusions interface where I can enter matching strings to exclude rather than putting it in the code. Someday.