Recent content by halobender

I will try to put this to use on another project as well.. I understand the vb once its written and can edit it but as far as doing it all on my own thats another story

You my friend are brilliant!! works like a charm!!

The query returned is in one column and is 10 rows example query 1:You Name It - City 2: 3:####-A Major Hwy 4:City, State ##### 5: 6:view map 7:(1669.3 miles away) 8: 9:Phone: ###-###-#### 10:Back Ultimately and ideally I would just need rows 3, 4, and 9, and if I could get those to...

I guess I should clarify Column 1 or A is named "Name" the values in that column are listed as a bunch of text or names instead of the link itself I have created a new column 4 or D and labeled it "Expanded" which is the actual link that column a refers to so its values are...

No it is in column D but I could move it if necessary

Okay Skip I am trying to hang with you on all of this.. I'm hung up on a few issues.. 1 - I followed your step directions and am a little confused as to what I am watching for.. It does say to query [Name] where "Name" is column A name. 2 - It errors out on .Refresh BackgroundQuery:=False...

Okay if I understand you correctly. 1 - Copy the link from A2 and use that to build a new web query on sheet 2 2 - Record a macro of me editing that query 3 - paste it back here I hope this is what you meant. Sub queryedit() ' ' queryedit Macro ' ' With Selection.QueryTable...

Here you go not that it does a whole lot.. Sub webcopy() ' ' webcopy Macro ' ' Sheets("Sheet1").Select ActiveCell.Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Sheets("Sheet2").Select ActiveCell.Select ActiveCell.FormulaR1C1 = _...

Yes I manually added a new query to sheet two like you said. It returns a few lines of text in ten rows. I don't need all of the information but I can trim the information at a later step if needed. I do however need that information and 899 more querys. As far as query manually I am using the...

Okay I think we both got a little confused. The original web query gives me info in three columns and 900+ rows. In column a is another web link containing more information I need to obtain. When you asked me to use sheet two to create a query based on the link in column a that is what the...

Skip thanks for the reply. I have seen some other posts you have made kind of about the same topic. If i run a query on the first link I get the information I am after which is two tables containing 11 rows of information. That information is what I am ultimately after but manually querying...

Any suggestions?

Not exactly sorry for not being descriptive enough. The original query imports a list of information into three columns Column A = a hyperlink to a small page of text on the web Column B = text Column C = text The information I need to obtain is located in column A but only after clicking...

Hey all I have an issue and could use some extra brains. Here is what I have.. I have a web query created in excel 2010 which has imported three columns and 500 rows A = web hyperlink text B = place C = place I need to find a way to use vba or the web query itself to visit the web hyperlink...

are you wanting this to break links with another worksheet because the data is coming up #value or #na due to missing information.. if that is the case then you have left something out of this post and your previous post. somewhere you have managed a copy paste where excel is still referencing...