Problem saving/closing workbook as an excel spreadsheet

I'm tweaking a couple of VBScripts that I found online to open several .dat files in a folder, separate the data into columns using the text to column function, then I'm trying to save the file as an excel file. The problem, which you would think would be the easiest part, is saving the file. Any thoughts will be appreciated. Several code lines are disabled below (for example the save and close lines) as they currently don't work.

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.