For whatever reason I've been assigned to another task for taking an Excel Spreadsheet and creating an application for mortgages. I only have a very basic understanding of VBA but need to do the following which I believe to be done best utilizing a web query, a user form and output form:
Must create an application that will allow a user to download the purchase price, legal fees, property taxes, and mortgage insurance homes (using this website: http://zakhomes.blogspot.com/).
Must also allow a user to calculate the total price and mortgage payments for the purchase of the home they choose.
(This is a Canadian application. The monthly mortgage payment must be based on the full house price including legal fees, property taxes (monthly) and monthly mortgage insurance costs based on the data on the web page plus GST and less any down payment.)
The user must also be able to enter in the terms of the mortgage.
Afterward the application must report to the user on a screen the housing details along with the total cost (with a breakdown of costs), the monthly mortgage payment, and the total of all their payments (with a breakdown of principle and interest amounts) along with all the financing terms.
Finally the user must have the option of printing the report in a formatted Word document.
Make sense?
Can someone help me with the code to do this? Any help would be appreciated thanks.
Reply With Quote
.
