csv to excel is working but I can't figure out how to save the resulting workbook

[krixham]

I have borrowed this code from someone but I can't remember who. It's working great, but I just can't figure out where to name and save the excel workbook. I would like to automate this so it will run and then automatically save the workbook and close the process. This is kind of long, but any help I can get will be terrific. I'm new to the vba in excel coding.

Please Login or Register  to view this content.

[Pepe Le Mokko]

Please Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[krixham]

I have modified my original post to comply with forum rules.