How to get the folder name of thisworkbook
Hi,
I need some help,
How do i get the name of the folder where my .xls contain
i do not need the whole path just the folder where this active .xls is in.
file will be save in different folder, therefore i need the macro to just
get the direct folder of where this .xls is in.
|