Sunday, February 13, 2011

Post your questions on Excel-VBA (Macro)

Hello,

If you have any doubts in excel VBA, please post your questions on the Help Forum. I will try and answer your queries

2 comments:

  1. Hi I have an assignment for which I need to use VBA
    I 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

    ReplyDelete
  2. 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?

    ReplyDelete