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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Get formatted text from embedded browser?
I have embedded a webbrowser into my Excel XP document, and have created the appropriate Home, back, forward, etc buttons to control it. It works nicely. However, I am having problems getting the formated text from the web page into my Excel sheet. I would like for it to automatically paste...- TimMyth
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Need help with Arrays in Excel
While x <= UBound(NewList) ' While we still have elements in NewList Randomize ' Initializes Rnd so we don't get the same number Position = Int(UBound(NewList) * Rnd) ' Get a random number If NextNewList(Position) <> "" Then GoTo GetNewNumber: ' Make sure we're not using an...- TimMyth
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Need help with Arrays in Excel
The easiest way would be to create a second array and place the elements from NewList into the second array in a random order. If the first array has duplicate names, then sort NewList first and do a check on each element to see if it matches the previous element before you randomly place it in...- TimMyth
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using VB to search the web?
My issue is along similar lines. I have embedded a webbrowser into my Excel XP document, and have created the appropriate Home, back, forward, etc buttons to control it. It works nicely. However, I am having problems getting the formated text from the web page into my Excel sheet. I would...- TimMyth
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
