View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
edward edward is offline
external usenet poster
 
Posts: 87
Default 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.