XL7: Insert Macro From File Hangs When You Use Long Filename

ID: Q136525


The information in this article applies to:
  • Microsoft Excel for Windows 95, version 7.0


SYMPTOMS

In Microsoft Excel when you insert a macro from a text file that has a long filename, Microsoft Excel may stop responding (hang).

Two possible error messages you may receive are:

File not Found
Device I/O Error
NOTE: This problem does not occur if you are using Microsoft Excel version 5.0 for Windows NT.


CAUSE

This problem occurs when you insert a macro from a text file if the filename contains more than 110 characters.

The limit for long filenames in Windows 95 is 110 characters.


WORKAROUND

To work around this problem, open the file in Microsoft Excel version 7.0, and copy the code to the appropriate module.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words:

Keywords : kbprg
Version : WINDOWS:7.0
Platform : WINDOWS
Issue type :


Last Reviewed: October 21, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.