Write a VBA function that takes in String and returns an array, i.e.:
In: " AMER EXP CDA CORP 4.70 20MAY11"
Out: "(AMER EXP CDA CORP,4.70,20,MAY,11)
Not all are this straightforward. See attachment for a list of sample inputs and expected outputs.
The function must run in Excel 2003 and use standard libraries, contain comments in English, formatted well and handle errors gracefully (see last line of attachment for an example).
Please PM with 2 small sample VBA functions with comments.
HI,I am VBA expert with over 7 years of experience.....I have understood the logic of your data and can provide you macro.....Hope to hear good from you..
Such jobs are my daily practice. Further use of macros, fixing of bugs and minor changes - including modifications for cases not represented in the sample input - are included in the bid without any additional fees.
Regards!
Hi, Excel VBA from London here. Code ready (i had some re-useable code that i tweaked a bit to achieve your desired functionality), please assign this work to me and i will send you the code.
Many thanks.
Hi..
I am Vibin with good Electrical design Background. The time period I offered is flexible as per your requirement. I assure you about delivering the project in time.
Thanks & Regards
Vibin