Activate Application Role from Excel

• Khalid-151305

  Right there with Babe

  Points: 737

  More actions

  March 23, 2005 at 1:35 pm

  #87166

  Hi

   How Can I activate Application role from Microsoft Excel? I know sp_setapprole stored procedure but I don't know where I have to use this stored procedure in Excel?

   

  Thanks

  Khalid

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  March 23, 2005 at 3:09 pm

  #548616

  Khalid,

  I would assume that you need to go to Tools->Macro->Visual Basic Editor

  You can use VBA from there. In VBA you may use ADO or something to connect to SQL Server. I did not do it myself with Excel but did with MS ACCESS.

  I will be interested if someone will advise us here how to do it when refreshing Pivot Tables

  Yelena

  Regards,Yelena Varsha