Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique Footer for each page in worksheet with a page number | Excel Worksheet Functions | |||
Page numbers on copies of a single page worksheet | Excel Discussion (Misc queries) | |||
change cell size from page to page on the same worksheet | Excel Worksheet Functions | |||
Converting a muliple page worksheet to a single page worksheet | Excel Discussion (Misc queries) | |||
why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) |