file Save As issue

I'm trying to use a macro to take a .txt file, re-format it and save as .xls. The .xls already exists and I want to copy over it. I also want to close the macro excel file, without saving, so that it can be reused. The code below appears to do just that, but when I try to open the newly created .xls file, I recieve the following prompt "This File you are trying to open, 'CompanyConvert.xls', is in a different format than specified by the file extension. Verify that the file is not corrupt and is from a trusted source before opening the file. Do you want to open the file now?". This is causing issues downstream. There has to be something screwy with how I'm saving this file. Thoughts?

Please Login or Register  to view this content.

Thanks in advance,

Ray

Originally Posted by Norie

Ray

Try explicitly specifying th file format when saving.

Please Login or Register  to view this content.

This worked great Norie, Thank you for the quick response

Ray

Originally Posted by HaHoBe

Hi, Ray,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

Thank you too for the quick response HaHoBe, greatly appreciated!

My apologies for unresolving this but another issue popped up while saving this file. Becuase the file now already exists and Im trying to save a copy over it, I get a pop up that says "The File name "xxxx.xls" already exists in this location. Do you want to replace it?". Is there logic I can build into the macro that automatically chooses 'Yes' and avoid the manual process for clicking 'Yes' altogether?

Please Login or Register  to view this content.

Thanks,
Ray

Originally Posted by HaHoBe

Hi, rdowney79,

I think my sample code covers exactly the problem that you ask for right now.

Ciao,
Holger

that worked great, thanks. One last question. The below code saves the file and closes the workbook. How do I use the macro to close out of Excel entirely?

Please Login or Register  to view this content.

Thanks,
Ray