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.
1 2 3 4 5 6 7 |
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.