Disable Prompt when SaveAs (New Workbook)

[ntitled]

The following code asks for a prompt and ignores all the parameters in the SaveAs method:

Please Login or Register  to view this content.

I want to disable the standard SaveAs dialog box when I do this.

Thank you

[ImStevenB]

Hi ntitled,

Welcome to the Forum!

Have you tried putting:

Please Login or Register  to view this content.

.. before the SaveAs?

Don't forget to set it back to true before the End Sub.

Hope this helps.

[ntitled]

Hi Steve,

Thanks for the prompt reply!

Yes I've added:

Please Login or Register  to view this content.

And added the ...=True before the End Sub.

I'm still being prompted with the standard SaveAs dialog box.

[ImStevenB]

Hmm .. for me it runs and saves whether I use the original code you posted or

Please Login or Register  to view this content.

I do not get a SaveAs dialog either way.

Let me dig a little .. but normally disabling the Alerts will do the trick.

[ntitled]

I created a new workbook with the code and it still didn't work.

The following is my Excel version if it helps: 14.0.6023.1000 (32-bit).

Thanks again

[ImStevenB]

I have been trying to duplicate the problem you are having and I am unable to get Excel to prompt me with a save as dialog.

Is there a chance you can post your workbook?

[ntitled]

I can't upload it at the moment (I will when I get home) but even when I try to save an unsaved workbook with a macro, I get the SaveAs dialog box.

Please Login or Register  to view this content.

...HOWEVER, I do not get a dialog box when I use the .SaveAs method with a workbook that has been saved with a different name.

[ntitled]

I tried the same code snippet from home and it worked. I'm assuming it has to do with a plug in installed at my work computer.

[ImStevenB]

Good to know I wasn't totally losing my mind as to how that should have worked.

[ntitled]

Thank you for all your help thus far!

The reason for why I am being prompted with a SaveAs dialog box is from a plugin called eDocs DM.

As I am debugging the .SaveAs method, I noticed that Excel goes into the following EventClassModules when I Step In:

Please Login or Register  to view this content.

...then into

Please Login or Register  to view this content.

Then the SaveAs dalog box appears.

Is there a way to override the plugin (without disabling it) and make the workbook behave as if the plugin didn't have a App_WorkbookBeforeSave method?

[ImStevenB]

I do not have any plugins to make sure .. but try this

Please Login or Register  to view this content.

Setting enableevents to false should stop the plugin.

[ntitled]

Wow.

This is awesome, thank you so much!

[ImStevenB]

You are quite welcome.

Glad we got it working!


------------------
Be sure to mark the thread as Solved
Click the star to show you appreciate the help everyone has provided