Text file to Excel conversion with Ascending order

[pvsvprasad]

Dear all Mates,

Kindly arrange the small modification in existing code.this code is developed many weeks back by well wisher from this site.

My Code as below:

Please Login or Register  to view this content.

with help of above code developing excel file, and required modification is mentioned in sample excel file.and text file also attached.please find the attachments

Kindly modify the Code

Thanking you,

Best regards.

[FDibbins]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[YasserKhalil]

Try this line of code

Please Login or Register  to view this content.

[pvsvprasad]

Try this line of code

Please Login or Register  to view this content.

Dear sir,
Thank you very much your kind help, i got your new code as below

please make small correction for above code. i need without "A" column, i want only B to F Columns only. please modify your code.

Thanking you,
Best regards.

[YasserKhalil]

If you don't need column A you can clear the contents of it using this line

Please Login or Register  to view this content.

[pvsvprasad]

Thank you very much sir,

Can i ask for Some columns adding to excel from text file?

[pvsvprasad]

If you don't need column A you can clear the contents of it using this line

Please Login or Register  to view this content.

Dear sir,
Kindly modify without developing Empty A column, i.e A column is started with as shown in figure.

kindly make correction.

[YasserKhalil]

Just use the word "Delete" instead of "ClearContents"
Hope this helps you

[pvsvprasad]

Just use the word "Delete" instead of "ClearContents"
Hope this helps you

Dear sir,
Your trick is well. kindly suggest correction. please find the attachments. i need two columns from above code.

Thanking you,i am waiting for your kind reply.
best regards.

[FDibbins]

pvsvprasad Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

[FDibbins]

If you don't need column A you can clear the contents of it using this line

Please Login or Register  to view this content.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

[pvsvprasad]

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

Dear sir,
I cannot understand your rule.
now what i do for fulfill your rule?

[6StringJazzer]

pvsvprasad, please take the time to review our rules. There aren't many, and they are all important. You have violated three rules in this thread.

Dear sir,
I cannot understand your rule.
now what i do for fulfill your rule?

Modify all your posts so that you enclose your code in code tags. Post #2 gives instructions for how to do this.

Also you have posted the same question to Mr. Excel. You must add a link to that thread here. Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

This thread is also a duplicate. I am closing the other thread.

[pvsvprasad]

Dear sir,
i am confused about your forum rules.

i am skipped to another forums due to lack of getting solutions.this is the only reason to skip the forums.

so please guide me how to solve my excel related problem, please delete this post and should i post freshly in this forum?

[FDibbins]

You need to use code tags when posting code. You have been around here long enough to have seen that these are required when posting code here. I will add them for you - this time, please use them from now on. See my footnote to see howe

[pvsvprasad]

Kindly close this thread,

i am confused about rules. i want to produce new post regarding this task which mentioned at thread. kindly give a permission to produce same post as a new post.

thanking you,
Best regards.

[YasserKhalil]

Hi Prasad
You can post new thread with the new request if it different from the original request
Regards

[6StringJazzer]

i am confused about your forum rules.

Please read the rules, then PM me to tell me what is confusing. I will be happy to explain further.