Programming macros

[Nahim]

Hi Everybody!!

I applied in Huawei. They asked me for programming macros in excel.

I am just starting in this subject and I want to practice programming macros using vba editor in excel.

1. What kind of tasks needs to be solved by programming macros ??

2. could You give me some example tasks to practice programming??. It is not necesary these to be solved I will make the code for practicing

[xsdenied07]

Hi Everybody!!

I applied in Huawei. They asked me for programming macros in excel.

I am just starting in this subject and I want to practice programming macros using vba editor in excel.

1. What kind of tasks needs to be solved by programming macros ??

2. could You give me some example tasks to practice programming??. It is not necesary these to be solved I will make the code for practicing

http://s6.postimg.org/a880pvssh/Macro.png

[Nahim]

http://s6.postimg.org/a880pvssh/Macro.png

I guess in example # 1 these kind of tasks can be solved by recording macros, without programming

I would like if you can give a more details about example # 2.. I am at optimization area and I don't know too much about converting mml in readable xls format.. it sound a possible task huawei ask to programming in a macro

[peanut]

Dear,

Please check the posted link, you can access VBA code by hitting Alt+F11

http://www.finetopix.com/showthread.php?41138-Huawei-CFGMML-PARSER-RAN13-and-ABOVE&p=232959#post232959

best regards,

[wanta]

I think your requirement could be parsing the output log of HW's MML commands. EXCEL VBA is easier for entry. Perl is more powerful in text/strings analyzing.