It opens a Word Document from and Excel Worksheet and merges info from Excel to Word. When you double-click something in the Access field, behind the scenes Access is taking care of starting Word up and loading the document. But in the other pc, it only opens the word doc but not the copying part. 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 his comment is here
When they are using the worksheet from a remote location, they get the run time error. If it's 0, then it will copy only the main table and leaving the second one. Forum Rules | Contact Forum Editor | Report a Post Error # 4248 was generated by Microsoft Word. When I opened his worksheet, I could not create a Word document with the macro either.
up to now it's all ok. The program is fine when I ran the program on my computer. If you could re-explain what you were saying to me because I am such a newbie. Run Time Error 4605 Visual Basic 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.
Any idea? I've highlighted the line where the error occurs. if it's 1, then it copy main table down to the first row of the second table. http://stackoverflow.com/questions/31911657/qa-on-ms-word-run-time-error-4248 To start viewing messages, select the forum that you want to visit from the selection below.
Granted, but that wasn't the point of the question, which was to establish that Word 2010 correctly creates a document from the template. Run Time Error 4605 This Method Or Property Is Not Available Because The Clipboard Documents.Add[/COLOR] [COLOR=#000000] 'Clear the error. but more than that. In your code what happens if text65 = Inpatient? 1.
I put a formula in cell F20 to count the value in cell F16:F18. Thanks, lauro Monday, August 20, 2012 8:52 PM Reply | Quote 0 Sign in to vote Hi lauro, Thanks for your clearly description on the issue and the sample you provided. Vba Error 4605 BUT. Run Time Error 5941 The Requested Member Of The Collection Does Not Exist The time now is 04:06 AM.
Attached Files To view attachments your post count must be 0 or greater. And suggest some work around? Since the ms word will enter the protected view mode if the files are downloaded from the Internet and my word file is generated on the server side. if it's 1, then it copy main table down to the first row of the second table. Run Time Error 4605 Word 2010
Last edited by Tinbendr; 04-11-2012 at 11:27 AM. MSOfficeForums.com is not affiliated with Microsoft LinkBack LinkBack URL About LinkBacks Register Help Remember Me? Portal Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Knowledgebase For the second code you posted Word has to be open, otherrwise there's nothing for GetObject to get. weblink It only occurs sometimes though, so it seems to be some kind of timing thing.
These cases pass to the form as an object in xml, a value that is retained in an dynamic web application.) Honestly I could not see any examples of this on Run-time Error '5941' Application-defined Or Object-defined Error Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. I went ahead and put all the events into a notepad for you: Private Sub Document_Close() End Sub Private Sub Document_ContentControlAfterAdd(ByVal NewContentControl As ContentControl, ByVal InUndoRedo As Boolean) End Sub Private
I will ask again...please describe the exact circumstances. In this case, that could be because Word can't find the referenced template. Especially Option Explicit. Run-time Error 4605 Excel One thing you can try is to build a loop at the beginning of the code to check the Documents.Count property.
But when I open the word doc from my form (double click or left mouse,OLE,open) I get Run-time error '4248': This command is not available because no document is open. Your post count is 0 momentarily. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 14th, 2014,04:18 PM #6 NdNoviceHlp Board Regular Join Date Nov 2002 Location Manitoba Canada Posts 1,599 Re: Run What module is the code in?
Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name The range differs depending on value. We are here to help so help us to help you!
If statement executes, testing if text65 = Residence 7. But as the ActiveDocument don't have any value that's why the header isn't getting updated after clicking "End" button of run-time dialog. Again, the IT department can make sure this is set for all users - and they will need to do that if the location is a network drive.Cindy Meister, VSTO/Word MVP this part is Range("F3:J13").Copy is a 4 row data.
The button show/hide depending on number of rows. 07-10-2013, 01:57 PM excelaverage Re: RunTIme Error 4248 I feel bad about this.
© Copyright 2017 mwdsoftware.com. All rights reserved.