Hi Bob, I think i am not explaining myself properly, sorry. I get file
that is downloaded from SAP onto the computers C drive, i am wanting to
create a macro file so to say that the user must open and input on
request the file name that he saved it under, the code will then open
that file it will then be manipulated into the cells and then the user
will change the data and he must then be able to save it again but i
have to delete the headers before it gets saved, so thought that if i
remove the commands and only have one button for example, it would then
run the code to save it and delete the not required rows.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***