Question: I have a macro-enabled WorkBook. I need to specify the current folder in which the macro-enabled file is present as the path. I tried setting 

```
path = ActiveWorkbook.Path

```

*and*

```
path = CurDir()

```

but neither of these work for me. Any idea on this?

Answer: 
If the path you want is the one to the workbook running the macro, and that workbook has been saved, then 

`ThisWorkbook.Path`

is what you would use.
I thought I had misunderstood but I was right. In this scenario, it will be `ActiveWorkbook.Path`

But the main issue was not here. The problem was with these 2 lines of code

```
strFile = Dir(strPath & "*.csv")

```

Which should have written as 

```
strFile = Dir(strPath & "\*.csv")

```

and

```
With .QueryTables.Add(Connection:="TEXT;" & strPath & strFile, _

```

Which should have written as 

```
With .QueryTables.Add(Connection:="TEXT;" & strPath & "\" & strFile, _

```