Although Excel has many facilities for importing and exporting text files, it can't handle every possible format. Using VBA, you can import and export text with much greater flexibility.

FileDialog allows you to display the FileOOpen and FileOSave As dialog boxes as well as a directory browser. It provides more powerful facilities than the GetOpenFileName and GetSaveAsFileName functions, which are only available in Excel.

FileDialog could be used in conjunction with the text file handling procedures that were presented to allow users to specify the location of input and output files.

0 0

Post a comment