Enter Part Of The Archive Name In A Cell,Save

Hi Alogoc. Reading your macro, it appears you're first deleting the first 4 columns, just doing it one at at time. Try this, without all the "selecting".

Please Login or Register  to view this content.

As for your question referring to the PARFNP, what number exactly? The 170? Since you're hardcoding that whole text string into cell A1, I can't imagine how you can't just put the 170 into a variable, too.

As for finding the next empty cell at the bottom of column B, here's one example:

Please Login or Register  to view this content.

If you really want this to be simple, click on GO ADVANCED and use the paperclip icon to upload a sample workbook. Show us a BEFORE and AFTER sheet so we can clearly see your goal.

Palmetto,no need to post link,they locked the thread anyway.It's the internet,we are free and of course we can't expect information/help from one source only,as you don't always get help.

JBeaucaire thanks so much for answering my thread.I understand that's the
1st part is really difficult to be achieved since a text follows (both after and before) But perhaps there is a way?

The archive is opened and save as .txt.Though it doesn't matter,because i care about the procedure that happens in excel.
So here it is,before and after.

Unfortunately the 3digit number cannot be obained from the A cell because it's not standard were to be found,but it's always after the word sprider,maybe can be done something with that?

Thanks for trying help,i really hope we can get into something

Hi Alogoc. Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, crossposting the same question in multiple forums requires you to post a link here to the other threads. It's a forum rule.

This is all free, and we work hard to help. Crossposting almost guarantees someone is wasting their time. Since I know you don't want to waste anyone's donated time, I'm sure you now can see the benefit of requiring OPs to include cross-post links. It allows us to see/read/research what has been done already.

With only one example of where the 836 is in the string, I have no way to tell what the hurdles are each time. In this instance, it appears just taking the last 3 characters would work. But you warn no, it's not standard.

Is it always the 3 characters immediately after sprider?

Can you provide samples of all the various sprider strings?

Originally Posted by alogoc

I never said you don't work hard to help people and it's really nice of you that you still keep it free,i mean it,instead of other sites.In fact i have been helped more than once in this forum and i am really thankful for that.

I am sorry,but i did not know that i need to post the link from the other forum (yes it's my fault).But i make sure to you that if that if there was a non completed or completed solution from another forum,site,friend or anything else i would post it here...as i have done this before.

Since I'm still trying to help you, I'll also respond to this. Sometimes, the right answer is simply, "I'm sorry, I'll follow the rules. Thanks for reminding me."

Originally Posted by alogoc

You are so right...we humanoids always make things more complicated

Hey! Speak for yourself! (Hehe)

Try this:

Please Login or Register  to view this content.

You can. If i were you, though, I would become a student of the Macro Recorder. The code it records includes a lot of junk, but most of all it quickly provides syntax for the functions you're trying to achieve.

Turn it on and let it record you saving the current sheet to the text file format you desire. Then turn it off and check out the code.

Post the code into a new thread with your questions about automating the filename portion and path, etc, everything you want help converting from the hardcode the recorder gave you to something more dynamic.