.txt to Excel macro

[kappasig84]

Hello,

I am attempting to write one macro to convert a .txt file to Excel and have the file be saved using the same name as the .txt file (security.txt & security.xls).

Because the .txt file will be overwritten occasionally, the macro has to additionally be ran on a schedule.

Here is the macro I have which will open the .txt file in Excel:

Please Login or Register  to view this content.

Now I just need help saving the Excel file and automating it. I have this save funtion so far but it needs work to use "Security.xls":

Please Login or Register  to view this content.

I would greatly appreciate any assistance.

-Scott

[Leith Ross]

Hello Scott,


Welocme to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

OR you can also do this Manually by placing the tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.


As a member, You have agreed to follow the forum posting rules. Please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules