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

User · 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  amp     csv     Which should have written as   strFile   Dir strPath  amp      csv     and  With  QueryTables Add Connection   TEXT    amp  strPath  amp  strFile      Which should have written as   With  QueryTables Add Connection   TEXT    amp  strPath  amp       amp  strFile

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

Examples related to vba

Examples related to excel