Importing selection of txt?
I have a VBA code importing a txt file and formating it, but I wish to modify the code to only import the latest 50 rows (when new data is added the oldest is removed). I picture a offset function might do the selection before importing, but not sure how to go about this?
this is my code today:
Apreciate any help I can get
Please Login or Register to view this content.
Why not import the entire file to a temporary worksheet then copy the last 50 rows to their destination?
If posting code please use code tags, see here.
I want it all automated, and I dont know how to do this
The code I use do open the file temorary, but need to find a code to select the last 50 rows.
I wasn't suggesting doing anything manually.
Everything I suggested can be done with code, and you've already got the code for the first part, importing the whole file.
You can't treat the text file like an Excel worksheet so can't use anything like Offset/Resize.
However if you import the entire text file to a worksheet you can use things like that.
IC! make sense! Do you know where I can find a tutorial or simular code (code for importing the text file to worksheet and select the latest 50 rows, the copy in my excel sheet?
What does the code you posted do?
In the current file you would want the rows 755 to 804?
Where should they go?
Please Login or Register to view this content.
Last edited by Norie; 12-11-2012 at 09:40 AM.
Thiw works perfectly! thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks