Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










How Can I Merge Two CSV Files


I have two CSV's which are updated on a regular basis.

CSV Master - contains about 23,000 rows at the moment and will continue to grow.

CSV Master - does have a header row

CSV Master has unique (8 digit) numerical ID's in column A so all unique ID's start at "A2"

CSV Master - contains 31 columns ("A through to and including AE") this is a fixed figure.

---- Then I have ---

CSV Extras - generally contains about 200 rows and its unlikely it will ever be more but is contents are different every time it is used.

CSV Extras - does have a header row

CSV Extras has unique (8 digit) numerical ID's in column "A" so all unique ID's start at "A2" and these ID's are a common denominator with both sheets.

CSV Extras - contains 44 columns (last column is AR) which is a fixed figure,

CSV Extras - columns "B up to and including AE" are all intentionally all blank fields.

--- Hope that explains where I am, this is what I need to do ----

I need to be able to look up the ID's (that are in column A in both CSV's) and create a single CSV. In my mind that is a Vlookup of some sort but I can't get it to work

I want to open CSV Master and then, If the ID exists in CSV Extras then fetch all the data in columns "AF to AR" and add it to the CSV Master.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Search CSV Files For Word & Make .xls Files Of Them
I have 22 CSV files. I want to search each of those files for a specific text string (ie: "profile" or "description"). When the macro finds the word in any one of the CSV files I want it to copy that complete csv worksheet and paste it into an excel xls file.

how I can go about doing this. Not also that while vlookup is possible, its very time consuming if i have to do this 50 times over and each time the csv files have different file names. that is why i want to search within a file (each file has its own unique identifying text string)

View Replies!   View Related
Saving Comma Separated .txt Files As .csv Files
I have a large number of .txt files that are comma separated files (but not saved with the .csv extension) that I need to convert to files with the .csv extension.

Is there an easy way to do this for all files in a given folder? Ideally, the files don't even need to be opened as they are are quite large in size (70MB+) and there are a lot of them (500+).

View Replies!   View Related
Want To Be Able To Open Csv Files And Save As Xls Files
I have the code below. It openes all csv files within a folder, then delete rows depending on the value of a cell. Now it needs to save the file as a xls file ....

View Replies!   View Related
Convert Csv Files To Tab Delimited Files
I would like to be able to execute a command line that will convert an Excel csv file to an Excel file that is TAB delimited. In other words, replace the comma delimiter with a TAB delimiter without having to open the file in Excel. I am an inexperienced Excel user

View Replies!   View Related
Macro To Merge Csv To One Master But Limited
I am in need of a macro to merge approx 30 csv files, kept in same directory. Csv files are identical format, have one populated worksheet, 6 columns, no headers. However, number of rows will vary. I would like to merge them to a separate excel workbook, with data stacked to one master sheet. Is it also possible to only bring over rows that have than 0 in column E. I have the following macro to merge however, it merges .xls files and it brings over all rows.


Dim ToBook As String
Dim ToSheet As Worksheet
Dim NumColumns As Integer
Dim ToRow As Long
Dim FromBook As String
Dim FromSheet As Worksheet
Dim FromRow As Long
Dim LastRow As Long........



View Replies!   View Related
CSV Files
If I have a normal Excel file and want to change it to a CSV file compatable with OziExplorer and MapSource mapping software, how can I convert it to a suitable CSV file?


View Replies!   View Related
Merge Many Files Into One
1. I have a master file (master.xls), currently empty

2. I have 80 excels files (all look a like but their worksheet name are different)

3. I would like all the data from these worksheet to be appended to master.xls with a click of button.

4. I tried using some codes from this forum but they did not work.

5. All the source file starts with ums bla bla.xls

View Replies!   View Related
Merge Files ...
I have two files that need to be merged together (file1 & file2). These two files have three columns each. One column on both files is the same. This column is labled "phone number". One file has more lines the other has less.

I would like to make a macro that will check file1 against file2. If it finds a phone number the same it will cut the whole line and append staring in column 4 to same line in file1.

View Replies!   View Related
Reading In CSV Files
I'm using the following code to read in any number of CSV files into a single worksheet and concatenating them together

View Replies!   View Related
Opening CSV Files As Is
I am trying to view a csv file that has string data, some of them like '395E02'. Excel automatically converts this string into an exponential number. Is there any way to stop Excel from performing the conversion so I can read the number as is?

View Replies!   View Related
Multiple Csv Files
I have a question about CSV files...I have to import about 80 csv files into excel as separate sheets in the same workbook. I can only get it to import into its own workbook. Is there a way to import all of them into the same workbook all at once?
Also, I am currently using csv files, but if what I want done can be done with a different file type, it doesn't matter.

View Replies!   View Related
Merge Two Data Files
Right now I need help mergng 2 files:

#1 One is a txt file with emails

#2 the other is a .csv excel file which contains several fields: email, name, address, etc

Basically what I need to do is to create another .csv excel file that contains all the emails in file#1 that are also present in the file #2 plus their corresponding additional fields ( name, address ) etc

View Replies!   View Related
Merge All Files In A Folder
I haven't really been able to find a total solution to an issue I have had for a while and hope someone can help.

I have a series of workbooks that I create from Crystal reports, I want to do the following after clicking a button on a form:-Open up two files in a folder with similar names (IL-BA, IL-BA-19), both have the same headers

Open a Third file, this is my 'Master File' and is in a different location, this has the same headers

Copy from the two files onto 1 sheet on my master file (excluding the headers)
Close the first two files without saving and move them to a 'Done' folder
Save and Close the Master File

Move onto the next set of files in the folder (NE - BA,NE - BA - 19) and do the same again, until all the files in the folder have been completed.

All the files in the folder have different data, so have different headers, but the Master file for each set will always have the same headers, (if that makes sense), but they are specifically named, so cycling through the named files in the folder, merging the two together.

My main problem is that I can't seem to find all the code i need, i can merge the two files, either in different sheets(which i don't want), or with the headers for each file still attached (as i can't seem to find a robust way of removing them).

View Replies!   View Related
Creating CSV Files From Spreadsheet
I am trying to create CSV files from Excel spreadsheet for each tab. But when I convert these CSV files, text in cell is limiting to 255 characters, in otherwords it is getting truncated after 255characters. I am using Excel 2003 version.

And also when convereted these windows CSV files to UNIX csv files using the command "DOS2UNIX", some charaters becoming special characters. For exmaple, I have the actual text as "If AEENDTC ne '' then do; " and is becoming "If AEENDTC ne then do; " Do you have any idea why it is doing this.

View Replies!   View Related
Csv Ranges - Active Files
I am trying to pull a selected range from a series of csv files, and copy them into a specific range in an excel workbook, do some caluclations, and repeat the process. My problem is that after I open the csv file, the program stops and does not pick up the selected range in the csv file. I tried to use a Windows().Activate command on the csv file to ensure that is is picking up the correct workbook , but the bug says teh subscript is out of range...I am sure I am doing something really stupid, and there is a simpler way of writing this but I can't figure it out.

View Replies!   View Related
Open CSV Files By Date
I have a folder with several downloaded payroll files. I want to write a macro in my "excel payroll converter" file which will selects and opens the last file downloaded. (So I can copy and paste it into my payroll converter.)


View Replies!   View Related
Why Does Excel Open Some Files As Csv
I receive excel reports every day. But the last couple of days when downloading the reports I get them as csv. Also older reports I have saved on the hard disk open as csv.

Well, the ones I have saved have are now csv files and I haven't done anything (knowingly) to change them to csv.

View Replies!   View Related
Splitting *.csv Files Into Batches
I have a number of csv files with 30,000 - 60,000 records.

I'm looking for some code which will split them into batches of 250 record batches.

Each file id named FY838A, FY838B, FY838C etc.

I need something which will open the file then copy the first row (Field names), open a new book and paste the headers.

Then cut the first 250 records, rows 2:251 and paste them into the new book.

I then need to save them as a *.csv

All are named BatchFY838A (then B, C, D for each one)

Here's the main bit I can't figure out:

I would like to create a destination folder for each file.

I already have a main folder:
say C:IncompInbox
but when each file is created I need to make a folder for it to sit in:

C:IncompInboxFY838AFY 1
C:IncompInboxFY838AFY 2
C:IncompInboxFY838AFY 3
C:IncompInboxFY838AFY 4

(I need to create the FY838@ folder then the destination ones after that)

Until there are no records left to batch. i.e. the code needs to stop when it's completed the list (each one has a different amount of records)

Additional. Along with this I have 3 Word.doc's which need to be placed in each of the above folders, can I do this at the same time)

The end result is to be 3 Word.doc's and a *.csv file in each folder, this is for a huge Mail Merge which is already coded, so each files content will be 4 documents with exactly the same names.

View Replies!   View Related
Macro To Import From .csv Files
1. I've recorded a macro that imports values from 6 different .csv files at once. The problem is that not all of these files are going exist upon import. Is there a way to tell the macro to only import if the file exists? And to skip if the import of that file if it doesn't exist? Right now the debugger stops the macro because of file not found.

2. I want to press a button on Sheet 1 that copies Sheet 1 into a new Sheet that's named with today's date. E.g. I press the "Archive"-button, the sheet is copied to a new sheet with the name "051308".


View Replies!   View Related
Formatting Not Retained With CSV Files
1. Open notepad file. Type 01. Save it as "Book2.CSV". Close notepad.
2. Open Book2.CSV in excel

You will see that 01 is shown as 1.

I would like to retain 01 in Cell A1. How do I do this in CSV?

I know how to retain formatting in excel but not in CSV. You can do the following in Excel files:

In the cell A1, right click and choose 'Format Cells'. In the Number tab, choose the category as Custom. In the Type on the right hand side, I type in 00. The value 1 in the cell A1 gets converted to 01.

My question:
1. why is this formatting not retained with CSV files?
2. Is there a way to programmatically (macros) to correct this?

View Replies!   View Related
Importing CSV Files In A Worksheet
The Excel 2007 help menu claims that you can open a CSV file directly into a worksheet but I always get all the fields clumped-up into the first column.

After many tribulations I was able to import it through the Data import menu (text).

Could someone explain what I am doing wrong with the first method described above. It appears that the CSV converter is not working properly on my computer.

View Replies!   View Related
Merge Same Column From Multiple Files
I have hundreds and hundreds of excel files. but in every file, there is the same column lets say column D which has all the information I want. In stead of opening hundreds of worksheets and copying and pasting over the data into a new sheet. Is there a code I could write that would open all these files and copy the data from the same colum over into my new sheet? so column D in the first work book will copy to colulm A in the new work book. Then colum D in the second workboko will copy to the new worksheet in column B ect ect ect.


View Replies!   View Related
Convert Worksheets Into Individual .csv Files
Can you please help me enhancing the macro that you created for consolidating multiple workbooks into one. The macro creates worksheets based on the server names, can we create individual csv files as well for individual worksheets of the consolidated workbook?

View Replies!   View Related
Macro To Create CSV Files From Spreadsheet
How do I create VBA macro to create CSV files out of Excel spread sheet for each tab? Right now I am manually opening the spreadsheet and saving each tab as CSV file. But it is taking lot of time if we have lot of tabs.

View Replies!   View Related
CSV Files Open In New File Instance
I regularly process CSV files that are downloaded from various websites. The problem is, for some reason many (but NOT all) downloaded CSV files do not open in "Microsoft Office Excel" and thus, my primary workspace. They instead open in a separate instance of "Excel.exe" which is actually kinda nice because I can treat each separately, move windows around, etc. The problem is, macros that are in my primary workbook, cannot be seen by the secondary instance(s). So while I have created a number of nifty macros to clean up all the data and format it exactly how I want it in the blink of an eye, I can't run them when a file opens in its own instance.

1) How can I force ALL .csv files to open in the primary "Microsoft Office Excel" application? NOTE: Using the normal Windows Explorer "Open With..." function and setting the default application only works for LOCAL files, and does NOT work to control how remotely downloaded .csv files are opened.

2) How can I make it so that macros can be seen between Excel instances - such that when I choose to see macros in "all open workbooks", it will actually see the macros in the open workbook in the other primary Excel instance?

View Replies!   View Related
Automatically Convert Text Files To CSV
I have a lot of .txt files that needed to be converted to .csv file format. Right now I am doing it manually using MS Excel i.e. File > Open. For each file, I need to specify the length of each fields one by one, so it is quite an effort for me.

Is there any way to automate this process using MS Excel or any other existing programs?

View Replies!   View Related
Macro To Convert All Worksheets To Csv Files
1. I need your help in converting all the worksheets in a workbook to CSV format. Is it possible to do that with a macro?

2. I have 20 workbooks, each with 12 worksheets. I need to combine the data in all the workbooks to create a database. As I will not be
able to do that in Excel (due to the row limit), I am thinking of using MS Access.

Therefore I am planning to convert these excel files into CSV files and then use the CSV files to create an MS Access database.

View Replies!   View Related
Save Multiple Sheets As CSV Files
I will have about 20 excel spreadsheets that will need to be run through some data cleansing and validation than each one exported to a csv file (without the column headings on them), and saved as the same file name as the spreadsheet was. If there are errors in the validation process then the one that fails (row) will be copied to an error log spreadsheet. There will be multiple worksheets in the error log workbook (one for each of the spreadsheets which I hope VBA can create). What I am doing so far is creating a loop that will run on all of the spreadsheets located within a folder.

'Procucedure that will run all validation processes and error checking on extracteds spreadsheets

Sub RunCodeOnAllXLSFiles()
Dim i As Integer
Dim wbResults As Workbook
Dim wbCodeBook As Workbook
Application. ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
On Error Resume Next
Set wbCodeBook = ThisWorkbook
With Application.FileSearch
.NewSearch..............................

View Replies!   View Related
Automatically Create Csv Files From Columns
I have an excel worksheet with data from A to T and the numbers of rows may change from use to use. I want to create a button/macro that determines where the data ends and will take the data from two columns, say column A and column D and put it in a new csv file.

In my final product, I would really like to be able to have a set of check boxes that say "Column D", "Column E", ... "Column T" and so if I check TWO boxes, say "Column D" and "Column T" and click create, it will output TWO csv files, one with Column A and Column D and the other with Column A and Column T.

View Replies!   View Related
Merge Same Cell In All Files/Workbooks In Folder
I have a folder named DATAENTRY (consist 90-100 password protected files & it may increase whenever the need arises).

I need to merge A2 to (data in last available row & last available column) of each file in that folder into a single sheet named MERGEDDATA of file named MASTER.XLS.

I got one excellent code to unlock/lock the files automatically without opening the concerned files. This is the Link [url]

& the Code is: ...

View Replies!   View Related
Append Multiple Csv Files Into Master File?
I have about 100 csv files of the same format that I would like to append into a single master file. Order is not important for appending (I can do a column sort later) I can do copying and pasting, but this will take a long time especially because I will creating more master files from completely different CSVs in the future. Is there a faster way to append CSV files?


View Replies!   View Related
Data Import Automation - Multiple Csv Files
-I receive files everyday by email and saved in a folder C:TEST
-each file saved by name Name+daily date
( like: sale_20091214, sale_20091215, sale_20091216 )
-file is in csv/Comma delimiated format
-each file have 7 columns A to G and contain 256 rows
-i only need 7 or 8 rows & only need value in Column 'F'
-the rows i need are going to be same each time
--------------------------------------------------------------------------
I want to save automated data in a file name: MonthlySale located in c:
Fore each ROW data should be saved in new column next to last saved column.
.
Example:
data from file sale_20091214 should be saved in column B,
sale_20091214 should be saved in column C,
sale_20091214 should be saved in column D and onward.

