Save macro workbook as xlsx bypassing msg box

**kosherboy** · 01-01-2014, 11:12 AM

Hi,

I have a code below that automatically saves my macro based workbook in a different file in regular xlsx format. This works great when I hit the macro but how do I bypass the message box that says "the following features cannot be saved in macro-free workbooks: .VB project To save a file with these features.........." using a macro code? Of course I can click "Yes" but I want the macro code to do this for me.

Here is the code i'm working with:

Please Login or Register  to view this content.

Thanks in advance!

**fredlo2010** · 01-01-2014, 11:36 AM

Disable the notifications and en enable them back again.

Please Login or Register  to view this content.

Thanks

**kosherboy** · 01-01-2014, 11:54 AM

Originally Posted by fredlo2010

Disable the notifications and en enable them back again.

Please Login or Register  to view this content.

Thanks

Thanks, that worked! Can you just let me know how do I save that file as the actual file name as it differs each time?
Thanks

**fredlo2010** · 01-01-2014, 11:58 AM

What changed? and how you know it changed. Is it based on the value of a cell?

Thanks

**HaHoBe** · 01-01-2014, 11:58 AM

Hi, kosherboy,

no need for a full quote as that post stands directly before yours (and it was the only one).

Please Login or Register  to view this content.

Ciao,
Holger

**kosherboy** · 01-01-2014, 12:06 PM

Originally Posted by fredlo2010

What changed? and how you know it changed. Is it based on the value of a cell?

Thanks

No, it's not based off the value of a cell, it's based off the filename if the macro workbook. When I enter the filepath by "file name' i would assume that it would use the active file name of the macro workbook and save it as xlsx with the same filename but it doesn't.

**kosherboy** · 01-01-2014, 12:44 PM

Originally Posted by HaHoBe

Hi, kosherboy,

Hi, I tried your code but I can't figure out how to put my file path in to your code and how does your code save the macro workbook in xlsx format using the active filename?

**HaHoBe** · 01-01-2014, 12:55 PM

Hi, kosherboy,

how do I save that file as the actual file name as it differs each time

Please Login or Register  to view this content.

Ciao,
Holger

**fredlo2010** · 01-01-2014, 12:57 PM

try

Please Login or Register  to view this content.

**kosherboy** · 01-01-2014, 01:13 PM

Originally Posted by HaHoBe

Hi, kosherboy,

[code]Sub Save_as_Macrofree()

With ActiveWorkbook
Application.DisplayAlerts = False

That did the trick but I noticed that the code created an xlsx file in the destination file path (which is what I want - thanks!) and it created an xlsx file in the sourse filepath which I don't really need. Is there a way to delete that extra file? Otherwise everything is fine.

**kosherboy** · 01-01-2014, 01:21 PM

It's ok, I figured it out. I just took away the first "save as" and only used the second "save as" from your code. Thanks for all your help

Save macro workbook as xlsx bypassing msg box

LinkBack

Thread Tools

Rate This Thread

Display

Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Re: Save macro workbook as xlsx bypassing msg box

Thread Information

Users Browsing this Thread

Similar Threads

Macro Save As .xlsx dialogue box

[SOLVED] Macro That will save XLSM as XLSX

[SOLVED] Macro to save file as XLSX in the same folder from where it originated

Export data from xlsx based on code name and save it to new xlsx with changed column name

VBA to save a copy of .xlsm workbook as .xlsx

Bookmarks

Bookmarks

Posting Permissions