tried that, it gives me a run time error that states the following:

"Run-time error '1004':

This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save as type"

The problem may be that our database spits out CSV files and thats what im starting with when i run the macro...