Dynamic Link to SQL
 

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!

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!
.

Dynamic Link to SQL
 

You can access a stored procedure, as long as it's stored in an open
workbook or add-in. Just call it like you normally would, unless it's
in an inactive (but still open) workbook, in which case you would call
it thus:

Application.Run(strWorkbookName & "!My_Proc", argument1, argument2)

---
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!