Save as macro with location and filename

[realrookie]

Hello,

I am trying to save several sheets from 1 workbook as a separate wb in a specific location. The following code does that, but when I execute, it gives me a prompt saying "cannot save with these features...".
It is trying to save as a macro-enabled workbook which I don't want. Sheet2-4 don't have any macro's in them. When I select to save without features, I get a run-time error. Removing the location results in the new wb being saved in the same location as the original file. Any help , greatly appreciated.

Please Login or Register  to view this content.

[gmr4evr1]

Try removing Filename:=......Just use Fname after &

[realrookie]

Thank you for your reply. Removing Filename:= results in the file being named Fname and still asking me to save as a macro enabled workbook. But no runtime error anymore

[gmr4evr1]

Give this one a try..

Please Login or Register  to view this content.

Edit* If there is no value in Sheet1 D2, it will give a "Subscript out of range" error

[realrookie]

Definitely better sir. Is there a way to surpress the macro-enabled saving message and auto select yes? Application.DisplayAlerts = False did not work,.

[gmr4evr1]

That's odd, it works for me when I test it. I don't get the macro enabled saving message when I run it.

[realrookie]

There is a macro within the sheet which I missed. Is there a way to suppress the message and auto accept yes?

[gmr4evr1]

the Application.DisplayAlerts = False should do that. Not sure why it's not working for you but it is for me.