Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Append worksheet to another inside a directory
I'm not sure if my first post got in so I'm reposting this, just in case.
I have hundreds of Time Series Excel files inside a file folder. They all have the same headers, number of columns, and same data types (but different number of rows). The files are categorized by their filenames. Example, 0101010A.xlsx is for one time period and 0101010B is for another time period. There are only two categories (A and B) in the entire folder. I need a code that: (1) reads and compares the first 8 characters of the filenames in the directory. If they are the SAME: A) Appends contents of file *B to file *A after the last row of file *A. (Do not append the header from file *B). Thanks for any advice/help. Marilyn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Append worksheet to another inside a directory
You could probably use some of this to get you there.
http://www.rondebruin.nl/copy2.htm HTH, Barb Reinhardt "Marilyn" wrote: I'm not sure if my first post got in so I'm reposting this, just in case. I have hundreds of Time Series Excel files inside a file folder. They all have the same headers, number of columns, and same data types (but different number of rows). The files are categorized by their filenames. Example, 0101010A.xlsx is for one time period and 0101010B is for another time period. There are only two categories (A and B) in the entire folder. I need a code that: (1) reads and compares the first 8 characters of the filenames in the directory. If they are the SAME: A) Appends contents of file *B to file *A after the last row of file *A. (Do not append the header from file *B). Thanks for any advice/help. Marilyn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Append worksheet to another inside a directory
Marilyn
Your example file names have only 7 characters before the "A" and "B". Is this just a typo or did I miss something? Read what Barb gave you and if you need more, post back and I'll work up something for you. HTH Otto "Marilyn" wrote in message ... I'm not sure if my first post got in so I'm reposting this, just in case. I have hundreds of Time Series Excel files inside a file folder. They all have the same headers, number of columns, and same data types (but different number of rows). The files are categorized by their filenames. Example, 0101010A.xlsx is for one time period and 0101010B is for another time period. There are only two categories (A and B) in the entire folder. I need a code that: (1) reads and compares the first 8 characters of the filenames in the directory. If they are the SAME: A) Appends contents of file *B to file *A after the last row of file *A. (Do not append the header from file *B). Thanks for any advice/help. Marilyn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search folder/directory for a phrase inside excel files | Excel Discussion (Misc queries) | |||
append worksheet with data from another | Excel Worksheet Functions | |||
Place a variable inside a directory path | Excel Programming | |||
Append columns to existing worksheet? | Excel Programming | |||
use macro to append records to worksheet | Excel Programming |