| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Choosing what information to filter from SQL in VBA
Hello, I have recorded a macro that connects to the SQL warehouse for a specific ClientID. Is it possible to alter the VBA so that I can choose what ClientID I want to retrieve? I was thinking of using an input box |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing what information to filter from SQL in VBA
On Nov 1, 9:07 am, scubadiver
wrote: Hello, I have recorded a macro that connects to the SQL warehouse for a specific ClientID. Is it possible to alter the VBA so that I can choose what ClientID I want to retrieve? I was thinking of using an input box Hi A bit vague Is the ClientID a text string, a number... Is the ClientID on a worksheet, in a database, a parameter in another sub, part of an SQL string... At the moment, the answer to your question is "yes, probably" regards Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing what information to filter from SQL in VBA
ClientID is a text string in an SQL server table. Here is the SELECT statement from the VBA "SELECT Account.AccountID, Account.ClientID, Account.Forename, Account.Surname, Account.Address1, Account.PostCode, Account.DateOfBirth, Account.AccountStatus FROM Warehouse.dbo.Account WHERE Account.ClientID='FTC001'" " wrote: On Nov 1, 9:07 am, scubadiver wrote: Hello, I have recorded a macro that connects to the SQL warehouse for a specific ClientID. Is it possible to alter the VBA so that I can choose what ClientID I want to retrieve? I was thinking of using an input box Hi A bit vague Is the ClientID a text string, a number... Is the ClientID on a worksheet, in a database, a parameter in another sub, part of an SQL string... At the moment, the answer to your question is "yes, probably" regards Paul |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Choosing what information to filter from SQL in VBA
Ive done it. " wrote: On Nov 1, 9:07 am, scubadiver wrote: Hello, I have recorded a macro that connects to the SQL warehouse for a specific ClientID. Is it possible to alter the VBA so that I can choose what ClientID I want to retrieve? I was thinking of using an input box Hi A bit vague Is the ClientID a text string, a number... Is the ClientID on a worksheet, in a database, a parameter in another sub, part of an SQL string... At the moment, the answer to your question is "yes, probably" regards Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter out rows of information in a list via VBA | Excel Discussion (Misc queries) | |||
| information filter | Excel Discussion (Misc queries) | |||
| Copy filter Information | Excel Discussion (Misc queries) | |||
| filter and keep same information. | Excel Worksheet Functions | |||
| Using formulas to filter information | Excel Programming | |||
Hybrid Mode
