| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Link to Quickbooks | Excel Worksheet Functions | |||
| Dynamic link to workbook | Links and Linking in Excel | |||
| Dynamic link to website | Excel Worksheet Functions | |||
| dynamic link | Excel Discussion (Misc queries) | |||
| dynamic link | Links and Linking in Excel | |||
Hybrid Mode
