Excel 2007 VBA Programming with XML and ASP

Chapter 18Chapter 18

Using Dialog Boxes

Excel Dialog Boxes + File Open and File Save As Dialog

Boxes + Filtering Files + Selecting Files + GetOpenFile-

name and GetSaveAsFilename Methods + Using the

GetOpenFilename Method + Using the GetSaveAsFile-

name Method + Chapter Summary

453

In Chapters 4 and 5 you learned how to use the built-in InputBox function to

collect single items of data from the user during the execution of your VBA

procedure. But what if your procedure requires more data at run time? The

user may want to supply all the data at once or make ...