Remove last three lines of text files

[ussenterprise]

Hi. I am working on importing text files which works for the most part. Per the code below, I create anywhere from 8 to 30 text files (depending on several factors) that can vary in size between 2000 lines and 20000 lines.
The last three lines of each of these text files is always the same. I need to remove these last three lines from the text files prior to importing them into the spreadsheet.

Any help here is greatly appreciated.

Please Login or Register  to view this content.

[Leith Ross]

Hello ussentterprise,

Are you downloading the text file or viewing it in the PuTTY window?

[ussenterprise]

Hello Leith,

The macro opens a PuTTY window with logging to create a text file based on the VV variable.

Edit: The text file is them imported into Excel. For formatting purposes, I need to remove the last three lines.

[Leith Ross]

Hello ussentterprise,

The text file is automatically opened in Excel after the Shell command executes? Is this a new instance of Excel or do you have Excel already open?

[ussenterprise]

Hello Leith,

Excel is open when the macro runs. The text files are set to import when Excel opens. So, no data other than the previous opening of Excel is present. At some point, I may set the import to refresh at certain intervals.

[Leith Ross]

Hello ussenterprise,

Try this...

Please Login or Register  to view this content.

[ussenterprise]

This looks like it applies after the text file is imported. Not quite what I am looking for, but I will give it shot and let you know.

I'll have to set a loop up to work with the "data" sheets.

Thanks!

[ussenterprise]

Good morning Leith,

Here is what I have come up with:

Please Login or Register  to view this content.

The autofit takes care of formatting issues.

Curiously, the very last line is not removed. However, the primary cause of needing this done is taken care of.

Next up is to get this to run automatically after the worksheet is opened and all data has been imported.

Thanks!

Edit - The line that needed to be removed:
"---------------------------------------------------------------------------------------------------------------------------"
This caused column B to be far too wide.

[Leith Ross]

Hello ussenterprise,

Nice work. I have PuTTY but do not use it very often. Obviously, I could learn quite bit from you on how to use it.

If you can change the refresh rate then it seems there should also be a flag available to signal when it has finished. Since I do not know the method you are using to refresh the data, I can not say for sure, but there should be a flag or event to indicate when it is done. I would use either of these to automatically run the macro.

[ussenterprise]

Hello Leith,

I had to make some minor adjustments. PuTTY was taking too long through the loop, so I switched to plink. This changed the formatting slightly so I had to adjust your code. The formatting change is now to delete the last two lines.

Please Login or Register  to view this content.