Search results for query: *

Good Morning I have been using the following code on checking a folder contents and emailing the results to a particular email Dim blnAttachFiles, iDontSendFilesLargerThan, sMessage Const ForReading = 1 Const cdoSendUsingMethod = "http://schemas.microsoft.com/cdo/configuration/sendusing", _...

I have a Excel spreadsheet that has several worksheets with headers in row 1 and then data on every line I would like to know if there is a way that I could use a script to the read the worksheet and extract the data to a text file. Each row in the worksheet would have a new line. Example...

I am using the following script to search for a word and where it finds that word it extracts the text on that particular line into a new text file. [' Writing Data to a Text File Const ForReading = 1 Dim words(1) Dim msg words(0) = "REV" Set objFSO =...

Good Afternoon I have a text file that looks like this 05/12/0015LB Standard Text CONDITIONAL APPROVAL 08/12/0010 Raw Date CONDITIONAL APPROVAL 52/12/0012LB Max Data CONDITIONAL APPROVAL 13/12/0005 Standard REFUSAL 13/12/0007 Data Feed CONDITIONAL APPROVAL I want to be able to create...

I have a mail merge word document where I want to insert a image for multiple records I am using the function {INCLUDEPICTURE "PATH" \* mergeformat \d} The image displays fine in word but the problem I have is that the image has 2 pages to display. How can you display the other page of the image?

Good Morning I would like to extract cell values from an excel spreadsheet into a text or CSV file. I was thinking of using a macro to do this job then using a vbs script to run the macro from a dos command. Any hints or tips would be great Thanks Nick

I have an export file that is created in TAB delimited format. Record example below: 8000004449 5910.00 0.00 5910.00 XX 2012 1 5594.90 315.10 Extract 8000006341 6732.00 0.00 6732.00 XX 2012 1 6372.93 359.07 Extract 8000009894 5082.00 0.00 5082.00 XX 2012 1 4810.86 271.14 Extract 8000018985...

Good Afternoon I am looking for some help with a script I am trying to develop I have a text file that I want to join & sort by the 1st column Example 100086984 5806120156 84.98 01/05/2012 95.31 07/05/2012 10/08/2012 101637184 0416540170 93.15 01/09/2011 130.00 28/05/2012 106887584...

Good Afternoon I have a simple text document where I want to find and replace certain text. **0915750600*CW3*STORE AND PREMISES* I want to use find and replace - Find CW3 and replace with 970 - write a new file with the new changes Any ideas?

I have a XML file thats needs to be converted into a CSV file XML looks like this - <data QueryName="workflow"> - <DataSet DataSetName="workflow"> - <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"...

I have a basic script that compares two text files and writes a new file with the difference on a new line. I want to be able to add the filename to the end of each line but I need some help Code[Set fso=CreateObject("Scripting.FileSystemObject") Set...

I have a basic CSV file containing lines of data but I have unwanted commas in the file and I want to delete them Example 7678676,04,07/10/2012 545545,12,06/12/2012 ,, ,, 5545435,44,01/01/2011 ,, 43434,05,12/12/2012 I want to delete the double commas in the file

Good Afternoon I have a basic text file that contains rows of numbers, an example below. 700025658455 700025456633 700056656565 700354545441 700255656565 There is no limit on the amount of rows contained in the text file. I want to create a script that will randomly pick 10 numbers from the...

I have a tab delimited text file that needs to be sorted by the 1st reference. Example Text File 7001712282 09/02/2010 NOTES1 7001712282 21/06/2010 NOTES2 7001712282 16/02/2011 NOTES3 7001712282 25/08/2011 NOTES4 7001750271 16/02/2011 NOTES1 7001750271 26/05/2011 NOTES2 7001750271 25/08/2011...

I have a text file with an email address Example From: t.test@hotmail.co.uk 454445454545454 I want to extract the email address into a new text file Any ideas?

Good Afternoon I have an delimiter text file using the '|' and I want to sum the numbers in the fifth column. Save the results to a new text file. Example 0|21212131|TEST|19/12/2010|56.89|17/12/2010 0|21212131|TEST|12/12/2010|75.00|17/12/2010 0|21212131|TEST|11/01/2010|156.89|17/12/2010...

Good Morning I would like some help with a procedure I would to do with a CSV File. The CSV file has 4 Columns with rows of data - Example Below Reference Cell Value Type 100007284 94 542.8 AN 100017475 94 393.6 RS 100046684 94 657.44 AN 100066577 94 601.96 AN 100086984 94 370.28...

Good Afternoon I have a simple excel spreadsheet with data entered in Cells A1 to E15. I want to write a VBS script that will extract the data from cells A1 to E15 into a text file separated by a comma. Regards

Good Morning I have this script below that compares FILE1 and FILE2 - any differences are written to the results.txt. The only problem I have is if a new entry is added to FILE2 then the script doesn't write the new entry to the results. It only works if an entry is missing from FILE2...

Good Morning I would some help with a CSV File, the file has three columns and over 10000 rows. The first column is a claim number, second is a cell number and the third column is a value. I want to be able to group the data by claim number but the claim number may appear more than once. If...