$$Excel-Macros$$ Web Query Problem / Need Small Macro
Hi Guys, Find attached a simple web query that is currently being refreshed every minute. For the life of me, I am unable to figure out how to have new refreshed data placed directly below the previous data. In anycase, I realized that this would not solve all my issues. Here is what I am ultimatly looking for with a macro: 1. Once Data is refreshed in column B, only pertaining data that was just refreshed would have a date time stamp in the corresponding A column. 2. All further refreshed data would be place below the previously reshed data, again with date and time stamp in column A... so on and so forth. 3. Automatic saving is to take place every 30 minutes. 4. Once or if 60,000 rows are encountered, it would go to the next available blank worksheet. Thank you. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. TEST-001.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Format Conversation Question
That's works pefectly Haseeb. Thanks !! On Monday, April 2, 2012 8:17:30 PM UTC-4, Haseeb A wrote: Hi, In a an adjustent cell try to multiply with 24 round by 3 =ROUND(A1*24,3) Change A1 to TOI cell. ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Format Conversation Question
Hi, There is probably a very simple solution here, but I am stumped. In this link below, you will see a table that has a field called TOI (abbreviation for time on ice). The number is visually set up as minutes and seconds. When I bring this into excel, I am unable to convert this into minutes as it defaults to a date and time. http://www.cbssports.com/nhl/stats/playersort/NHL/GLS/regularseason?_3:col_1=6 Would appreciate knowing how I can reformat this into minutes, with the seconds being converted to a decimal. Ie : 1709.13 would be converted to 1709.217. Thanks. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Match in Rows
Hi, Not sure how to do this. Looking for a formula (preferably) or a macro to find a number in a row. Kind of like a loto checker. In this case. - There are 20 columns per row. (A1 to T1) - Numbers are not neccesarily sorted. - There could possibly be the same number showing up multiple times within the 20 columns being checked. - Would like to be able to enter the number to be checked in cell AA1. - Would like the counter to be returned in cell AB1 if/when a match has been encountered. - Leave blank (not zero) if number is not found. Many Thanks. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Match in Rows
Bang on PERFECT. Thanks very much Viper for the quick accurate response !! On Feb 3, 12:09 am, The Viper viper@gmail.com wrote: in ab1 =if(countif(a1:t1,aa1)0,countif(a1:t1,aa1),) On Fri, Feb 3, 2012 at 10:30 AM, qcan comeonove...@gmail.com wrote: Hi, Not sure how to do this. Looking for a formula (preferably) or a macro to find a number in a row. Kind of like a loto checker. In this case. - There are 20 columns per row. (A1 to T1) - Numbers are not neccesarily sorted. - There could possibly be the same number showing up multiple times within the 20 columns being checked. - Would like to be able to enter the number to be checked in cell AA1. - Would like the counter to be returned in cell AB1 if/when a match has been encountered. - Leave blank (not zero) if number is not found. Many Thanks. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------ To post to this group, send email to excel-macros@googlegroups.com -- *Great day,* *viper*- Hide quoted text - - Show quoted text - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized
Exzcellent guys. Amazing. Thanks. On Jul 28, 8:18 am, XLS S xlst...@gmail.com wrote: Hey Ranjan qcan want if cell contain any 3 Capital letter then color hole cell.but your solution color only first 3 letter ... On Thu, Jul 28, 2011 at 5:32 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hope it will Help you Sub HighLight() Application.ScreenUpdating = False On Error Resume Next Dim cell As Range Dim rng As Range Dim st As String Dim loc As Integer Dim n as string st = Set rng = ActiveSheet.UsedRange For Each cell In rng If cell.Value Then st = st cell.Value End If Next For i = 1 To Len(st) n = Mid(st, i, 1) Mid(st, i + 1, 1) Mid(st, i + 2, 1) If Asc(Mid(n, 1, 1)) 64 And Asc(Mid(n, 1, 1)) 91 And Asc(Mid(n, 2, 1)) 64 And Asc(Mid(n, 2, 1)) 91 And Asc(Mid(n, 3, 1)) 64 And Asc(Mid(n, 3, 1)) 91 Then Cells.Find(What:=n, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate loc = WorksheetFunction.Find(n, ActiveCell.Value, 1) ActiveCell.Characters(loc, 3).Font.ColorIndex = 26 ActiveCell.Characters(loc, 3).Font.Bold = True i = i + 3 End If Next Application.ScreenUpdating = True End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of qcan Sent: Thursday, July 28, 2011 3:40 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized Hi, Can anyone help me with some sort of formula or Macro that would identify any word (minmum 3 letters) that is all in caps. I would like whatever is found to be highlighted in yellow. Thanks. -- ---- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- .- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Reverse Sorting Of Rows
THANK YOU EVERYONE. I am in awe with the knowlege you guys have. WELL DONE ! On Jul 27, 2:25 am, Rajan_Verma rajanverma1...@gmail.com wrote: Try this.. Sub Reverse() Dim fRng As Range Dim Couter As Integer Dim cell As Range Set fRng = Application.InputBox(Please Choose A Range, , , , , , , 8) Set cell = Application.InputBox(Please Choose a Cell for Output, , , , , , , 8) cell.Activate For counter = fRng.Cells.Count To 1 Step -1 ActiveCell.Value = fRng.Cells(counter, 1) ActiveCell.Offset(1, 0).Select Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of XLS S Sent: Wednesday, July 27, 2011 10:01 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Reverse Sorting Of Rows Try this Sub FlipRows() Dim vTop As Variant Dim vEnd As Variant Dim iStart As Integer Dim iEnd As Integer Application.ScreenUpdating = False iStart = 1 iEnd = Selection.Rows.Count Do While iStart iEnd vTop = Selection.Rows(iStart) vEnd = Selection.Rows(iEnd) Selection.Rows(iEnd) = vTop Selection.Rows(iStart) = vEnd iStart = iStart + 1 iEnd = iEnd - 1 Loop Application.ScreenUpdating = True End Sub On Wed, Jul 27, 2011 at 3:38 AM, qcan comeonove...@gmail.com wrote: Hi, A little different request here. I am looking for a way to reverse sort rows: Example: ABC123 ABC493 ABC961 Would become sorted in decending order as: ABC961 ABC123 ABC493 Thanks. -- ---- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel -- . -- ---- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Formula or macro to find a word that is all capitlaized
Hi, Can anyone help me with some sort of formula or Macro that would identify any word (minmum 3 letters) that is all in caps. I would like whatever is found to be highlighted in yellow. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Arbitrage Formula
Hi, I couldn't figure out how to upload or attach the spreadsheet file. However, just copy paste what I have pasted below into excel and it will work and will properly format properly (I tried it - no issues). Take note that there are no formulas. I essentially transcribed the results using another program that I know is correct. I hope this helps. I have included two examples below. Thanks. Example 1A OddsWager Return If Win Profit Pct Profit Side 1 110 $543.48 $1,141.31 $141.31 14.13% Side 2 150 $456.52 $1,141.30 $141.30 14.13% Total $1,000.00 Example 1B OddsWager Return If Win Profit Pct Profit Side 1 -120$576.93 $1,057.69 $57.69 5.77% Side 2 150 $423.07 $1,057.67 $67.67 5.77% Total $1,000.00 Example 2A OddsWager Return If Win Profit Pct Profit Side 1 110 $684.00 $1,436.40 $296.40 26.00% Side 2 150 $456.00 $1,140.00 $0.00 0.00% BREAKEVEN Total $1,140.00 Example 2B OddsWager Return If Win Profit Pct Profit Side 1 -120$636.00 $1,165.98 $105.98 10.00% Side 2 150 $424.00 $1,060.00 $0.00 0.00% BREAKEVEN Total $1,060.00 On May 17, 9:03 am, DILIPandey dilipan...@gmail.com wrote: Hi Qcan, For the better understanding of the group, can you transfer the details in an excel spreadsheet and send the same as an attachment. Thanks, DILIPandey On May 15, 10:45 pm, qcan comeonove...@gmail.com wrote: Hi, I am looking for a couple of formulas that can be used to calculate an arbitrage in sports wagering. Example 1. An even split based on a 1000 dollar total wager divded between both sides. - Side 1 odds = +110 - Side 2 odds = +150 I know that one would have to wager $ 543.48 on side 1, in order to get a return $ 1141.31 I also know that a wager of $ 456.52 on side two in order to get a retrun of $ 1141.30 In other words a 14.13 % profit would be generated evenly no matter which side won. Example 2. The same as example 1 except I want to maximize side 1 while breaking even on side 2. To clarify - this would mean that all the profit would go to side 1 should side 1 win. If side 2 wins - I would break even. Using 1000 dollars again (actually 1140 dollars so that it's even), with the same odds as the first exmaple - I know that - $ 684.00 would have to be wagered on side 1 and $ 456.00 would have to be wagered on side 2. If side 1 wins - I would get back a total of $1436.40 (meaning a $ 296.40 profit) If side 2 wins - I would get back exactly the total money wagered on both sides (1140 dollars) and break even. I have no idea how to express these two examples into a formula. Further, the formula(s) might be different when the favorite is actually below -100. I hope I made some sense. I will try and clarify should there be any questions. Anyone ? Thanks !!- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Arbitrage Formula
Hi, I am looking for a couple of formulas that can be used to calculate an arbitrage in sports wagering. Example 1. An even split based on a 1000 dollar total wager divded between both sides. - Side 1 odds = +110 - Side 2 odds = +150 I know that one would have to wager $ 543.48 on side 1, in order to get a return $ 1141.31 I also know that a wager of $ 456.52 on side two in order to get a retrun of $ 1141.30 In other words a 14.13 % profit would be generated evenly no matter which side won. Example 2. The same as example 1 except I want to maximize side 1 while breaking even on side 2. To clarify - this would mean that all the profit would go to side 1 should side 1 win. If side 2 wins - I would break even. Using 1000 dollars again (actually 1140 dollars so that it's even), with the same odds as the first exmaple - I know that - $ 684.00 would have to be wagered on side 1 and $ 456.00 would have to be wagered on side 2. If side 1 wins - I would get back a total of $1436.40 (meaning a $ 296.40 profit) If side 2 wins - I would get back exactly the total money wagered on both sides (1140 dollars) and break even. I have no idea how to express these two examples into a formula. Further, the formula(s) might be different when the favorite is actually below -100. I hope I made some sense. I will try and clarify should there be any questions. Anyone ? Thanks !! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Run - Copy / Paste - Repeat Macro
Hi, I have this great Monte Carlo Simulation program for blackjack. I am not all that good in VBA, but would like a small macro to run this program, the copy and paste the results to another sheet, then repeat that task again for as many times as I wish. Any takers ? I can forward the spreadsheet to you as I cannot seem to attach it here. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Run - Copy / Paste - Repeat Macro
Yes, you are on the right track. However, I am looking for more of an automated loop with an option to prompt me as to how many repititions to be made. I would probably want to run thousands. After making this request, I noticed that here appears to be something suspiciously wrong with the random generator. This only becomes appearent when running millions of iterations. The total number of hands should be more or less the same from Ace to 9 with the face cards being 4 times this amount. However, after running this maybe a dozen times manually at 10 million iterations, 6 had the fewest amount of hands each time. This cannot be possible. Not sure if you are familiar with randon generators as well or if perhaps someone else could look at the code and see what (if anything) is wrong with the way the numbers are generated. Thanks for the effort - much appreciated. On Apr 6, 11:36 pm, ashish koul koul.ash...@gmail.com wrote: see if it helps On Wed, Apr 6, 2011 at 11:03 PM, RON SMITH comeonove...@gmail.com wrote: Here is the file: On Wed, Apr 6, 2011 at 7:01 AM, qcan comeonove...@gmail.com wrote: Hi, I have this great Monte Carlo Simulation program for blackjack. I am not all that good in VBA, but would like a small macro to run this program, the copy and paste the results to another sheet, then repeat that task again for as many times as I wish. Any takers ? I can forward the spreadsheet to you as I cannot seem to attach it here. Thanks. -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. MonteCarlo(1).xls 153KViewDownload- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Need Macro / Web Querry Help
Hi, Hopefully someone here can help me out. - I am looking to import the first 50 records in of this URL http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1picks=1 - Then I want it to somehow go to the next page and do the same for the next 50 records until it encounters the end. - All data is to be placed below each other in one spreadsheet and saved with it's html hyperlinks preserved. Anyone please ? Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ microsoft windows common controls 2.6.0 (SP6)
Hi Guys, Hopefully spomeone here can help me out, as I am now totally frustrated with this problem. - Purchase new computer - Installed Windows 7 64 bit. - Intsalled both Excel 2003 2007. I have many files that have use macros. I never had a problem running any of them under XP. After debbing one of them, I noticed that I was missing the microsoft windows common controls 2.6.0 (SP6). I read up on it. I followed the instructions and downloaded the necccesary files and put them in their supposedly proper directories. Now it kind of works, but is not returning any data. This macro scrapes a particular webite. Any ideas to fix this siuation would be greatful appreaciated. thks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Need Help
Hi Group, I am not very knowledgable with VBA and would like some help solving a tedious problem. - I would like to copy and past each page contained on this URL into 1 spreadsheet (copy/paste 1st 50, then go to line 51 and do the same for the second 50 etc etc.. http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=5picks=3 - Each page contains 50 records. - Currently there are approximatly 8500 records. Currently the only way I know how to do this is to manually go to each page manually and copy and paste.Obviously, I would prefer something much more automated so that I can keep whatever remaining hair on my head. Many thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe