Search results for query: *

The web link is a secured site but here is the hyperlink that is in column A. original hyperlink is: https://centurytelorderprocessing.centurytel.net/admin/index.cfm?action=searchorders2&uuid=0007FC63-3FCF-111E-85888873D18E006C It brings up a window, granted it requires you to sign in, then I...

Ok, using Loomah's code it works fine, but I have only one problem, how can I tell it to reuse the window or close it after each line? Here's the code I am using and it copying a line of text from a web page that will never change as far as the configuration: Sub Macro1() ' ' Macro1 Macro '...

I was thinking about this over the weekend, and I understand that it loops fine, but I am trying to get it to reuse the existing web window, or close it when it rolls down the next hyperlink. I tried it with another link. test1 Macro ' Macro recorded 9/7/2004 by Julius Gazdag ' '...

I can understand that, it seems odd to me as well, but it does work. The web site is for order status. The hyperlink in column A, once selected or clicked brings it up. I then copy the entry nest to order number and then I paste it into the cell D for that line item. Not sure about window state...

Heres the latest one I made recording it. I see there is nothing there per the script, but I just tested it by deleting the entry in column d. I ran the script and it worked. Range("A378").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Range("D378").Select...

Loomah I am eager to try that, but not to sound really ignorant, but where do I add the additional code? My experience is more with SQL queries then VB maco script. Would you mind helping me out? julius.gazdag@centurytel.com Im a Telco guy, I can get you where you want to go, but I can't...

I am using VB in a macro to follow a click on a hyperlink, and then copy a single field and paste it back to the spreadsheet. I have over 900 rows and have to do this weekly. I started a Macro with the VB in it. I just can't get it to repeat for all the lines in the range. Column A is the...

Afternoon everyone, was hoping to get some help on something. I have a spreadsheet that we have to update manually on a daily basis. Column A is a hyperlink to the active record on the web. Column D is the order number. The extract is incorrect everyda and they can notfind out why. What we are...

Ok, how would i get that to go???? The field I can se as the retval as variant, but the ip address and the enter into search field would be set as how in that code? I apologize I have never tried to incorporate web look ups in the access program before julius.gazdag@centurytel.com Im a Telco...

Im very lost here. I am trying to create a link using an entry in a form to show a web page based on that entry. Here's how it is suppose to work. When I click on a particular field (circuit id), it is suppose to use that value and open a page that I have the IP for, then enter it in the search...

Im very lost here. I am trying to create a link using an entry in a form to show a web page based on that entry. Here's how it is suppose to work. When I click on a particular field, it is to copy that value and open a page that I have the IP for, then enter it in the search field and perform...

Thank you very very much guys!!!!!!!! julius.gazdag@centurytel.com Im a Telco guy, I can get you where you want to go, but I can't guarantee it will work when you get there!

Here is my current statement. I know it's way off, but: SELECT [A Z CLLI Compare].div, [A Z CLLI Compare].ckr, [A Z CLLI Compare].type, [A Z CLLI Compare].juris, [A Z CLLI Compare].aloc, [A Z CLLI Compare].zloc FROM [A Z CLLI Compare]; julius.gazdag@centurytel.com Im a Telco guy, I can get you...

Do I just drop that into my criteria? julius.gazdag@centurytel.com Im a Telco guy, I can get you where you want to go, but I can't guarantee it will work when you get there!

Is there a way to set up criteria in a query that will locate duplicates of records based on 2 fields using the 1st 6 characters in both fields to find the match with? Like I have 2 fields, one Aloc the other Zloc, between the 2 there are several that show the same 1st 6 characters. How can the...

That would generally be on the BRI's, not normally on the PRI's. julius.gazdag@centurytel.com Im a Telco guy, I can get you where you want to go, but I can't guarantee it will work when you get there!

Ok, I re ran the process, and it does record the formula. All worked out great Thanks guys!! julius.gazdag@centurytel.com Im a Telco guy, I can get you where you want to go, but I can't guarantee it will work when you get there!

Ok, I am really confused. The macro works now and pastes it to the main spreadsheet. Thanks! for that. I am wondering can I run a formula in the main sheet? Can I paste it or do I have to type it in for the cell? Here is my vlookup =VLOOKUP(A2,NOV26DATES03.xls!$A$2:$B$8663,2,FALSE) I have paste...

No, all it states is the paste error. The formula in column C is suppose to be A2&B2 to merge them, but it never does happen. julius.gazdag@centurytel.com Im a Telco guy, I can get you where you want to go, but I can't guarantee it will work when you get there!

I have 2 columns, A is the raw data and B is the additional character I need to merge it with into column C. A- E.123456 B- .C C- E.123456.C Problem is when the macro gets to this point I get a Run time error 1004 Paste method of Worksheet class class failed this is the code area that comes up...