| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collating multiple .csv files into a single work book
Im trying to collate three differently formatted .csv files into one
workbook. But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. I dont know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. am forced to leave the source files as .csv 100. A.N. other reason. Any suggestions on how to resolve this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
To clarify slightly, I need the three .csv files to appear as seperate
worksheets within the master doc, rather than combining all three into one big sheet "Mr_Wilf" wrote: Im trying to collate three differently formatted .csv files into one workbook. But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. I dont know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. am forced to leave the source files as .csv 100. A.N. other reason. Any suggestions on how to resolve this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
You can record a macro while you go through the procedure once, i.e.
open each file in turn and format the sheet how you want it to appear, then move the sheet into the Master file. Then you can repeat the macro whenever you need to. If your file names vary (eg date-stamped) then you will need to edit the macro to enable you to select the appropriate file. Hope this helps. Pete On Nov 4, 10:31*am, Mr_Wilf wrote: To clarify slightly, I need the three .csv files to appear as seperate worksheets within the master doc, rather than combining all three into one big sheet "Mr_Wilf" wrote: I’m trying to collate three differently formatted .csv files into one workbook. *But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. *I don’t know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. *am forced to leave the source files as .csv 100. *A.N. other reason. Any suggestions on how to resolve this?- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
Cheers Pete, worked well!
"Pete_UK" wrote: You can record a macro while you go through the procedure once, i.e. open each file in turn and format the sheet how you want it to appear, then move the sheet into the Master file. Then you can repeat the macro whenever you need to. If your file names vary (eg date-stamped) then you will need to edit the macro to enable you to select the appropriate file. Hope this helps. Pete On Nov 4, 10:31 am, Mr_Wilf wrote: To clarify slightly, I need the three .csv files to appear as seperate worksheets within the master doc, rather than combining all three into one big sheet "Mr_Wilf" wrote: Im trying to collate three differently formatted .csv files into one workbook. But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. I dont know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. am forced to leave the source files as .csv 100. A.N. other reason. Any suggestions on how to resolve this?- Hide quoted text - - Show quoted text - . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
That's good to hear - thanks for feeding back.
Pete On Nov 5, 11:36*am, Mr_Wilf wrote: Cheers Pete, worked well! "Pete_UK" wrote: You can record a macro while you go through the procedure once, i.e. open each file in turn and format the sheet how you want it to appear, then move the sheet into the Master file. Then you can repeat the macro whenever you need to. If your file names vary (eg date-stamped) then you will need to edit the macro to enable you to select the appropriate file. Hope this helps. Pete On Nov 4, 10:31 am, Mr_Wilf wrote: To clarify slightly, I need the three .csv files to appear as seperate worksheets within the master doc, rather than combining all three into one big sheet "Mr_Wilf" wrote: I’m trying to collate three differently formatted .csv files into one workbook. *But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. *I don’t know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. *am forced to leave the source files as .csv 100. *A.N. other reason. Any suggestions on how to resolve this?- Hide quoted text - - Show quoted text - .- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
Hi Mr_Wilf
See http://www.rondebruin.nl/txtcsv.htm Mr_Ron -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr_Wilf" wrote in message ... Im trying to collate three differently formatted .csv files into one workbook. But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. I dont know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. am forced to leave the source files as .csv 100. A.N. other reason. Any suggestions on how to resolve this? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
Cheers Ron - I'll give that a work through and see what comes out.
"Ron de Bruin" wrote: Hi Mr_Wilf See http://www.rondebruin.nl/txtcsv.htm Mr_Ron -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr_Wilf" wrote in message ... Im trying to collate three differently formatted .csv files into one workbook. But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. I dont know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. am forced to leave the source files as .csv 100. A.N. other reason. Any suggestions on how to resolve this? . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
Hi Ron,
A good guide but think it will be overkill for what I need so done the simple route this time. Thanks for the reply though! "Ron de Bruin" wrote: Hi Mr_Wilf See http://www.rondebruin.nl/txtcsv.htm Mr_Ron -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr_Wilf" wrote in message ... Im trying to collate three differently formatted .csv files into one workbook. But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. I dont know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. am forced to leave the source files as .csv 100. A.N. other reason. Any suggestions on how to resolve this? . |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
Ron,
Tried using this for another task and after I've selected four files I end up with the original workbook, two empty workbooks with one sheet each and a final book with one of th efiles in it correctly. I've just copied the macro for the multiple .csv files into a workbook module and changed one bit - default lookup folder. Any suggestions where I've mucked up? "Ron de Bruin" wrote: Hi Mr_Wilf See http://www.rondebruin.nl/txtcsv.htm Mr_Ron -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr_Wilf" wrote in message ... Im trying to collate three differently formatted .csv files into one workbook. But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. I dont know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. am forced to leave the source files as .csv 100. A.N. other reason. Any suggestions on how to resolve this? . |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collating multiple .csv files into a single work book
If you want you can send me your test workbook and a few of your
csv files and i look at it for you. You find my mail address on my site http://www.rondebruin.nl/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr_Wilf" wrote in message ... Ron, Tried using this for another task and after I've selected four files I end up with the original workbook, two empty workbooks with one sheet each and a final book with one of th efiles in it correctly. I've just copied the macro for the multiple .csv files into a workbook module and changed one bit - default lookup folder. Any suggestions where I've mucked up? "Ron de Bruin" wrote: Hi Mr_Wilf See http://www.rondebruin.nl/txtcsv.htm Mr_Ron -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr_Wilf" wrote in message ... Im trying to collate three differently formatted .csv files into one workbook. But in order to get the latest data in my master document I still have to open the three source files which sort of spoils the point of the master doc. I dont know if this is because: 1. I have set the book up wrongly b. I have stored the source files in the wrong place iii. am forced to leave the source files as .csv 100. A.N. other reason. Any suggestions on how to resolve this? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bring different .csv files in to one single Excel work book | Excel Discussion (Misc queries) | |||
| Collating a set of separate excel files into a single worksheet or | Excel Discussion (Misc queries) | |||
| linking multiple books (source.xls) to a single book (destination. | Excel Discussion (Misc queries) | |||
| update multiple worksheet in single book | Excel Worksheet Functions | |||
| How to insert pdf files into Excel work book. | Excel Discussion (Misc queries) | |||
![Mr_Wilf[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
