View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lynn[_2_] Lynn[_2_] is offline
external usenet poster
 
Posts: 5
Default Dynamic Link to SQL

Can I access a store proc or only tables/views.


-----Original Message-----
Certainly, just use the Workbook_Open() event to run your

SQL code.

E.g.,

Private Sub Workbook_Open()

' Insert code to run SQL here

End Sub

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com

***
Don't just participate in USENET...get rewarded for it!
.