Web Query & Userform

[jaylotheman]

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.

[Palmetto]

Cross posted: Ozgrid

[teylyn]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

[jaylotheman]

I apologize, as stated above there is the link provided of my question asked elsewhere for added help.

Any help would be appreciated.

[jaylotheman]

Bump anyone?

[Leith Ross]

Hello jaylotheman,

What you are asking for requires a lot of programming. I will supply the piece needed to download the data from the website to a worksheet. The rest is pretty basic. The data is copied to "Sheet2" of the workbook the macro is in.

Please Login or Register  to view this content.

b]Adding the Macro[/b]

1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
   
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.