How to specify the current directory as path in VBA

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

User · Accepted Answer

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, _

User · 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

[vba] How to specify the current directory as path in VBA?

Examples related to vba

Examples related to excel