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?
.