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

On Nov 1, 9:07 am, scubadiver <scubadi...@discussions.microsoft.com>
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

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'"



"(E-Mail Removed)" wrote:

> On Nov 1, 9:07 am, scubadiver <scubadi...@discussions.microsoft.com>
> 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
>
>

Ive done it.



"(E-Mail Removed)" wrote:

> On Nov 1, 9:07 am, scubadiver <scubadi...@discussions.microsoft.com>
> 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
>
>