In response to @sue she provided the correct information for me

THE USER NAME TO PROCIDE TO AN EXCEL FILE IS

User: Admin

No pasword

My linked server is an xlsx using...

Hi

Anyway to create a surround snippet  for a SQL function like SUM(), CONVERT(), ISNULL() with AS Field at the end

SUM(MyField) AS MyField ?

It is not possible to include $selected$ twice...

Need the extra step of doing a copy-text first but works perfectly
Thank you

Hi
Very good article.
Immediatly after reading it i tried creating my fist snippet that I dreamt of for years:
An "Encapsulate" snippet.
So my first snippet was SUM as...