LinkBack URL
About LinkBacks
Dear masters,
i had text files and i want to export text to excel from text file with some specific format in excel. kindly provide suitable macro.please find attached text file and required excel formats.
Extrect data from text file to Excel
Dear masters,
i had text files and i want to export text to excel from text file with some specific format in excel. kindly provide suitable macro.please find attached text file and required excel formats.
Originally Posted by pvsvprasad
Sorry Masters i am upload updated format of excel File.please find and make a wonder full code.
Thank you all.
Try
Please Login or Register to view this content.
Dear sir,
Thank you for providing.
i will test your code and give feedback
Last edited by pvsvprasad; 07-30-2016 at 09:04 AM.
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Dear sir,
Kindly find attached file. this file ca not developed.kindly check and modify the code.
Thanking you sir.
Last edited by pvsvprasad; 07-30-2016 at 11:08 AM.
Thank you for valuable basics.
Last edited by pvsvprasad; 07-30-2016 at 11:08 AM.
My Excel sheet is hanged, any solution for this bug? because my anl file contains 800 pages. so please tweak the code.
Thanking you sir.
Last edited by pvsvprasad; 07-30-2016 at 09:45 AM.
Change to
Please Login or Register to view this content.
Very Nicely executed sir and processing fast is greatly improved. thank you for modification. with help of this code developed only named as "C O L U M N" these items. but missing "B E A M" items named. kindly check the code.
Thanking you sir.
Last edited by pvsvprasad; 07-30-2016 at 11:07 AM.
Re: Extrect data from text file to Excel
Kindly find attachment of output Excel sheet.
1) Edit your posts and remove all full quote of my post. Should be quoted only when it is needed.
change 1st pattern
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Dear sir,
What a Execution.marvelous sir.you saved my day.now it is perfectly working sir.
Thank you very much sir.
Re: Extrect data from text file to Excel
Dear sir,
Please add some columns to your code.you are greatly developed for BEAMS and COLUMN data extraction to excel from ANL file.
can you prepare same code but i want to separate the sheets as Sheet No.1 is BEAMS data and Sheet No.2 is COLUMN data.
Both are in one Excel File. and i am adding some columns from Text file data.please find the Output Excel Sheet example.
Sorry for Your Trouble.
Kindly make a smooth code for me.
Thanking you sir.
Dear sir,
Kindly prepare a code for me. i am waiting for your valuable reply.
Thanking you sir.
You are almost asking different question now and too much work for a free forum.
I suggest you to go to http://www.excelforum.com/commercial-services/
Kindly anybody help me for my projectwork.
Re: Extrect data from text file to Excel
Dear sir kindly make a small modification in your code.1) Edit your posts and remove all full quote of my post. Should be quoted only when it is needed.
change 1st pattern
toPlease Login or Register to view this content.
Please Login or Register to view this content.
with help of your code i need to export "No" column should be developed as a ascending order. kindly find the sample out put attachment.
please execute a modification for me.
thanking you sir,
Best regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks