Web page to worksheet
To get my data in a useable format, I have to paste 1000-3000 lines of data
(copied from an intranet site) from the clipboard to the spread sheet. Unfortunately, pasting as text or other formats does not give the data in parseable form. This is slow. I haven't been able to get Web Query to work, but even if I did, I am not sure it would serve my purpose since the user has to go to a different web page each time. Is there some way I could paste it first to an array and then transfer? Or do you have some other suggestion.Is there a way to refer to "the clipboard contents" in visual basic and paste it directly to an array and then paste the array to the spread sheet? I am only guessing that it it may be quicker to do it this way. Also once I had it in an array, I could do the manipulations quicker although perhaps the VLOOKUP function would be faster than any looping that I could do through an array. If it helps to understand what I am talking about, email me at and I'll send an example of my program with data already pasted into it. Thank you for your help, Darin |
All times are GMT +1. The time now is 01:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com