Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jonnylaw91

    VB Macros freezes/Times out

    Hey guys, I have to admit that the code isn't working in its entirety. The program still does not run through all of the way on the first attempt. I cannot figure out for the life of me why not. It would be greatly appreciated if you could help a brother out. In light of this issue, I have...
  2. Jonnylaw91

    VB Macros freezes/Times out

    Alright, I see what you are saying. I did the break as you recommended, but I wasn't sure what I was looking for. But I think at this point you are right as far as the time control in the loop. Unfortunately I'm not familiar with that function. How would you suggest I write the block, and where...
  3. Jonnylaw91

    VB Macros freezes/Times out

    SkipVough - I have also tried this route, and it would not work. I had it populated with about 15 sheets. It would work that day, but the following days it would not, If i remember correctly, it said "could not find the webpage data" or something along those lines.
  4. Jonnylaw91

    VB Macros freezes/Times out

    kjv1611 - I changed the block of code like you recommended, noticed a definite increase of speed. Thanks for the suggestion. If Current.Name = "Sheet1" Then Else 'Do Stuff End If However, I am not too certain what you mean by creating a query table. Combo - When running the macro...
  5. Jonnylaw91

    VB Macros freezes/Times out

    Hey guys, This is my first post on here, so be gentle with me. I have obviously created a vb macro that goes out to a website adds the sheet name to the end of the URL, pulls the data from the chart on the website into the respective worksheet for further analysis. Recently, I have been...

Part and Inventory Search

Back
Top