View Replies!   View Related
Convert Thousands Of Files: .csv To .xls Macro
I need to convert thousands of files from .csv to .xls format. Filenames are numbers (1.csv ... 20000.csv). Filenames do not change.

Could just open, Save As, and Close.

Is there a simple way to run a macro once and convert everything? I don't know how to code the macro to open one file, convert, then close, then open the next...

View Replies!   View Related
Load Multiple CSV Files In A Spreadsheet Faster
In my spreadsheet I load 26 CSV files. Each CSV file has 3 columns and 7 rows. It uses the connection query in Excel. It is only relatively slow to refresh the data. To refresh the data, I can press the refresh data button in Excel.

But in practice I use this code every 5 seconds:

View Replies!   View Related
Links To CSV Files, Find And Replace Not Working
I have a large spreadsheet that has links to CSV files. Every month I need to create a new folder and put the CSV files into that folder, all the CSV files from month to month have the same name for each worksheet.

I'm trying to do Find and replace on the Folder name within the links to change say, February to March so I can just add the CSV files for each month and the spreadsheet will link to the new CSV file in the folder.

I have even tried adding all the February CSV's to the March folder so that when I overwrite the CSV's it will update the master spreadsheet, but it keeps asking me where to look for the folder.
Here is an example of a link:

='\FileservermsbilBRANCH REPORTSBM ReportsFebruary[TItemToDispense@40186 Export Dispensed Item Data-00.CSV]TItemToDispense@40186 Export Di'!BM2

As you can see the folder is named February within the link and I need to replace it with March.

View Replies!   View Related
Dynamically Get Data From Many CSV Files Onto Different Sheets Of Workbook
There is a folder which contains some CSV files. These CSV files are updated say every 5 mins. By updations, I mean new data is appended to these CSV files, keeping old ones. Desire:

1. I want to have one master workbook which will have all of the CSV files in the folder as different sheets in the master workbook.
2. The master workbook sheet should be updated as soon as the corresponding CSV is updated.

My Approach:
Get the list of the CSV files from the directory. Open the CSV files, one after one and copy the newer data, by comparing to a marker that is updated after the new data is read.

View Replies!   View Related
Name/address Files Merge&purge Duplicates
I have two name/address lists in separate Excel workbooks. I need to merge and eliminate duplicates by name. One has single name field in format "Lastname, Firstname". The other has a single name field in "normal" format (First and last name). Ultimately I need to end up with two name fields, First and Last, and this I can do.

The problem is in identifying any possible duplicates between the two lists. Why? Because the first list will have names like "Smith, Robert" and occasionally maybe "Smith, Robert J.". The second list will have names like "Dr. Robert J. Smith Jr. PhD", as well as possibly "Robert Smith" or "Dr. Robert Smith".

Using Text-to-Columns will still require a lot of reworking, because the last name won't always be in the same column, depending on whether there's a Dr. or Mr. or middle initial and so forth.

I've looked into the LIKE( ) function which holds some scant hope, but I don't think it will happen for me either.

How I could compare "Robert Smith" to "Robert J. Smith" or "Dr. Robert Smith" or "Dr. Robert J. Smith Jr. Phd"? Imagine all names in column A.


View Replies!   View Related
Import/merge Tab Delimited Text Files
is there any way for a worksheet to import and merge (append) tab delimited files from these directories:

C:TempmergeVdata.txt
C:TempmergeV (2)data.txt
C:TempmergeV (3)data.txt
C:TempmergeV (4)data.txt
C:TempmergeV (5)data.txt

- contents of data.txt have range A1:Pn, where 'n' is last row, different for each file
- found a previous thread very similar to what i wanted, but donno how to edit this to suit my purpose
[Solved] Importing: Import many TXT files to singe workshee

