Paste contents of windows clipboard into a vba 2d array?

F

Flystar

Hi, I was wondering whether it is possible to have a macro tha
completes somes tasks, then prompts the user to copy a table from
website. When the user then clicks proceed or something, I would lik
to be able to paste the contents of the data in the windows clipboar
directly into a vba 2d array (and not into a worksheet). Is there an
way I can do this? :confused: Of course I would need to do some erro
checking on the windows clipboard data first, like if the contents i
infact a table, or if it is null etc. Thanks ppl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top