Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro reading excel file
Hi,
I have about 1900 excel files each with two rows of text: one is simply the names of the columns and the other is the actual data. The column headings are the same for the 1900 files, but obviously the data in each file corresponds to a different patient. My task is to combine all 1900 rows of data into one excel sheet. This can be done with copying&pasting but I think there is a faster way using macros. I am new to excel and macros but a friend said there may be a way. Since the columns are the same across all the files, shouldn't this be relatively easy to do? I know some programming but I haven't ever needed to access files saved on the computer. Thank you for the help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro reading excel file
Hi http://www.rondebruin.nl/ado.htm
See http://www.rondebruin.nl/copy3.htm Try the ADO code for so many files http://www.rondebruin.nl/ado.htm -- Regards Ron De Bruin http://www.rondebruin.nl "HJP84" wrote in message ... Hi, I have about 1900 excel files each with two rows of text: one is simply the names of the columns and the other is the actual data. The column headings are the same for the 1900 files, but obviously the data in each file corresponds to a different patient. My task is to combine all 1900 rows of data into one excel sheet. This can be done with copying&pasting but I think there is a faster way using macros. I am new to excel and macros but a friend said there may be a way. Since the columns are the same across all the files, shouldn't this be relatively easy to do? I know some programming but I haven't ever needed to access files saved on the computer. Thank you for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro for reading text file into Excel | Excel Discussion (Misc queries) | |||
Reading File Name in VB Macro that contains today's date | Excel Discussion (Misc queries) | |||
reading from text file to excel file | Excel Programming | |||
Reading CSV file from Excel (VBA) | Excel Programming | |||
Reading an excel file in SPSS | Excel Programming |