Excel Marco developed using Visual Basic to import contents from text file.

- Present a dialog to select the source file to be imported; the name of the file could be different every time.
- The macro will open and scan the source file and import the contents into Excel.
 Use the character “[“ to identify a new record\row.
 The content columns are separated by “,” in the source file.
 Extrapolate\identify the column name from the file.
- The source file could have 1 to many 1000’s of rows AND 1 to many 100’s of columns.
- When the process is complete the macro should present a dialog with the number of records\rows created and the number of columns. It should also ask where to save the resulting excel file.
- The dialog box should ask if another file needs to be imported.
- The code should be documented throughout the VB program.
- Column Width
 For large columns, the maximum width should be 60 units and wrap text.
 For narrower columns shrink cell content to fit.
- The macro should provide a complete import of the source file, into a well-formatted excel file.
- Need this done within 72 hours from acceptance of the project.