|
hi!
i have made a .net project for billing process. What is happening is a form is open i select the firm name, partyname, enter bill no. date, item and item details (Rate, qty and many more) On clicking ok button i wish to open an existing excel file and since there are no of firms under single head and all have different printed bill format. i have made different sheets in an excel file according to the printing design.
i wish to open that excel file and only that sheet whose firm is selected.( All sheet names are according to firm name) rest sheets remain unhide all entered value in the vb.net form automatically entered in the sheet at their right place and after printing and closing the excel file i return to the initial form.
Simultaneously i wish to save the record in database also.
thanks in advance
sneha
|
