joel;688677 Wrote:

By the way, sometimes these type problems are easier to solve if you let
the macro open the text file. For example in you spreadsheet you had
the word Department split into columns B and C. I can open a text file
in VBA and get the word department to be in one column in stead of tow
columns.



hi joel,

thanks a million for the macro!!! it works like magic. it has taken me
less than a minute to convert the table. previously it used to take us
almost 4 hrs every month just to get the data into a table format.

Regards,

Rosana


--
i-roalam
------------------------------------------------------------------------
i-roalam's Profile: http://www.thecodecage.com/forumz/member.php?u=1695
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=191856

http://www.thecodecage.com/forumz