Thanks a million for this, but it is givin me an error '9' saying th
script is out of range on the first line Sub open3_v2() line
"Worksheets("Data").UsedRange.EntireRow.Delete "
So i changed the name of sheet 1 from data 1 to just data and i
imported the data from the first file, but then it gave an error on th
line: "Worksheets("Data" & iCount).Activate" before it gave me th
option to open the sceond file, how do i go about solving this?

--
Message posted from http://www.ExcelForum.com