I put data into Excel from a VB form but need to return data from Excel into the VB form.
Posted on 2004-09-01
I use VB create a quotation program. The form enable the user to get information such as customer details from an access database. Next the user press a button and all this info is pasted into an excel quotation template. The body of the quote is then done in excel and all the calculations are performed. After this I want the total amount shown in a specific cell on the spreadsheet to be passed back to the open VB form and the quote info (already on the form) and the total amount to be saved into a accel database.
How do I capture the dell value from Excel after the quote is completed?