Search results for query: *

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...

Alright I have a new dilemma I need to have a macro in a spreadsheet (the master) that needs to be able to read from several different different named spreadsheets from a folder specified by the user. I am currently able to open one file at a time no problem but i wish to create a loop that...

works brilliantly, now maybe you can assist with the other issue. when i try to double click in between cell rows to make the row height adjust to the proper necessary size occasionally does not fit all text. this happens even when the cell height is not at its maximum of 546 pixels. any help...

umm i guess my previous post did not work.. While what you have offered is a good read it does me absolutely no good as far as getting this loop up and running. thanks for the great info though

well i tried a simple do loop for the spaces but am unsure how to get it to work with 3-** spaces as far as the dates i tried to make wildcard strings like Dim date1 as string date1 = ??/??/???? but when i reference it it actually inputs ??/??/???? [script] Sub TextReplacer() Dim...

Hey guys I am trying to write a macro to remove extra line breaks in blocks of text and hope to accomplish this in a loop as opposed to writing each line by hand. The issue is this, the users that have used this spreadsheet have word wrap turned on and to make a different entry inside the same...