bulk convert strange file format in multiple folders.

Hi Guys,

I have a series of files in *.ew7 format (i know its a random program)

I have some code which i can run which will simply open the relevant file and save it as xls.

The files are saved in multiple folders in format "yymm" eg: 0910 - oct 09.

inside each folder there is a ew7 file for each day in rthe format: "01ddmmyy" eg 01271009 = 27th oct 2009.

I have folders going back as far as may 2002 (in folder 0205) and i need a way to convert these all into xls format and save them in the same location.

Please Login or Register  to view this content.

This is the code im currently using but this will only conver the date currently being looked at (ie: today) is there a way i can run a macro which will do this for all historical files?

many thanks

Oops, wrong post.

Do you have a couple ew7 files you can attach for testing?

Originally Posted by freud1

hi rick, thanks for getting back to me,

unfortunately ew7 files cannot be uploaded here.

the code i uploaded works perfectly to convert the file for today, i just need to know how to loop it and increment the values so it saves the correct names to the correct files.

Sure you can, put a couple in a ZIP file, 9.7mb limit. Strip the files down to a few rows/cols, I only need to work with samples.

Let me get this straight now.
You only need to convert one file at a time but it might be in different folders?

Our firewall blocks ALL file sharing services.
Rapidshare is definately a file sharing service.

I only ask about a sample file to ensure what I attempt is right.

Briefly explain the structure here.

Please Login or Register  to view this content.

Will "strPath" always be the path?
Will "strFile" always be this value?
What is the significance of the text "01" in strPath and "01" in strFile?
The above creates a folder\file structure of:

C:\EW_32b\CSV\01\0910\01281009.ew7

Is this correct? (for this example).

I am setting up a folder structure to mimic yours.

Here is a workbook and macro to TEST. Please test this on samples first.
I have the macro setup to run from a small list of folders on Sheet(3) from Drive "D:".
I then placed three sample files in two of the five listed folders. Sample files included in ZIP file (Copies of your files) and are for folders 0909 and 0910. (It really wont matter since the macro searches for an "ew7" file in each folder).

D:\EW_32b\CSV\01\0908
D:\EW_32b\CSV\01\0909
D:\EW_32b\CSV\01\0910
D:\EW_32b\CSV\01\0911
D:\EW_32b\CSV\01\0912

When you are ready to convert the files simply change one character in the macro.

Please Login or Register  to view this content.

Change "3" to "1" and the macro will run from the list on Sheet(1).

The macro will not delete any files!!!!
The new files will be saved in the same folder as the "ew7" file.

HTH

I get a lot form this forum, I believe in giving back.
I am happy to have been of assistance.

FYI
10. Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.