bmadaiwty
06-27-2008, 01:37 PM
Hello,
I have a text file (attached) which I need to import to Excel.
After importing - I need to exract the figures from the file, and then link them to a template which I use for various calculations.
The txt file is always the same.
Last year (Aug 2007), RonMcK published a solution for a simmilar challenge
I tried it but it does not seem to the the job. I meen the macro is doing something but the output file is empty...
Any idea how to make this happen?
Without such a solution, I will be forced to punch in a data mannually into the template (and this is something I need to do every week ):(
Any help will be highly appreciated
I have a text file (attached) which I need to import to Excel.
After importing - I need to exract the figures from the file, and then link them to a template which I use for various calculations.
The txt file is always the same.
Last year (Aug 2007), RonMcK published a solution for a simmilar challenge
I tried it but it does not seem to the the job. I meen the macro is doing something but the output file is empty...
Any idea how to make this happen?
Without such a solution, I will be forced to punch in a data mannually into the template (and this is something I need to do every week ):(
Any help will be highly appreciated