VBE: Cannot Insert File into Module from Disk

• 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.

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:

Q120802 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
Issue type : kbprb