Macro expoerting from Notepad to Excel

[DaddyH]

Hi guys, please could you help save me some time.

This is basically what i have:

250 folders (I folder per customer), each with 27 (months of info) notepad files, I need to write a macro which can open each notepad file for each customer then copy and paste the data into a different worksheet in a spreadsheet.

Does anyone have any ideas?

Cheers guys

Nick

[incjourn]

Try something like this (code untested).....

Please Login or Register  to view this content.

You might need to add an extra line of code to add sheets as you go and rename them.
Hope that helps.

[snb]

What happens if you import the notepadfile into the worksheet directly ?
It depends on the structure of the notepad-files whether a conversion is necessary or not.