Closing an Excel file generates a .txt file

  • Thread starter Thread starter Jesse
  • Start date Start date
J

Jesse

This seems to happen with only a few (10) files that have
Macros. When you close out of a locally stored excel file
(not saving it) a .txt file is generated. I have
duplicated this on Excel 97 and 2002. All the .txt file
contains is "updating menu". Does anyone know why this is
happening?

Thanks,
 
It sounds like there's a macro at work.

If you open one of those files with macros disabled. You can set your security
level to high in xl2002 by: Tools|Macro|security|Security level tab.

then open the workbook.

Then close it.

Does it still get created?

If no, then it sounds like you should find the author/developer to find out why
they keep creating that text file. (It may have been a debugging technique that
got overlooked when the workbook was released to the users.)
 
Back
Top