copy Excel compatible URL page content to Clipboard

[kken tthompson]

I can copy this data and have it pasted the clipboard easily using manual keystrokes. Creating a simple macro doesn't work. It seems like VBA doesn't do this operation due to clipboard restraints. I'm an 80 years old retired engineer Just staying mentally active...and I'm about 3 steps "beyond newby". Logic is : clear clipboard , copy URL data to excel clipboard, close macro. CoPilots last verrsion had me going to a library and using the API clipboard.

 

[Dan_W]

To be honest, using the API Clipboard isn't a bad idea. It's more reliable, I find, than the VBA Clipboard-lite.
When you say URL data, what do you mean? Do you mean the text on a website? Where are you copying it to? It's just that there may be another way without having to resort to using the clipboard.

 

[kken tthompson]

yes, I'm referring to the Excel compatible text on the url page. FYI, the URL owner has locked the Page URL and name mining opportunities but left the text available and compatible. It will copy as a normal copy /paste to the worksheet, but it won't be recognized for further processing. Thank you for responding.

 

[Dan_W]

If it's not a problem, can you share the URL?