Search results for query: *

Thanks for your help everyone.

Thank-you so much, that works perfectly. You have been an amazing help. Everyone who has replied to this thread has really helped me along.

Andy, Thanks again. I believe we are a step closer. Now I get Alameda NO. 1025 UKRANIA, SITE OF AGAPIUS HONCHARENKO FARMSTEAD |“Ukraina” is the site of the farm and burial place of the Ukrainian patriot and exiled orthodox priest Agapius Honcharenko (1832 1916) and his wife Albina...

Andy, That works great the only thing is this and I don't know if it is possible to solve it. This is an excerpt of what I get when I run the Macro. NO. 240 MARKLEE'S CABIN SITE |Jacob J. Marklee recorded his land claim of 160 acres on June 23, 1862, in Douglas County, Nevada, but after the...

I start off with .rtf files that are being viewed in Microsoft Word. My macro runs through the file and not only inserts the column names such as COUNTY, DESCR, LOCATION it inserts the character | that allows me to delimit the information into their respective columns in excel. Here is the...

Good Afternoon, I have a macro that is designed to complete processing for all files within a folder. However, the macro fails when it reaches a file called kern.rtf. The error message is Run-time error '5854'(String Parameter too long). In a previous post someone said that there is a 255...

The file name is Kern.rtf. My macro separates the data into COUNTY, NAME, DESCR, LOCATION, NRHP fields. I believe that the problem is occuring within the DESCR because some of these descriptions are long and may actually surpass the 255 character limit. Thank you for your help. gbent

It works, except within my folder I have a file that is returning Run-time error '5854' (String parameter too long). I am not sure what this means and if there is someway to work around it. Any help would be greatly appreciated?

I do need to be able to browse to the folder. Thank you for catching that detail. I really appreciate all the help from everyone. gbent

Thanks, I am using a VBA Macro created in Microsoft Office Word 2003 to process .rtf files that I am viewing in Word. When you write Next i ' ... does that mean I copy and post my VBA macro here again? Thanks Gbent

Good morning, I have a list of sixty files all within one folder. I have a VBA macro to do the necessary processing. However, I would like to find a VBA macro that will allow me to point to the folder have the macro execute for each file. If anyone can steer me in the right direction it...

That works, Thank you very much for your help.

That doesn't seem to insert the value of my variable, My variable is this : myVariable = Split(ActiveDocument.Paragraphs(1).Range, vbCr)(0) I am not sure how to insert the value of variable here. Thanks,

That worked great thanks guys. My next question is how to I insert the variable in this situation. My format is as follows, The text I have goes ^lNO. I would like to replace that with |"Variable"^lNO. I think it should look something like the following but don't know how to script it so it...

Thanks everyone, I'm going to give it a try over the weekend and will let you know how it works out. Thank-you again for your help it is truly appreciated.

The first line of the data reads Litchfield ^p. So would it then be myVariable = ActiveDocument.Litchfield? Thank you

I am allowing word to read it and convert it to a document format that is letting me view it. It is the first line of the word document that I would like to be the variable so when the file New Haven is being viewed the variable is New Haven and then when the Litchfield county file is viewed...

Hi, I am new to VBA language. I have a collection of .rtf files and am working on a word macro with VBA to process the files. I am attempting set up a variable so that it is the first line of the .rtf file which contains the county name in each file. I would then like to populate a column...