Microsoft KB Archive/175857

From BetaArchive Wiki

Article ID: 175857

Article Last Modified on 11/13/2003



APPLIES TO

  • Microsoft Excel 98 for Macintosh
  • Microsoft Word 98 for Macintosh
  • Microsoft PowerPoint 98 for Macintosh



This article was previously published under Q175857

SYMPTOMS

When you try to insert the contents of a text file into a Microsoft Visual Basic for Applications module, the file is not inserted.

CAUSE

This problem may occur if the following conditions are true:

  • The text file that you are attempting to insert into the module is stored on a disk. -and-


  • The disk containing the file is in MS-DOS format. -and-


  • The disk does not have a volume name.


WORKAROUND

To work around the problem, rename the disk. To rename the disk, follow these steps:

  1. On the Application menu, click Finder.
  2. If the desktop is not completely visible, click Hide Others on the Application menu.
  3. On the desktop, click the icon for the disk. Click a second time, and the name of the disk is selected.
  4. Type the new name for the disk, and then press RETURN.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

REFERENCES

For more information about inserting files into a module, click the Office Assistant in the Visual Basic Editor, type "insert file," click Search, and then click to view "Import a Text File into Code."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

120802 Office: How to Add/Remove a Single Office Program or Component



Additional query words: XL98 kbmacro vba vbe

Keywords: kbprogramming kbui kbprb KB175857