Search results for query: *

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...

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...

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...

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...

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...

I am able to fill the form out the form, but am having a difficult time extracting the output back into an Excel file. I am only looking for Text. http://ssdi.rootsweb.ancestry.com/cgi-bin/ssdi.cgi Can someone give me a start...my general idea is to identify the tags I need such as Name, Last...

I am looking for a solution that would allow me to do the following: Find [.] and replace ['']<--this is intended to be a blank value. I thought I could search for Chr(46) so I wouldn't need to worry about spaces in front or behind the period. I would like the search to be of the entire table...

I need the subject name of the email to reflect a certain cell value,Sheets("Master Appraisal").Range("B65"), rather than the attachment name that goes with the email. Below is the code that I have to email the saved name of the attachment as the subject: Sub Mail_workbook_1() Dim wb As...

When I run it through Komodo I get a Zero (which I believe is a success). However, I get no demonstrated results such as the results from the query... Should I have some sort of print action? or a ;... Your thoughts would be appreciated. #!/usr/bin/perl -w <!--Search Google for...

I cannot get this form to submit without an error page...on the website. Any help? Sub SpeedSearchPhysician_NPIRegistry() Dim IE Set IE = CreateObject("InternetExplorer.application") IE.Visible = True IE.navigate...

I need some help hammering this out.I have posted a comments section with a pseudocode towards the bottom. I am essentially trying to copy and past the research findings on an output sheet. The output could be identified as one of four categories: 1. First Name, Last Name, and address match...

This code use to work fine in the previous verion of IE, but we have recently upgraded to the newest version of IE. All the web pages pull as they should, but the issue is none of the forms our getting filled with the sendkeys command (It doesn't appear the AppActivate is working)...Could it be...

I would like to expand this line of code: If Len(InString) >= 8 Then to a greater number lets say 9, but I would like to have column B continue the current process from column A. As you can imagine with anything over 8 I run out of rows, that is why I need to continue into the adjacent...

What am I missing? I can't seem to run this code. Any help would be appreciated. Option Explicit ' Carraghan, R., Pardalos, P. M.: An exact algorithm for the maximum clique problem. Op. Research Letters 9. (1990) 375-382 ' converted to the weighted case Private level_nodes() As Long...

This code is a snippet of a previous code that I received help on from tek-tips. I recently converted to the newest version of IE which created a few problems. For whatever reason the text from "Address = Range("I11").Text" dumps in the address bar not in the field "address" on the internet form...

I am looking to use Excel to copy the data from one specific folder in Outlook and past in an Excel spreadsheet. A few issues I have a custom form which has been used in Outlook to collect the data (user defined fields). Additionally I am not sure how exactly I would need to use VBA in Excel...

After creating a website in MS Pub 2007 my images are slung everywhere on the published site. They are not positioned as they are in the orginal publication. Can anyone help me uncover why my images appear everywhere (out of position) whether it is previewed or published to the host. Thanks in...

I need to create an if then "save as" function. There are two saves we want: 1. Save As described below in the code - (this works fine) 2. When a revision is noted in worksheet("master appraisal").range (F75) than save save as the following: ThisFile = "Visual Audit_" & " " & Range("B65").Text...

There are a two email contacts that get this report. One is static and the other changes depedning on the outcome. I am trying to reference cell 'Master Appraisal'!F1 to send the report to the email contact which can change. Any help would be appreciated... Sub Mail_workbook_1() Dim wb As...