Hi everybody.
Someone can help me delete data in a text file.
Thank you.
Hi everybody.
Someone can help me delete data in a text file.
Thank you.
Yes, but it would be helpful if you uploaded a sample file so that we know what to delete. More information is needed.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi !
See Kill statement in VBA help …
The data in the file only has numbers and letters.
I want to remove all that data.
Thank you.
I have a solution for my problem.
Now I want to delete the data of many Text Files with the same folder, how do fix the code?HTML Code:
Last edited by tax112; 07-12-2019 at 11:10 PM.
Just read this ‼
Marc - I think a sample code snippet based on the OP's code would help, don't you? I know you think everyone should work everything out for themselves, but a little bit of guidance along the way would not go amiss.
How would the OP incorporate the KILL statement into their code? As a VBA learner myself, I'd like to know, too. I am sure it will only take you a moment to demonstrate it to us. Worked examples are always the best approach to teaching and I know this because teaching is my profession.
Last edited by AliGW; 07-13-2019 at 06:17 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Kill will delete the file entirely and from what I understand you simply want to erase data, not delete files.
One way to do that is using the FilesystemObject.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Rudi - thank you for the clarification and the helpful contribution.
You're welcome and thanks for rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks