VBE: Cannot Insert File into Module from Disk

ID: Q175857

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition
Microsoft Word 98 Macintosh Edition
Microsoft PowerPoint 98 Macintosh Edition

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.

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:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office
               Program or Component

Additional query words: XL98 kbmacro vba vbe

Keywords          : kbprg kbui OffVBA 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Hardware          : MAC
Issue type        : kbprb

Last Reviewed: May 8, 1998