Excel/VBA Question

[ryancgarrett]

I'm not sure if this is even possible, or if VBA is the appropriate way to go about solving this, but any insights would be appreciated.

I have data in a spreadsheet with enrollment ids, names etc. I am currently copying the enrollment id from the cell, inserting into this URL:

http://gls.agilix.com/dlap.<wbr>ashx?cmd=getstudentsubmission&<wbr>itemid=7L5RK&enrollmentid=[<wbr>INSERT_ENROLLMENT_ID]&<wbr>packagetype=data

and it pulls up a bunch of xml code. I then copy the xml code, paste into Notepad and save as an xml file. I then open with excel and sort the data as I want it.

The problem is, I have hundreds of students to find this information for. Can i use VBA to have Excel grab the data from the web automatically inserting the enrollment ID and then saving it either as a new file or in a new tab within the same file?

I have worked a little with VBA in some of my college classes but nothing as advanced as this. Again, any ideas or suggestions are greatly appreciated.

 

[circledchicken]

Hi,

Yes, it should be possible to automate that process. As a starting point see this article:
XML in Excel

In the associated comments there is some discussion around how to handle multiple files.