View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Martyn Martyn is offline
external usenet poster
 
Posts: 80
Default need logging before closing the workbook.

Hi Frank,
Thanks for all your help. I am not getting anyware. Although I've changed
the path to "C:\" and put the "log.xls" file there as your last suggestion,
I keep getting the macro error!. Don't know if you are using a version
better then XL2000 maybe inspide of my Win98SE system+Office2000.
Finally: I need to have the log file opened prior to the execution of the
macro in order to write to the log file.
Wow....what a try!.....
I'll be much obliged to any expert that can pin-point the trouble.
Martyn