locked
Publisher ugh! RRS feed

  • Question

  • I use MS Publisher 2010 linked to excel.  Every time I get into it, it asks to update links.  Every time it goes out to update a link it asks if I want to open the spreadsheet again, and again, and again, and again.  Either a) it should not do this, or b) there must be a way to turn off the damn warnings.  It eventually updates everything correctly, but I have to sit there and click the box over and over.  I can't find any code in the VB for Publisher that allows one to turn off warnings as can be done in Access (docmd.setwarnings false) or Excel (application.displayalerts = false).  To say this is annoying doesn't even scratch the surface since there are about 40 linked sections in the publication.

    Anyone out there have ideas?

    Doug 

    • Moved by Liliane Teng Tuesday, July 27, 2010 2:43 AM a problem related to VBA (From:Visual Basic General)
    Monday, July 26, 2010 10:08 PM

Answers

All replies

  • I use MS Publisher 2010 linked to excel.  Every time I get into it, it asks to update links.  Every time it goes out to update a link it asks if I want to open the spreadsheet again, and again, and again, and again.  Either a) it should not do this, or b) there must be a way to turn off the damn warnings.  It eventually updates everything correctly, but I have to sit there and click the box over and over.  I can't find any code in the VB for Publisher that allows one to turn off warnings as can be done in Access (docmd.setwarnings false) or Excel (application.displayalerts = false).  To say this is annoying doesn't even scratch the surface since there are about 40 linked sections in the publication.

    Anyone out there have ideas?

    Doug 

    Hi Doug,

    The VB for all Microsoft Office applications is known as VBA.

    VBA = Visual Basic for Applications.

    Please try the VBA forum.>>

    http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

    The forum you have posted in is for VB.Net questions only, sorry.


    Regards, John
    Monday, July 26, 2010 10:15 PM
  • Check in the options there may be an alert me for all updates option, so it could be prompting you for each file that is downloaded or each thing that is changed instead of just prompting you for the overall download.  try searching options to see if there is anything that relates to udateing or downloading files
    Monday, July 26, 2010 10:20 PM
  • I use MS Publisher 2010 linked to excel.  Every time I get into it, it asks to update links.  Every time it goes out to update a link it asks if I want to open the spreadsheet again, and again, and again, and again.  Either a) it should not do this, or b) there must be a way to turn off the damn warnings.  It eventually updates everything correctly, but I have to sit there and click the box over and over.  I can't find any code in the VB for Publisher that allows one to turn off warnings as can be done in Access (docmd.setwarnings false) or Excel (application.displayalerts = false).  To say this is annoying doesn't even scratch the surface since there are about 40 linked sections in the publication.

    Anyone out there have ideas?

    Doug 

    Hi Doug,

    The VB for all Microsoft Office applications is known as VBA.

    VBA = Visual Basic for Applications.

    Please try the VBA forum.>>

    http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

    The forum you have posted in is for VB.Net questions only, sorry.


    Regards, John


    This forum is not for VB.Net questions it is for all general VB problems, may I ask you to look at the top of the screen in the forum where it says

    "Questions and discussions not covered in the other VB forums such as Data and Setup. (Not for VB6 questions.)"

     

    Monday, July 26, 2010 10:25 PM

  • This forum is not for VB.Net questions it is for all general VB problems, may I ask you to look at the top of the screen in the forum where it says

    "Questions and discussions not covered in the other VB forums such as Data and Setup. (Not for VB6 questions.)"

     

    Hi Cabe O,

    I know very well what is written there. Please see my reply in the other thread.>>

    http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/28f964f4-1e14-40d1-954f-acb4a722aa5a

    There was actually a sticky post in VbGeneral or VbLanguage referring users to the VBA forum for VBA questions.


    Regards, John
    • Marked as answer by Fafafaalex Tuesday, August 3, 2010 1:46 AM
    Monday, July 26, 2010 10:43 PM
  • @Cabe O, what is your problem when someone direct OP to right forum. If you have solution to the question just answering it and stop criticize other answerers. I dont know how you want to address the question but is not belongs here.  At the end if no one tell OP the right forum, the thread will get lock up and move to Off-topic posts by moderator. This is office automation question in which it has its own forum

    [MICROSOFT OFFICE AUTOMATION] http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.office.developer.automation&lang=en&cr=US

    kaymaf


    CODE CONVERTER SITE

    http://www.carlosag.net/Tools/CodeTranslator/.

    http://www.developerfusion.com/tools/convert/csharp-to-vb/.

    • Marked as answer by Fafafaalex Tuesday, August 3, 2010 1:45 AM
    Tuesday, July 27, 2010 2:26 AM