By Passing VBA Msg Boxes the ones that Display Alerts wont work on

please post the code showing where you used displayalerts

can you post your code?

Please Login or Register  to view this content.

please add code tags to your post

thank you :-)

try replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Remove "File Location" & from the saveas path

Please Login or Register  to view this content.

I just tested your code (without the loop) in both 2003 and 2010 and it works as expected with no prompts. do you have anything else that may be interfering such as an add-in or document management software?

Well I didnt see were you said you were hiding Filelocation.

you could try skipping excel and using the scripting.runtime

Please Login or Register  to view this content.

for instance

will I be able to delete the first line of the txt file as it has 2 header lines and i'm only interested in the 2nd one, as the first is just the name of the file or should I be looking at getting the data output to not include the first header. I will give this code a go and let you know.

Also how do I get that to work on the 18 different files, as they are date stamped as part of the file name.

that code opens the input file, skips the first line then outputs the rest to new file