XL: How to Create a Macro That Opens Multiple Selected Files (141574)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
This article was previously published under Q141574 SUMMARY
In the Open dialog box in Microsoft Excel, you can select more than one file to open at a time. If you are using Microsoft Visual Basic for Applications with the GetOpenFileName method, you must use a macro to loop through the selected files to open them.
REFERENCES"Visual Basic User's Guide," version 5.0, pages 129-137
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB141574 |
---|
|