Check the Following
1.You should have BO installed in your system where you are running this macro.
2.Go to Tools->References ,Check the “Business Objects Designer 11.5 Object library” in the Available references (Add this component).
Run the macro then it will pop up for BO Designer user name and password .Then it will ask for the universe.
Then I opened the excel file and entered the data into the excel file and then ran the macro , a pop up was displayed " Created Class Successfully. But when I checked the universe , there were no classes & objects present. Again i followed the same procedure & shotted a second try , but then also I failed. I dont know where I am going wrong ?