View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Roger[_2_] Roger[_2_] is offline
external usenet poster
 
Posts: 15
Default error message : I can't close my PERSONAL.XLS file

I am using Excel 2002. I have a macro which sends a file to an email
address. I have it in the PERSONAL.XLS tool bar with it's own icon so when I
export a table from ACCESS to EXCEL the macro is there ready to use. When I
click on the icon I keep getting an error message saying that I can't open
another copy of PERSONAL.XLS and I need to either rename the file or close
the 1st copy of PERSONAL.XLS.

But as far as I can see PERSONAL.XLS is closed and hidden ! If I go into the
maco's code and run it from there I have no problems. Has anyone any idea
what my problem is and how to fix it ?

thanks ... Roger