Combine Text Files in Current Directory 1

[Nu2Java]

Hello, I am not very familiar with this line of code and how to modify it with a variable.

Set FileList = objWMIService.ExecQuery _
    ("ASSOCIATORS OF {Win32_Directory.Name='C:\Temp'} Where " _
        & "ResultClass = CIM_DataFile")

How do I change the line for the path to use a variable for current directory? Instead of calling a path between ' ' I was trying to enter a variable for the current directory, but I kept getting errors.

Thanks!

 

[PHV]

Like this ?

strPath = "C:\Temp"
Set FileList = objWMIService.ExecQuery _
    ("ASSOCIATORS OF {Win32_Directory.Name='"  & strPath & "'} Where " _
        & "ResultClass = CIM_DataFile")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Nu2Java]

Thanks PHV .... I wasn't putting the double quotes. Works great!