Wander4heat
New Member
- Joined
- Sep 25, 2013
- Messages
- 2
Hello --
i am learning vba currently having only created a few small applications in the past. I am creating a simple excel workbook that I would like to contain buttons that will open just open different SQL scripts using windows authentication. I am currently using SQL server 2008 and have seen the ssms function but haven't gotten it to work properly in a function. In its simplest form I have seen something like the following:
Sub function ()
ssms "path to SQL script
"
End sub
Should I use something like ssms for this process, and if so does anyone know syntax or can point me to where I can find proper syntax? Or should I try a different kind of approach.
thank you in advance,
wander</path>
i am learning vba currently having only created a few small applications in the past. I am creating a simple excel workbook that I would like to contain buttons that will open just open different SQL scripts using windows authentication. I am currently using SQL server 2008 and have seen the ssms function but haven't gotten it to work properly in a function. In its simplest form I have seen something like the following:
Sub function ()
ssms "path to SQL script
"
End sub
Should I use something like ssms for this process, and if so does anyone know syntax or can point me to where I can find proper syntax? Or should I try a different kind of approach.
thank you in advance,
wander</path>
