| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting data from SQL
Try this:
1. Create your ADO connection object. 2. Set its Properties.Prompt.Value = 1 ' adPromptAlways 3. Open your Connection object An appropriate form will open up asking for the relevant/missing information. Sub aa() Set adoc = CreateObject("ADODB.Connection") adoc.Properties("Prompt").Value = 1 adoc.Open End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Labels- POssible to show data value and data label together? | Charts and Charting in Excel | |||
| Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
| Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
| Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
| MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) | |||
Hybrid Mode
