steelervince
Board Regular
- Joined
- May 29, 2007
- Messages
- 83
Good Morning All!
We have an internal LMS which houses courses and learners. For each of the courses in the system a maximum of 250 learners can be displayed on a single page. Some of the courses have up to 5000 learners which results in multiple pages to sift through.
What I would like to be able to accomplish with Excel:
Using the Import option or Code bring in all pages of learners for a given courses in a single step. The names need to be formatted in Rich Text. (I am able to bring in one page right now, Page 1 using the Import wizard but am unable to bring in the rest of the pages). I have been going to each of the pages and copying the data and then pasting it into Excel. Too time consuming! I am using Excel 2010.
Each course has a unique URL however, the URL does not change with each page of users displayed, which may make this more difficult than I had anticipated.
Any assistance which anyone would be able to offer would be greatly appreciated.
We have an internal LMS which houses courses and learners. For each of the courses in the system a maximum of 250 learners can be displayed on a single page. Some of the courses have up to 5000 learners which results in multiple pages to sift through.
What I would like to be able to accomplish with Excel:
Using the Import option or Code bring in all pages of learners for a given courses in a single step. The names need to be formatted in Rich Text. (I am able to bring in one page right now, Page 1 using the Import wizard but am unable to bring in the rest of the pages). I have been going to each of the pages and copying the data and then pasting it into Excel. Too time consuming! I am using Excel 2010.
Each course has a unique URL however, the URL does not change with each page of users displayed, which may make this more difficult than I had anticipated.
Any assistance which anyone would be able to offer would be greatly appreciated.
