i am writing a program that will take input on:
customer name
part number
part info
process to make part (array)
material requirements
compare to seperate excel workbook pages on:
raw material costs
customer markup and discounts
and output all inputs as well as price estimates to a third page.
i have designed the form and the input and calculations are working well. what i need is help with the read and write to excel parts.
i have never written a program that writes to a spreadsheet before.
please give me some pointers on the best way to accomplish my goal, as well as perhapse some sample code. thanks!
customer name
part number
part info
process to make part (array)
material requirements
compare to seperate excel workbook pages on:
raw material costs
customer markup and discounts
and output all inputs as well as price estimates to a third page.
i have designed the form and the input and calculations are working well. what i need is help with the read and write to excel parts.
i have never written a program that writes to a spreadsheet before.
please give me some pointers on the best way to accomplish my goal, as well as perhapse some sample code. thanks!