Hey everybody,

Background
First post, as I've been able to answer many of my questions through the use of google. I'm working on a grade calculator/schedule for my college courses. It's a project that has evolved over two semesters so far, but I'm now at a road block.

Question
The website I'm trying to load data from is a syllabus for a course. For example - https://my.excelsior.edu/web/syllabu...ary/art101_8wk. All of the links to the courses begin the same - https://my.excelsior.edu/web/syllabus-library/. I have a different sheet for each course and I'd like to load the data from the syllabus for each of those courses so I can automate the formulas for many of the calculations.

I have created a formula that returns the last part of the web address for the syllabus that I need the data from; however, it can be easily modified to return the entire web address.

How can I get excel to load the data from a web page based on the address provided by a cell?

I get the feeling that this is too complicated for a simple formula, so being that I'm new to VBA (I mean brand-spanking-new) be gentle.

Additional
Link to a copy of my spreadsheet - https://drive.google.com/file/d/0Bw9...ew?usp=sharing

I'm also asking this question on the Mr. Excel forums - http://www.mrexcel.com/forum/excel-q...ress-cell.html and I will post an answer if I receive one here as well.