BTW, does VBA recognise directory folder with unicode characters? I can rename my directory if it doesn't.

View Replies!   View Related
Macro- List Of CSV Files In A Folder Called Balances
creating a macro, I have a list of CSV files in a folder called balances, i need a macro that will look into each CSV file and grab all p'folios which have a negative balance in Col D and line them up as per example shown below. The extracted data needs to be copied to file named "Workings" S:RecsalancesWorkings

All data in CSV file looks like this, where header row is row 1 starting at A1

CSV data

CSV filenames all start with ddmm so e.g. 0111

End DatePfolioA/c CodeA/c Native at End1/11/20081GRVMAAUDCUST 1/11/2008AFSBGEAUDCUST 1/11/2008AFSMBEAUDCUST 1/11/2008AFSPEEAUDCUST 1/11/2008AFSTRNAUDCUST 1/11/2008AMPFSVAUDCUST 16,565,587.811/11/2008GIORIQAUDCUST 155,642.251/11/2008GIORISAUDCUST 1/11/2008PINESIAUDCUST 5,654,632.861/11/2008WACCGIAUDCUST 7,457.561/11/2008WCTARIAUDCUST -3,923.721/11/2008WCTARWAUDCUST 1/11/2008WCTASIAUDCUST -73,456.201/11/2008WCTBGFAUDCUST 1,662.651/11/2008WCTDAIAUDCUST 1/11/2008WCTFUNAUDCUST 27,665,698.291/11/2008WCTGMIAUDCUST 31.251/11/2008WCTROWAUDCUST 6.961/11/2008WCTTHSAUDCUST 22,030.01

Macro to line up data as per below

P'folioDateWCTARIWCTASIWSTFDGWTDTADWTFFI3WTGTFAWTRLGD1/11/2008-3,923.72-73,456.20-4.18-136,496.19-562,967.29-2,319.40-15.762/11/2008-3,923.72-73,456.20-4.18-136,496.19-562,967.29

View Replies!   View Related
Split Data In Multiple CSV Files Based On Condition
I have a few CSV files that sits in a folder ie C:/Data and I want to split the data in those files into different sheets. Each of those files contains rows of data with an account number. For example, I have 3 files that contains transactions and they have accounts "Orange", Apple, pear, I want to put all transations with account apple together and all Orange transaction together etc etc.

View Replies!   View Related
Macros To Clean, Summarize, And Merge Reaction Time Data Files
I need to use to prepare for analysis a large set of individual participants' Excel data files collected using a psychological reaction-time experiment (a modified Stroop task). This experiment was created using a program called Superlab by Cedrus, so I posted an inquiry at the Superlab forum [url]. Their tech support suggested I might need to use macros in Excel but couldn't offer further assistance. I'll try to briefly describe (a) our Stroop task, (b) the operations I'm trying to carry out, and (c) the format of the individual Excel files,

Our Stroop task: The participant gets some instructions and practice trials, then a series of stimulus words are presented one word at a time in the center of a computer monitor in one of several colors. Word presentation order is randomized for each participant. The participant must press a key corresponding to the color of each word as quickly as possible. For each keypress (including the spacebar, pressed on instructions screens), the reaction time (in msec) is recorded in their Excel spreadsheet under the 'Reaction Time' variable. The 'Error Code' variable indicates whether the participant pressed the correct (C) or incorrect (E) color key in each trial. There are 8 types of words for a total of 48 trials. (Actually, 4 sets of emotion words and 4 sets of control-animal words, each set composed of 6 words each. The task basically measures how much peoples attention is captured by emotionally relevant cues in the environment.)

For each participant's data, I need an efficient way (macros?) to:
(1) clean it [i.e. discard or ignore the instruction & practice trials as well as trials where the participant was too impulsive (reaction time < 100 msec), too distracted (rt > 3000 msec), or gave the wrong color response (Error Code= E)]
(2) determine whether enough valid trials remain for further analysis (>39 trials), and if so:
(3) calculate a mean reaction time score for each of the 8 word types [where denominator for each word type is based on # remaining (non-discarded) trials for that word type]
(4) merge each participant's summarized data as single rows in a common spreadsheet (for importation and further analyses in SPSS), like this:
---------------------------
ID#...... MeanRTW1.......MeanRTW2...... (etc. for word types 3-8)
101.......1056................2013...............
102.......2148................2594...............
103...
---------------------------

Excel File Format: I've attached a sample file, and here's a simplified overview of a spreadsheet (irrelevant columns and some rows removed). First the ID number is recorded (e.g., 393E), then some unnecessary junk (exp name & date, intro, practice, instructions), then data for the 48 actual trials of interest:
-------------------------------------------
........A...............B..................C.................D............
1 393E
2 stroop.xpt
3 Wed Jan 1, 12:33:00 2008
4
5
6 Trial Name.....Trial No..... Error Code.....ReactionTime
7 introduction..... 1................C............561243
8 practice.......... 2................C............... 2062
9 red-worried........14.............C................1001 (*the first practice trial)
10 (9 more practice trial rows, deleted here)
19 instructions........3..............C................5000
20 red-chicken......19..............E............... 1205
21 blue-tense.......32...............C.................782
* (46 more actual trial rows, deleted here)
--------------------------------------------------

To clarify:
-The variable 'Trial Name' indicates nominally what stimulus was presented for each trial.
-The variable 'Trial No.', indicates the unique numerical marker for each stimulus word. (It probably should have been labeled 'Word Type'. It doesn't reflect the order of stimulus presentation. E.g., the word "tense" is always 'Trial No.' 32 for all participants, regardless of when it presents.)
-A subset of actual trial words (e.g., worried) were also used for the 10 practice trials. Thus, the 10 practice trials must first somehow be discarded or flagged to be ignored before calculating average reaction times for the remaining 48 actual trials.

View Replies!   View Related
Search For & Merge List Of Text Files Named In Worksheet And Paste In A Specifc Cell
I did a search for " import text" and found some promising leads, but not exactly what I was looking for. I have tried running macros and looking at the code but don't know how to pass the file names from the the D47:D147 range to VBA(see below). I saw elsewhere that Excel can be told to create a temporary batch file, and that the batch file with the command "copy text1.txt+text2.txt+text3.txt all.txt" for example could be used to merge the 3 text files into a file called all.txt. I don't however know how specify the path where copy starts, to tell the batch file to look in subdirectories or to pass the file into Excel. I've posted this question yesterday to Yahoo Answers http://tinyurl.com/omers and http://tinyurl.com/rfww9 without much luck.

Below is the macro I would like:I have text files whose names are found in the range D47:D147 although without the appended ".txt" extension. The sheets can only contain one name sometimes, but on average 8 to 10, so in the average case only cells D47:D56 would have entries.The text files are found in the say H:Textfiles directory or subdirectories.I would like Excel to find these files, concatenate them with a row between each file, and paste the results into cell K251.Finally, the text import wizard should be used with a space as a delimiter and the last 3 columns (it's sometimes only 2) of the concatenated file, not imported.

View Replies!   View Related
Data Load (search And Load .csv Files Automatically In Workbook)
I need to do a macro that will open a search window, the user would select a folder and it will search for a .csv file within it. Then after locating the file, it would automatically load it into a specific sheet in the workbook.

View Replies!   View Related
Merge Files? (add Data From One Spreadsheet To The Appropriate Places On Another Spreadsheet)
Often I need to add data from one spreadsheet to the appropriate places on another spreadsheet. For example:

Sheet A has 10,000 records with these fields: id#, name, address, place of employment.

Sheet B has 5,000 records these fields: id#, GPA, college major, type of degree.

Some of the records in B contain information for the same id#'s as sheet A. I want to add this information together so that a Sheet C will have these fields: id#, name, address, place of employment, GPA, college major, type of degree.

View Replies!   View Related
Csv - Text To Columns Change Back To Csv
I have a csv file which I opened in excel file then i converted the csv to excel columns format using the text to columns delimited.

Now I need to change it back to its original form which is the csv.

View Replies!   View Related
Add Another Worksheet & Continue Importing The Html Files Until There Are No More Files To Import
I'm using the following code to import thousands of html files into my spreadsheet. The code is working fine. Since I am importing thousands of files, when there is no more space on my worksheet, the code stops with an error message. I want to make this code add another worksheet & continue importing the html files until there are no more files to import.

Sub Master_Importer()
Dim I As Long
Dim strFilename As String
Dim strPath As String
strPath = "file:///C:/Documents and Settings/c/Desktop/New Folder/"
With Application.FileSearch
.LookIn = "C:Documents and SettingscDesktopNew Folder"
.FileType = msoFileTypeAllFiles
.Execute
For I = 1 To .FoundFiles.Count
strFilename = Mid(.FoundFiles(I), InStrRev(.FoundFiles(I), "") + 1)
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & strPath & strFilename _ .......................

View Replies!   View Related
Transfering Files From Lots Of Files To One Single Exel Master File.
Need a way to update a single master file. What happens right now is that the cost manager sends out one file to a lot of different project heads and then on having them return back to him he basically has to individually add in all the data. What i am trying to do is that he somehow carries on sending out the data as there are a lottt of projects and then on returning them they automatically update.


View Replies!   View Related
Open Files In Folder- Wait 30 Seconds Then Close The Files
I want to allow users to place files (.jpg, .tif, .pdf, .pps etc) into a network folder and then have my program open each file and display it for 30 seconds then close the file and the application before opening the next file.

1. Set up a loop to get a directory listing of the folder and write the listing to a text file.

2. Open up the text file and get the next filename in it

3. Open the file in the associated application

4. Wait for 30 seconds (or some period of time) and then close the file

5. Repeat steps 2-4

DoIt = 1
While DoIt = 1
Open "C:TempList.txt" for output as #1
Print #1, Files In Folder
Close #1

Open "C:TempList.txt" for input as #2
while not eof(2)
Line input #2, MyFile
Display MyFile on screen
Wait for 30 seconds
Close MyFile and MyApplication that opened it
wend
Close #2

I can get the directory listing just fine with no problems

I can open the files in the associated application just fine with no problems.

with closing the application after 30 seconds or some period of time.

I need some code that will allow me to easily send it a filename and it will know how to close the file and the application that opened it.

View Replies!   View Related
Files Saved To Program Files Folder, Open As Read Only
I have an Excel application (Excel 2003) which is stored in the default Program Files folder by the Installer; for example: c:program fileszxchello.xls. The problem I am running into is this file opens as Read Only in Vista and this is interfering with the running of the application. There is no problem opening the file normally in Windows XP.

I have been able to narrow down the cause of this to the User Account Control system in Vista - if I turn OFF User Account Control, the Excel file opens normally and my application functions normally. Is there another option to open the Excel file without turning OFF User Account Control because some users may find it unacceptable to turn OFF this security feature. Ofcourse, one option is to install the application in another location, outside the Program Folder, and the file would open normally, but the Packaging Wizard that I am using to package the application does not allow me to install the application in any other location and thus, the application installs in the Program Folder and I am running into this problem of the Exel file opening as Read Only. Is there a way out of this situation where I can open the file normally (not as Read Only)?

View Replies!   View Related
Save Ranges In Multiple Files To Text Files
I have a excel file that I enter information into. I have code that saves the files to a certain folder with the name, date, and time stamp for the file name. At the end of the day I might have 3 to 15 excel files I have created that day and I would like to take information from certain cells (examle: L3, B6, B7, B8, G8, and so on) and create a txt file with all of the information in it.

Example:
12/20/2007
Your Name
123 Somewhere St.
Here, OH 45111
Home Visit

12/20/2007
Someone Else
345 Anywhere St.
There, OH 45211
Hospital Visit

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved