Error 4198 Command Failed Word 2007
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 08 Oct 2016 12:03:53 GMT by s_ac5 (squid/3.5.20)
VBA Code & Other Help Word Help Solved: Part 1, Close, Do Not Save Active Document With Userform If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 1 2 Last Jump to page: Results 1 to 20 of 25 Thread: Solved: Part 1, Close, Do Not Save Active Document With Userform Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-12-2012,09:58 AM http://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-msoffice_custom/word-filesaveas-simple-macro-run-time-error-4198/3c40564d-88fe-421d-9210-f8d7c7f5f6aa #1 ac503683 View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Sep 2012 Posts 17 Solved: Part 1, Close, Do Not Save Active Document With Userform Greetings all, Big fan of VBA Express Intro: Gov't worker in water quality trying to create a semi-automated process for review requests using a Word form with data captured in Access (for my database) but distributed to Excel (for those who ack!Access). The form http://www.vbaexpress.com/forum/showthread.php?43620-Solved-Part-1-Close-Do-Not-Save-Active-Document-With-Userform will be filled out by various districts personnel in the agency located throughout the state and sent back via email. I'm not a VBA expert or programmer by profession. Rank amateur, green-as-grass. The form has potential for elegance (TY VBA!), but in my hands, I will be delighted to get the thing into production. I've been "borrowing" code from several sites including Greg Maxey's but there are a few problems I can't seen to comprehend the issue to find a solution. So here I am. I have several questions all related to this project, but will start with this one. OP is Windows XP with MSOffice 2007. The Word document is a macro-enabled template. The template has several form controls. The last one is a text form field that when the user moves out of the form field a userform automatically pops up giving the user several choices: Save Send as attachment Cancel(return back to form) Close and do not save It is the last choice I have been banging my head on for a while. What I want to do is: close the userform, close the active document without saving. I've tested some code separately and can get the userform to close OR get the active document to close without saving but NOT within the same procedure. It hangs up.
Word Macro when ActiveDocument.SaveAs rated by 0 users This post has 4 Replies | http://vbcity.com/forums/t/11162.aspx 1 Follower leena cardiff, Wales Since 9/25/2002 Posts 2 Reputation 40 http://www.xtremevbtalk.com/word-powerpoint-outlook-and-other-office-products/322720-error-4198-document-word-2010-a.html Reply leena beeharry (leena) Posted: 9/25/2002 9:54 AM rated by 0 users Help,I keep getting the 4198 runtime error when attempting to run the following code. I've no idea why. :(I would be grateful for any help;thanks in advanceLeena/*********** CODE ***********************/Private Sub Document_Open()Dim error 4198 prop As StringOpen "C:\Speed2001Installation.Properties" For Input As #1While Not EOF(1)Line Input #1, propIf Left(prop, 24) = "INSTALLATION_LOC_REPORTS" Thenlocation = Mid(prop, 28)End IfWendClose #1'select the entire document so that bookmarks can be found and table of contents generated laterSelection.WholeStorySelection.Fields.UpdateSelection.HomeKey Unit:=wdStory'InsertSpreadsheets'Move to the top of the doc before saving..Selection.HomeKey Unit:=wdStorysaveAsLocation = location + "\data\rapid\reports" & error 4198 command "\mnds"'Save the document to the users default word folder..ActiveDocument.SaveAs fileName:=saveAsLocation, _FileFormat:=wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:=True, _WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:=FalseEnd Sub/************** END OF CODE *******************/ | Post Points: 35 rjhare England Since 6/13/2001 Posts 2,436 Reputation 35,017 Reply rjhare (rjhare) replied on 10/3/2002 12:25 AM rated by 0 users leenaError 4198 is usually associated with the VBa hyperlinks object - do you have any in your document? Also what line does it stop at when you step through on the debugger?For more help, follow this link:Error 4198 Sorry it took so long to get a reply from us - I have only just seen the post :oAny more help or advice, come back and I will answer as quick as I can :thumb: Criticism comes easier than CraftmanshipWhilst I try and answer every thread there is, I find most of my answers to your posts here:[Posting Guidelines] | [FAQ's] | [The Chosen One] | [Knowledge Search] | [Richie's
VBA / Office Integration > Word, PowerPoint, Outlook, and Other Office Products > Error 4198 on document.open - Word 2010 only! Thread Tools Display Modes #1 11-17-2011, 01:45 AM George7a Saved by Grace Join Date: Mar 2005 Location: Nazareth Posts: 1,697 Error 4198 on document.open - Word 2010 only! Hi All, I am getting error 4198 in one of the PCs that has office 2010 on it. I know that the error is on the document.open command: Code: Dim objWdApp As Object Set objWdApp = CreateObject("Word.Application") objWdApp.Visible = False objWdApp.ChangeFileOpenDirectory local_tmp + "\" objWdApp.Documents.Open FileName:=App.Path & "\" & filename, ConfirmConversions:=False, ReadOnly _ :=False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate _ :="", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="" _ , Format:=0 This code has been working on office 2000,2002,2003,2007 & 2010. But it doesn't work in some specific PCs that I do not have any idea what is special about them. The full error message is: Quote: Error number:4198. Command failed 36966. 0. wdmain11.chm. Microsoft Word Any ideas how to solve this? I have been searching for a clue, and found nothing useful. - George __________________ Read Matthew 24: 3-14 - sounds familiar? Escape This - The Best Escape Games Ever! | Games Walkthrough Technology Videos Angry Birds Star Wars Walkthrough George7a View Public Profile Find all posts by George7a #2 11-18-2011, 05:45 AM Jupiter 2 Centurion Join Date: May 2009 Location: Australia Posts: 101 I'm not particularly up to date with the code but local_tmp does not seem to be a valid variable. If you are trying to run the macro on a PC that hasn't been used to create the macro in the first place then the temp files created by the VB Editor will not have been made and any undeclared variables will cause errors. Also, Word 2007 and 2010 use .docx extensions and if you are still using .doc extension then the error could be in any formatting you may have done in the latter versions when the document was prepared. __________________ If all my Answers are wrong, only then will I read the Question Jupiter 2 View Public Profile V