I see I forgot the -f in my example:

strCmd = "%comspec% /c csvde -f c:\get-group\GroupMembers.csv -r " &
strFilter

If there is an error in the command passed to the Run method, you won't see
it. (unless you use /k instead of /c in the command). You can have the
script echo the final value of the variable strCmd, so you can tell if it is
a valid command. It can be hard to get all the spaces, commas, dashes, etc.
correct. I built the value assigned to strCmd in several steps to avoid line
wrapping.

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--
"PK" <PK@discussions.microsoft.com> wrote in message
news:5DBCC75A-C00F-419E-925D-8E92E2B9C924@microsoft.com...
> Richard
>
> Got the script to run no errors occour.
> However no CSV is generated, nor output made.
>
> Paul
>
> "PK" wrote:
>
>> Hi Richard
>>
>> The "H" represents the current year of students. Eg next year will be "I"
>> the groups are always 4 digits long EG I301 H508
>>
>> Heres the over all of what i need to acomplish.
>> my -I commmands are a little over anxious and were in use for other
>> quiries
>> testing.
>>
>> In this instance i realy only need forename (LDAP= givenName) to be
>> generated to the .csv it should automatically go in coloum B as DN
>> ocupies
>> column (A by default it seems).
>> then i need to delete Column A
>> and run a formula against the remainig data.
>> so i can generate first 3 letters of forename in lowercase and that is
>> all
>> that is left in my .csv file
>>
>> This will then be used in conjunction with a password generator to
>> output:
>>
>> 2 numbers and a special caracter.
>> then auto save this as a .txt file.
>>
>> My developers have written an app which will import the data left over to
>> a
>> field in AD and resep the password aswell
>>
>> Thanks for all your assistance im learning loads powerfull tools..!
>> Paul
>>
>> "Richard Mueller [MVP]" wrote:
>>
>> > You can prompt in vb or VBScript. The trick is how to prompt for
>> > multiple
>> > values. Do you always prompt for 4 values, or keep prompting until the
>> > user
>> > enters a blank? Do you assume the parent container/OU of the groups? Do
>> > you
>> > prompt for Common Name or just a 3 digit number and append "H" to it.
>> > An
>> > example could be (not tested):
>> >
>> > ' Prompt for group names and construct the filter.
>> > strCN = ""
>> > strFilter = "(|"
>> > Do
>> > strCN = InputBox("Enter Common Name of a group or Cancel", "Test")
>> > If (strCN <> "") Then
>> > strFilter = strFilter & "(memberOf=cn=" & strCN _
>> > & ",ou=mygp,dc=mydom,dc=co,dc=uk)"
>> > End If
>> > Loop While strCN <> ""
>> >
>> > strFilter = strFilter & ")"
>> >
>> > ' Use the WshShell object to run the csvde command.
>> > If strFilter <> "(|)" Then
>> > Set objShell = CreateObject("Wscript.Shell")
>> > strCmd = "%comspec% /c csvde c:\get-group\GroupMembers.csv -r " &
>> > strFilter
>> > strCmd = strCmd & " -l
>> > sAMAccountName,givenName,physicalDeliveryOfficeNam e,memberOf "
>> > strCmd = strCmd & "-SERVER.DOM.co.uk"
>> > objShell.Run strCmd
>> > End If
>> >
>> > --
>> > Richard Mueller
>> > Microsoft MVP Scripting and ADSI
>> > Hilltop Lab - http://www.rlmueller.net
>> > --
>> >
>> > "PK" <PK@discussions.microsoft.com> wrote in message
>> > news:2F8920ED-31C0-403A-A615-A348A5A8CF45@microsoft.com...
>> > > Rich can this be built in to VB some how..?
>> > >
>> > > with like a window to promps for group numbers..?
>> > >
>> > > other than that works a charm
>> > >
>> > > "Richard Mueller [MVP]" wrote:
>> > >
>> > >> Paul wrote:
>> > >>
>> > >> > I got the below to work ok, ( I can also export the entire OU)
>> > >> >
>> > >> > csvde -f C:\Get-Group\GroupMembers.csv -r
>> > >> > "memberOf=cn=H050,ou=mygp,dc=mydom,dc=co,dc=uk " -l
>> > >> > "sAMAccountName,givenName,physicalDeliveryOfficeNa me,memberOf"
>> > >> > -SERVER.DOM.co.uk
>> > >> >
>> > >> > But i need to export all members of just 4 groups (from the same
>> > >> > OU)
>> > >> > Not
>> > >> > just H050 ie i need to include H051 H052 H053 also..
>> > >> >
>> > >> > Any options \ideas.
>> > >> >
>> > >>
>> > >> The syntax for the filter would be (watch line wrapping):
>> > >>
>> > >> -r
>> > >> "(|(memberOf=cn=H050,ou=mygp,dc=mydom,dc=co,dc=uk) (memberOf=cn=H051,ou=mygp,dc=mydom,dc=co,dc=uk)(me mberOf=cn=H052,ou=mygp,dc=mydom,dc=co,dc=uk)(membe rOf=cn=H053,ou=mygp,dc=mydom,dc=co,dc=uk))"
>> > >>
>> > >> Wildcards are not allowed and you must specify the full
>> > >> distinguished
>> > >> names.
>> > >> The "|" (pipe symbol) is the "OR" operator.
>> > >>
>> > >> --
>> > >> Richard Mueller
>> > >> Microsoft MVP Scripting and ADSI
>> > >> Hilltop Lab - http://www.rlmueller.net
>> > >> --
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >