Search results for query: *

Thanks guys... All these answers where great and really challenged me to think how I had set things up.

I am trying to help a non-technical user once the database is deployed. Thank you for your question.

Objective: I want to be able to assign initials to records in an alternating method until I run out of records. For example, I have 451 records I would like to do the following: 1.TP 2.DM 3.PW 4.TP 5.DM ... 451.TP Thanks in advance for any advice. Sub SOSAssign() Dim dbs As Database Dim rst...

Feherke: Thanks again...wonderful information.

Excellent, Feherke. I appreciate your knowledge and the fact that you took the time to educate me a bit more... I hope we cross paths again. Any references you could post to address the TODO list you created for me would be might helpful... Best of luck!

Feherke: I am running into StopIteration, line 45 If I go with this option in the command prompt: Crawler.py -o writehere.txt http://tek-tips.com/ Is the below what you are suggesting: ##feherke begining code import sys import getopt outfile='-' opt,arg=getopt.getopt(sys.argv[1:],'o:')...

Need help with printing the results to a *.txt file. Would I need to use the writelines() method? or Would I need to use the f.write(string) method? any help would be appreciate... #================================# #File Name: Crawler.py #Description: Spider with html...

My objective: to move through a range of IDs, pull the HTML down, and convert it to plain text. Below is the actual link: http://www.albme.org/index.cfm?fuseaction=app.LicenseeDetails2&ID=86699 An example range: 86650 - 87000 Below is the actual code to pull down the requested data: import...

Justin: Touchdown...I was a day late and a dollar short. Your code worked wonderfully: import sys, urllib from StringIO import StringIO import html2text if __name__ == '__main__': url = 'http://www.fsmb.org' encoding = 'utf-8' f = urllib.urlopen(url) try: s = f.read()...

This is what I went with (this is a snippet of the whole): if __name__ == "__main__": baseurl = 'http://www.fsmb.org' if sys.argv[1:]: arg = sys.argv[1] if arg.startswith('http://'): baseurl = arg j = urllib.urlopen(baseurl) try...

JustinEzequiel: Thanks for the response. I have downloaded the HTML2Text.py when I run it a GUI window pops up with the phrase, PYTHONWIN. My only options are to fill it out (with what I don't know), select OK, or select CANCEL. Any ideas?

This works well in pulling down the HTML/Text from the requested page: # -*- coding: utf-8 -*- # Python from urllib import urlopen print urlopen('http://www.fsmb.org').read() However, I need help converting the print urlopen().read output to plain text rather than HTML/Text. Your help is...

This is complete: http://www.mrexcel.com/forum/showthread.php?p=2301935&posted=1#post2301935 Thanks for your help.

Skip: I actually am able to get different results by changing the line: Extract_HTML_Table .document, 5, Sheet1.Range("A1").Offset **by replacing the number 5 with any numbers 1 - 4. Is there away to pull down multiple HTML tables instead of individually? 1 = schooling 2 = location 3 =...

My objective: I want to be able to place a first and last name combination into code (in this example Alison Smith) and see if the person is recognized by the site. If "yes", I want to download the information to the active spreadsheet. If "no", then what ever the result (i.e. nothing found...

Thanks Skip...just what I needed. When I have run similar code in the past I have an experienced an error 6 overstack...almost always on the line: "For i = 1 To 4301" NOTE: Your solution works perfectly, so I am not interested in tweaking your solution. I'm curious if you think the previous...

Object: to connect to the below URL, loop through number 1 - 4301, and copy the important elements to an active worksheet in Excel. Below is the recorded macro for #4301. I need help with figuring out to automate the numbering of ".name=" and modify the ending of the "URL". The other item I...

O.k. guys this is what I got... I am getting the results to show on the web page, but it is still not importing back into a spreadsheet... Any ideas...? Sub SSI_MAcRO() ' ' SSI_MAcRO Macro ' '_PULL UP FORM Dim Ie Set Ie = CreateObject("InternetExplorer.application") Ie.Visible =...

I performed both step 1 and 2... and then I receieved an error message...stating the web query returned no data.

I receieved an error message "The web query returned no data...". Any ideas?