If not, it might be best to try there, first, as the Access specialists probably have more experience with the problem and may already know a solution. Any idea? All users are accessing it from the same network location. It seems, at least, that the origin of the error message has been tracked down :-) <
Especially Option Explicit. Reply With Quote 04-11-2012,11:12 AM #16 Tinbendr View Profile View Forum Posts View Blog Entries Visit Homepage View Articles VBAX Expert Joined Jun 2005 Location North Central Mississippi (The Pines) Posts Here is a piece of the VBA code in the Excel worksheet. There are many other documents like it but I did not code it. https://support.microsoft.com/en-us/kb/813983
Code: Dim wrdApp As Word.Application Set wrdApp = CreateObject("Word.Application") Application.ScreenUpdating = False With wrdApp .Documents.Add Template:="G:\ABP\ArchSpec\A-Operations\Group Templates\Quote Templates\MWLinearQuote.dotx" Any help would be very much appreciated. #2 02-15-2014, 09:15 PM Dave Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 14th, 2014,07:25 AM #3 CIF New Member Join Date Nov 2011 Posts 6 Re: Run Time Error The store without checkouts or queues 1995-2015: How technology has changed the world in 20 years Why ecommerce hasn't taken off on social media Super Mario Run preview | Hands-on first Anyway, back to the question.
Show 40 post(s) from this thread on one page Page 1 of 2 1 2 Last Jump to page: All times are GMT -4. Thanks really. Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search Run Time Error 4605 Visual Basic What is the full code for the procedure with: If ActiveDocument.FormFields("text65").Result = "Inpatient" Then _ ActiveDocument.FormFields("Check3").CheckBox.Value = True Formatting tags added by mark007 Reply With Quote 04-05-2012,04:18 PM #6 fumei View
Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Runtime Error 4248 This Command Is Not Available Because No Document Is Open F11:J16 if it's 2, then F11:J17 and 3, then F11:J18. What happens is that there is a little table on the lower left hand side of the page, and what happens is that there are six (6) values that get passed http://stackoverflow.com/questions/31911657/qa-on-ms-word-run-time-error-4248 But the number of activate document is 1.
Cross-posting is when you post the same question in other forums on the web. Run Time Error 4605 This Method Or Property Is Not Available Because The Clipboard The file based on the template arise the infamous error: Run-time error '4248': This command is not available because no document is open. (Actually I also had problem to insert it one has the main item and I always include in copying. I will let you know if there is any progress.
BUT, which one is it? http://www.excelforum.com/excel-programming-vba-macros/938025-runtime-error-4248-a-print.html When I double click on the file, it opens in a new word application. Vba Error 4605 I've done some more tests. Run Time Error 5941 The Requested Member Of The Collection Does Not Exist thanks very much for the reminder... 07-10-2013, 02:31 PM excelaverage Re: RunTIme Error 4248 Sir...
I am in panicking about this one. David Reply With Quote 04-11-2012,11:28 AM #17 midani View Profile View Forum Posts View Blog Entries View Articles VBAX Regular Joined Apr 2012 Posts 10 Location Answer Regarding The Uses of When we set the Macro Settings to other options, the word file opens as expected without any error. After opening the word in protected mode and clicking the "Enable Editing" button , the word is existed from the "protected view mode" and change to "Compatibility Mode". Run Time Error 4605 Word 2010
Select Case ActiveDocument.FormFields("text65").Result Case "Inpatient" ActiveDocument.FormFields("Check3").CheckBox.Value = True Case "ER/Outpatient" ActiveDocument.FormFields("Check4").CheckBox.Value = True Case "DOA" ActiveDocument.FormFields("Check5").CheckBox.Value = True Case "Nursing Home" ActiveDocument.FormFields("Check6").CheckBox.Value = True Case "Hospice" ActiveDocument.FormFields("Check7").CheckBox.Value = True Case "Residence" Nothing I have tried thus far has worked. I have edited my original post. weblink The time now is 04:14 AM.
We are here to help so help us to help you! Run-time Error '5941' Application-defined Or Object-defined Error Documents.Add[/COLOR] [COLOR=#000000] 'Clear the error. I am going to try to figure it out and will get back to you.
As for deciding what to copy, that is straightforward if you have things set up as you describe. Could you explian me why? I can't combine my two macros as the second macro its not consistent. Run-time Error 4605 Excel Also the work-around scripts given on the kb articles does help me in suppressing the run-time error, but still the document header is not updated as the script execution was interrupted
The point is that text64 does not MEAN anything. All rights reserved. I created these documents with 2007 and I still have 2007. Reply With Quote 04-11-2012,11:41 AM #20 Tinbendr View Profile View Forum Posts View Blog Entries Visit Homepage View Articles VBAX Expert Joined Jun 2005 Location North Central Mississippi (The Pines) Posts
It opens a Word Document from and Excel Worksheet and merges info from Excel to Word. I put a formula in cell F20 to count the value in cell F16:F18. I did that and it is selected. BTW: you should use Select Case rather than multiple IF statements.
F14 and f15 are both header too. This is my first time posting on a forum like this and I read the instructions, but I obviously did not understand them very well. The open ms word is working in the other pc. when the word code arrive at the ActiveDocument instruction.
HTH. In order for macros to be able to run, the Trust Center settings have to be correct - and I mean more than just enabling macros to run. At a guess, I'd say you're wanting help with this line: With .Dialogs(wdDialogFileSummaryInfo) Change that to: With wrdApp.Dialogs(wdDialogFileSummaryInfo) __________________ Cheers, Paul Edstein [MS MVP - Word] #12 02-21-2014, 01:55 Thanks a lot, Midani Reply With Quote 04-05-2012,04:18 PM #4 fumei View Profile View Forum Posts View Blog Entries View Articles VBAX Wizard Joined May 2004 Posts 6,713 Location Maybe you
I hope I did it right this time... access database "database1", with a table and a form (3 fields: ID, path, word Doc OLE)a simple file "normal.docx"a file "with code.docx" based on the following templatea template with this only It greatly help on understanding the problem. :) After trial and error, the Run-time error '4248' occurs when Macro Settingsis set to "Enable all macros(not recommended; ..." in the Trust Center. And the ms word start to execute the VBA program.
Private Sub Document_Open() If Application.ActiveProtectedViewWindow Is Nothing Then createButtonFunction (ActiveDocument.Tables.Count) End If End Sub The program keep on saying that "ActiveDocument" is not found. All rights reserved. Powered by vBulletin Version 4.1.8 Copyright © 2016 vBulletin Solutions, Inc. Why were weapons like Mandrakes and Acromantula, which kill indiscriminately, used in the Battle of Hogwarts?
It would also be helpfull to know on what line the error occurs. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Here is a piece of the VBA code in the Excel worksheet. but when running from my colleagues pc, it seems to miss the active document.
© Copyright 2017 mwdsoftware.com. All rights reserved.