"You cannot open two documents with the same name" problem and how to trap the error in VBA.
in [Word VBA]
|
Prev: marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicotePara Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 90715
Next: Editing Word 2007 menu that was created in Word 2003
From: Doug Robbins - Word MVP on 22 Feb 2010 14:38 One other thing, you could turn off the option to "Update automatic Links at open", which should suppress the alert message. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Anthony" <excelmodeling(a)gmail.com> wrote in message news:e04aae8e-9ee4-4edd-a63c-02151ec3f154(a)k11g2000vbe.googlegroups.com... > Thank you, Doug, for your info and code again. > > If it is necessary to post in multiple groups, I would put in the > subject something like this: "Help with link problem and how to trap > the error in VBA (also post in work.newusers, work.vba.beginner, and > work.vba.general)"? > > So the main idea of the code is to replace the "LINK" in the field > codes with "DOCVARIABLE" and make it a "DOCVARIABLE" field instead of > a link field? I used similiar code to replace the folder path in the > field code. > > Thank you for asking the following questions: > > Are all of the links to the one workbook? Are they all to the cells > on one > sheet in that spreadsheet? Or do the links come from multiple sheets > in > multiple workbooks? > > That is very considering of yours. 99% of the links are link to the > same workbooks, where as the other 1% are not. The links in that 1% > are purposely ignored. I do have some IF conditional statement to > take care of this so that only the 99% portion is modified. (There > are also PAGEREF, table of content links, in the files. They are > ignored too.) > > I will try your code and let you know how it works out. > > Despite the fact that we may switch the link to DOCVARIABLE type, > before we even do this, the alert message will continue to come up > when the file is opened. One will need to click throght the [OK] > button in each of the popped up message in order to proceed further. > As I have mentioned previously, to avoid this, either use a doc file > (2003 version) or run the VBA file in Word 2003. (Even the VBA file > is developed in Word 2007 and was saved in docx, it can still be > loaded and run in Word 2003 - if there is no 2007 functionality in > it.) > > By the way, should I post the link of this thread in the threads that > I posted in mutliple locations, so that people know that the answer > has been provided? > > Anthony >
From: Anthony on 22 Feb 2010 19:15 Hi Doug, Thank you for your help again. Checking off the "Update automatic links at open" off does not help and neither check the "Update Manually" option under Links (right click). The messge still pop up. I do not know why you mention this "do not know how you post simultaneously to multiple newsgroups using Mozilla". Were you asking me how I did it or you are trying to show me how to do it? (If the former, then I did it by going to each of the groups and made the post by one by.) Regarding this info "In Outlook Express/Windows Mail/Windows Live Mail, you select all of the Newsgroups ....", would this allow me to read Newsgroups posts using Outlook without going to the Web? I use Outlook 2007, could you show me how to do this in it? Thanks. Anthony
From: Doug Robbins - Word MVP on 22 Feb 2010 20:26 In answer to the first question, what I was saying is that I do NOT know how it should be done in Mozilla. The answer to the second question is "Yes". The following instructions were written by Tom Kock for Outlook Express, but the method is pretty much the same in Windows Mail and Windows Live Mail 1.1. Connect to a newsgroup server using Outlook Express Open Outlook Express and follow these steps: 1. On the Tools menu, click Accounts. 2. In the Internet Account dialog box, click Add, and then click News. The Internet Connection Wizard starts. Follow these steps in the wizard: 1. On the first screen, in the Display name box, type the name that other users will see when you post a message to the newsgroup, and then click Next. 2. On the second screen, type your full e-mail address in the E-mail address box, and then click Next. 3. On the third screen, in the News (NNTP) Server box, type the name of your news server. To subscribe to the newsgroups hosted on Microsoft's servers, type msnews.microsoft.com. If you don't know the name of your news server, contact your Internet provider. 4. If necessary, select the My news server requires me to log on check box, and then click Next. If you don't know whether your server requires you to log on, contact your Internet provider. The Microsoft server does not require a user name and password. 5. On the last screen, click Finish. 3. Click Close, and then click Yes when asked if you want to download newsgroups from the account you just created. The Newsgroup Subscriptions dialog box appears. 4. Select the newsgroups you want to use, click Subscribe, and then click OK. Note Most of Microsoft newsgroups use this naming convention: microsoft.public.application_name.specific_area. For example: you could subscribe to microsoft.public.office.dataanalyzer, or microsoft.public.excel.programming. However, that isn't always the case. Don't be afraid to browse the list of groups in order to find something that you think will be useful. 5. On the Tools menu, click Options, click the Read tab, and then clear the Get 300 headers at a time check box. 6. Click the Maintenance tab, clear the Delete new messages n days after being downloaded check box, and then click OK. Step 5 allows you to download and read all the newsgroup's postings when you first subscribe. Step 6 allows you to read older messages. 1.2. Subscribe or unsubscribe to newsgroups After you establish a connection to your newsgroup server, you add newsgroups to your list by subscribing. You can subscribe or unsubscribe to newsgroups at any time. Typically, you use the group name as a guide when subscribing. For example, a name such as microsoft.public.office.developer.outlook.forms would be a good place to start if you need help writing a custom form for Outlook. To subscribe 1. Start Outlook Express. 2. In the folder pane, click the name of your news server. For example, if you established a connection to Microsoft's server, click msnews.microsoft.com. 3. In the main viewing pane, click Newsgroups. 4. In the Newsgroup Subscriptions dialog box, select a newsgroup from the list, and then click Subscribe. 5. Repeat the previous step to subscribe to additional newsgroups, and then click OK when you finish. 6. In the main viewing pane, double-click the name of the new newsgroup. If you only want to receive new messages since the last time you visited, select the New messages only check box, and then double-click the newsgroup name. Note When you subscribe to a newsgroup for the first time, you receive all the messages whether or not you select the New messages only check box. To unsubscribe .. In the Outlook Express folder pane, right-click the newsgroup that you want to stop using, and then click Unsubscribe on the shortcut menu. Tips .. To reduce the number of items in the list of available newsgroups, enter a phrase in the Display newsgroups which contain box. For instance, you can enter an application name such as "publisher" or the name of a discipline such as "programming." The list changes automatically when you finish typing. .. Newsgroups in languages other than English are identified by their names; for example, microsoft.public.fr.excel is a newsgroup for Microsoft Excel users who speak French. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Anthony" <excelmodeling(a)gmail.com> wrote in message news:a202738b-6b36-4b7d-b2d5-be4619b51015(a)c28g2000vbc.googlegroups.com... > Hi Doug, > > Thank you for your help again. Checking off the "Update automatic > links at open" off does not help and neither check the "Update > Manually" option under Links (right click). The messge still pop > up. > > I do not know why you mention this "do not know how you post > simultaneously to multiple newsgroups using > Mozilla". Were you asking me how I did it or you are trying to show > me how to do it? (If the former, then I did it by going to each of > the groups and made the post by one by.) > > Regarding this info "In Outlook Express/Windows Mail/Windows Live > Mail, you select all of the Newsgroups ....", would this allow me to > read Newsgroups posts using Outlook without going to the Web? I use > Outlook 2007, could you show me how to do this in it? > > Thanks. > > Anthony > > > >
From: Anthony on 22 Feb 2010 21:00 Doug, Thank you for your instruction on how to set up accessing newgroups in Outlook. If you find out how to disable the "You cannot open two documents with the same name" message pop up, please let me know. Thanks again. Anthony
From: Doug Robbins - Word MVP on 23 Feb 2010 00:44
Create the following macro in your normal.dotm template: Sub FileOpen() Application.DisplayAlerts = wdAlertsNone Dialogs(wdDialogFileOpen).Show End Sub -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "Anthony" <excelmodeling(a)gmail.com> wrote in message news:c777a5de-b3dc-4627-99f7-05f9cec61d03(a)f8g2000yqn.googlegroups.com... > Doug, > > Thank you for your instruction on how to set up accessing newgroups in > Outlook. > > If you find out how to disable the "You cannot open two documents with > the same name" message pop up, please let me know. Thanks again. > > Anthony |