Search results for query: *

The values are the following FileSizeThreshold="200" DontSendFilesLargerThan="400" Thanks

The values are the following FileSizeThreshold="200" DontSendFilesLargerThan="400" Thanks

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", _...

Sorry for the delay been on annual leave. I do have access to Excel but I am trying to automatic the process by using batch scheduler that runs scripts to extract the required information

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

Thanks that worked

When I try these suggestions it finds nothing Source file looks like this 9865865556 XXXX XXXXX 2005 1 1,372.00 AN 0 REV 0 9865844556 TREVOR XXXXX 2012 1 792.00 GS 0 I want to extract the 1st line as it has the REV but it is extracting the 2nd line as REV is in TREVOR Thanks

The word is surrounded by whitespace I have tried your suggestions but still not working, what happens if the whitespace is a TAB

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

Thank You - can you show me how this can be done?

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

Thanks for the thread - I have come up with the following code Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:\Text.txt", ForReading) strText = objFile.ReadAll objFile.Close strNewText = Replace(strText...

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

Sorry if I didn't explain myself but what you said worked perfectly. Thanks

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