View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TimR[_2_] TimR[_2_] is offline
external usenet poster
 
Posts: 2
Default How do you make the INFO("directory") function work?

The INFO("directory") function displays the default directory instead of the
directory that the work book is saved in. I have succeeded in getting the
function to report the correct directory if a "Save As" command is used, but
closing the workbook and excel and then reopening excel and the workbook
agains shows the results as the default directory instead of the directory
that the workbook is saved in.