I was wondering if Excel Macros could have the ability to copy and paste data from an external application?
I ask since at work our reports are all generated into tables updated on an intranet link so it's only accessible on internet explorer. Is it then possible for a macro to open up...