Macro to get the directory

[YCJ]

Hi all,

I need some help here. Can somebody guide me on how to get the directory of the excel file i'm currently opening using macro?

Thanks in advance,
CJ

 

[Tom Urtis]

When you open a workbook, it becomes by default the active workbook at that moment. So to know the directory of that active workbook, you can press Alt+F11 then Ctrl+G and type or paste ? activeworkbook.Path and press the Enter key.

If you want to know the path programmatically as you open the workbook, I would wonder why you'd not already know that, seeing as you'd have needed to know where the workbook was when you presumably navigated to some folder path in order to open it.

 

[YCJ]

Oh, because i need to open another file under the same folder in my program. I don't wish to fix the location because I want the folder to work from any location in the computer. If I fix the location in my program, then I would need to paste this folder in the same location in another computer.

Thanks for your response,
CJ

 

[Tom Urtis]

Oh, because i need to open another file under the same folder in my program.

OK, that would mean you want to know that path of the workbook running the macro, which would be derived by
ThisWorkbook.Path

 

[YCJ]

OH...okay i see...sorry i'm still new with this macro thing. Not really familiar with it, thanks for your help. Have a nice day.

CJ