CODEWITHSUNDEEP
vbaexcel
user1270123
user1270123

Reputation: 573

How to specify the current directory as path in VBA?

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?

Upvotes: 17

Views: 131232

Answers (2)

Siddharth Rout
Siddharth Rout

Reputation: 149277

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

Upvotes: 7

Tim Williams
Tim Williams

Reputation: 166126

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.

Upvotes: 32

Related Questions