Insert Macro From File Hangs When You Use Long Filename (136525)



The information in this article applies to:

  • Microsoft Excel for Windows 95

This article was previously published under Q136525

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.

Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbProgramming KB136525