I want to write a macro to open an in house accounting system go to a particular page and copy data into excel i.e. based on an account code list in an excel sheet.

I have been using the Shell function to open the other system and SendKeys to get to the correct page.

This is where I get stuck as I dont know how to copy parts of the page I get to from the accounting system and then paste it to excel

Can anyone help? It would be very gratefully received

Thanks