I have created this page to provide help on Excel & Excel VBA. I will periodically post some tricks in excel that will help users to reduce their efforts and increase accuracy....
Please help me write a code. I understand I need to use the line input function. I am new to VBA and I am finding it a little difficult to write a code.
Is there any function I need to use that could make this process faster.
Thanking everyone for the help. Looking forward to a prompt response
Hi, Need more clarity on your question. 1. I am not able to differentiate the input and the expected output. Can you please explain it in more details. 2. Also, please let me know where you want the output/results, do you need it in an Excel file?
Hi I have an assignment for which I need to use VBA
ReplyDeleteI have a text file, a sample of which I am showing below.
Tom_Cruise|21|1998|07041971|New_avenue|A1|0
Michael_Corleone|15|2001|04071981|Old_street|B2|0
Serena_Tucker|25|2004|
05081985|National_park|C3|1
James_Frank|15|2005|01021983|Reynold's_street|
D10|0
I need to write a code so that the file will appear as indicated below
Tom_Cruise|21|1998|07041971|New_avenue|A1|0
Michael_Corleone|15|2001|04071981|Old_street|B2|0
Serena_Tucker|25|2004|05081985|National_park|C3|1
James_Frank|15|2005|01021983|Reynold's_street|D10|0
Please help me write a code. I understand I need to use the line input function. I am new to VBA and I am finding it a little difficult to write a code.
Is there any function I need to use that could make this process faster.
Thanking everyone for the help.
Looking forward to a prompt response
Hi,
ReplyDeleteNeed more clarity on your question.
1. I am not able to differentiate the input and the expected output. Can you please explain it in more details.
2. Also, please let me know where you want the output/results, do you need it in an Excel file?