Hello, All,

I was hoping to get some help writing some code that copies and pastes user-selected financial statement data from a website to a word document for further processing. The macro would do the following:


1. Upon opening the word document, instruct the user to navigate to the relevant HTML website (e.g., http://www.sec.gov/Archives/edgar/da...123112x10k.htm)
2. Allow the user to select the appropriate data (i.e., select all the financial statement data in the HTML format)
3. Check that the user has selected the correct data by asking if the selection is complete. If no, then allow the user to reselect the data.
4. Upon positive confirmation from the user that the data selected is correct, copy the selection.
5. Re-Activate the word document. Paste the selection (with formatting) at the beginning of the word document.

Is this doable? I have been able to write code for copying and pasting, but I can't figure out how to copy and paste from a website that the user selects.

Thank you!