Hey guys,
I've looked at a few forum posts on here but have yet to come to a definite solution for my problem. In short, I am trying to import the table on the following link:
Fantasy Basketball Projections
It is a table of numberfire's projection for NBA players each day. However, the table cannot be selected when running a web query, and importing the entire page causes my excel to crash (on several different computers). I have read of people solving a similar problem by recording a macro that copies the table on internet explorer and then pastes it into the workbook. I have tried this but I have been unsuccessful thus far. If importing using a web query is indeed impossible here, then I would really appreciate some other options (such as the one aforementioned) that I can use to automate this process.
As always, I appreciate the help.
I've looked at a few forum posts on here but have yet to come to a definite solution for my problem. In short, I am trying to import the table on the following link:
Fantasy Basketball Projections
It is a table of numberfire's projection for NBA players each day. However, the table cannot be selected when running a web query, and importing the entire page causes my excel to crash (on several different computers). I have read of people solving a similar problem by recording a macro that copies the table on internet explorer and then pastes it into the workbook. I have tried this but I have been unsuccessful thus far. If importing using a web query is indeed impossible here, then I would really appreciate some other options (such as the one aforementioned) that I can use to automate this process.
As always, I appreciate the help.
