Thank you for the code mudraker but when I ran it it gave me and erro
(object doesn't support this method) in the line listed below. I trie
to figure it out but I couldn't get anything else to work. Do you kno
whats wrong?

Workbooks("Import ProE Log.xls").Sheets(2).Range("a3").Paste


Dave - to clarify my objectives:

I have a csv log file that gets updated everyday. I also have a Exce
workbook called "Import ProE Log" I want to copy the data from the lo
file, delimit it, and open it as sheet two in my workbook. I need th
data two start on row three so I can insert headers on the first rows
I have my code in a command button so that this can be run every day.
Sorry it wasn't clear the first time.

Thank you both for your help

morr

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