Hi i have imported an excel sheet in form as an OLEUnbound.
The form is for registering product details and the excel sheet am i using for price calculations. But when i register a new product the sheet doesnt clear it shows the same values enterd as in the previous product and when i change them the same thing happens with the previous products. I want to have individual sheet for products b`cus the products doesnt have same price.
Any help. I want to use that one sheet instead of making one own sheet for every products. Use the sheet as an mal or something like that.
Plz help..
The form is for registering product details and the excel sheet am i using for price calculations. But when i register a new product the sheet doesnt clear it shows the same values enterd as in the previous product and when i change them the same thing happens with the previous products. I want to have individual sheet for products b`cus the products doesnt have same price.
Any help. I want to use that one sheet instead of making one own sheet for every products. Use the sheet as an mal or something like that.
Plz help..
