MVSFORUMS.com

Redrose · Beginner Joined: 29 Sep 2006 Posts: 13 Topics: 6

Hi All,

I have five flat files (Physical sequential). My requirement is to create an excel workbook with five work sheets with data from flat files like,

First sheet with data from flat file 1,
Second sheet with data from flat file 2 and so on.

Thanks in advance,
Ramanan R

kolusu · Posted: Mon Aug 20, 2007 7:22 am Post subject:

Redrose,

Concatenate all files together and send it as 1 txt file. Then code the following macro in excel and create multiple work sheets. The macro shows how to split the file based on the no: of rows

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Anuj Dhawan · Posted: Tue Aug 21, 2007 2:25 am Post subject:

Hi Kolusu,

Tried using above macro in excel. But it's getting stopped at FileNum = FreeFile(). If you've tried above macro or have some comments to avoid this error then please suggest me.
_________________
Regards,
Anuj

kolusu · Posted: Tue Aug 21, 2007 7:01 am Post subject:

anuj_model,

I have no problem running the macro. What version of excel are you running?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Anuj Dhawan · Posted: Wed Sep 26, 2007 8:25 am Post subject:

Hi Kolusu,

Ah..an old version is availabe here in office..Excel 2000 Sad

P.S: Soryy for such a delayed reply, I was being away from net(this site), since many days.
_________________
Regards,
Anuj