Exporting To Excel - Get Excel To Return Down A Row And Display The Next Product Within The List Box?Apr 16, 2011
I am building an ordering system for my job. The idea is that the customer will put in a stage name for an item. That stage name is then interpreted by the program.The product id and the amount the customer wants to order is placed in a list box on the form. There are a couple of buttons, ADD, REMOVE, CLEAR, and EXPORT. The user input is handled by input boxes. When the user pushes the EXPORT button, excel should open and list out the interpreted product codes with the corresponding amount to order. I can get excel to open, but I can not get excel to display more than one line. It will display the first product, but then it comes up with an unhandled exception.I can not figure out how to get excel to return down a row and display the next product within the list box.