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
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
I really need to build an exclusions interface where I can enter matching strings to exclude rather than putting it in the code. Someday.