Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Monitoring Folder Contents
The values are the following FileSizeThreshold="200" DontSendFilesLargerThan="400" Thanks -
Monitoring Folder Contents
The values are the following FileSizeThreshold="200" DontSendFilesLargerThan="400" Thanks -
Monitoring Folder Contents
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", _... -
Script to read Excel & extract data to a text file
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 -
Script to read Excel & extract data to a text file
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... -
Searching for Text and extracting the line to a new text file
Thanks that worked -
Searching for Text and extracting the line to a new text file
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 -
Searching for Text and extracting the line to a new text file
The word is surrounded by whitespace I have tried your suggestions but still not working, what happens if the whitespace is a TAB -
Searching for Text and extracting the line to a new text file
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 =... -
Splitting text files
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... -
Word Mail Merge Includespictures functions
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?- NickC111
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Excel - Extracting cell values into a text or CSV File
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- NickC111
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Script to Convert TAB Delimited File to Fixed Width Format
Thank You - can you show me how this can be done? -
Script to Convert TAB Delimited File to Fixed Width Format
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... -
Sorting Tab Delimiter Text File
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... -
Find & Replace Text
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... -
Find & Replace Text
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? -
Converting XML file to a CSV File
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"... -
Adding Filename to the end of a text string
Sorry if I didn't explain myself but what you said worked perfectly. Thanks -
Adding Filename to the end of a text string
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...
