Microsoft Office Questions? Ask a IT Expert for Support ASAP
Sending you the file won't be of any use, because you won't have the data from the API to display, you'll get an error message without the API.
Using that code in place of the msgbox code comes up with an error,
Run-time error 424:
OK, that's getting there, at least the data is in the cell now, there's just one final part: it needs to be parsed into rows and columns. I've resent the file back with the info in H6, but that info essentially needs to be parsed into a table, or array, separated by it's rows (ie lines) and by the columns, which are comma delimited. I am sure that's easily done in the code also??
The updated file is here -
That produced an error... but don't worry, I have managed to work it out with the help of someone else in the meantime.