VBA question (creating a file)

[tomch]

I am new to this.
I need a simple VBA program that does the following:


The EXCEL document is in the same folder as a bunch ofprograms.
If you select all these programs and drop them onto theexcel document, it should come up up with a pop up window asking for a filename.
After you enter a file name (123456 orwhatever you enter) it then should create a new file with that name withexactly that name.

The file should contain a header (as specified under headerin the excel document)
Followed by the list of all the program names that wheredropped into the document with a preceding expression “M198”
And finally a footer section as specified under footer inthe excel document.

So if my excel document specifies:
Header:
This
Is
A test

End header



Footer

Thank
You

End footer



And I highlight and drop the following files into thedocument (max 50):

4520

4521
4522

4523

4524



New a window has to appear asking for a file name…
And let’s say I enter
565656



I should end up with a new file called 565656 in the samefolder as all the other files.


The file itself should contain the following (in simpleASCII format):
This
Is
A test

M198 4520
M198 4521
M198 4522
M198 4523
M198 4524
Thank
You

Please note that all the entries under M198 have to be alphanumerically sorted…