Code: Public Sub SendToWord() Dim myWord As Word.Application Set myWord = New Word.Application With myWord .Visible = True ''' Run-time Error 5174 ''' Application-defined Error or Object-defined Error myWord.Documents.Open Filename:="1.doc" End All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Following adding the file, the code will go through all files in the directory like it should. SEO by vBSEO ©2011, Crawlability, Inc. http://gmailpush.com/visual-basic/visual-basic-error.html
Symptoms You get the error Unable to run to specified macro, or Run-time error 5174 File could not be found Cause FSPro.dotm and/or FSPro.dot is missing. Get 1:1 Help Now Advertise Here Enjoyed your answer? The system returned: (22) Invalid argument The remote host or network may be down. Web Browsers Software Firewalls Hardware Firewalls Windows Networking Working With Basic Random Variables in Excel Video by: Toby The viewer will learn how to simulate a series of coin tosses with
I would try to re-install the visual basic runtime files. I moved the files to the Documents directory, and it works as its supposed to. Not the answer you're looking for? Run-Time Error 5174 Results 1 to 5 of 5 Trying to Open a Word Doc in Excel VBa...
Why cast an A-lister for Groot? In order to provide the flexibility we need, the code first builds the name of the file to be opened using a string variable. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode look at this site Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free.
How should I deal with players who prefer "realistic" approaches to challenges? Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! here is the link for that http://kb.iu.edu/data/agzk.html 0 LVL 76 Overall: Level 76 MS Office 29 MS Applications 19 Windows Networking 1 Message Active today Expert Comment by:GrahamSkan2007-06-20 I suggest 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
Advanced Search VBForums Visual Basic Visual Basic 6 and Earlier Error 5174 - File could not be found If this is your first visit, be sure to check out the FAQ http://www.vbforums.com/showthread.php?359-Error-5174-File-could-not-be-found It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... I am no longer getting the error.
First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. this contact form Here is the code we are using: Code: Set appMS_Word = CreateObject("Word.Application") For Each vSelected_Iterations In colSelected_Iterations With wkbData_Workbook.Sheets("Report Data") sReport_Name = .Range("B6").Value sReport_Name = sReport_Name & "Reports\Extraction Reports\" sReport_Name = Learn how to create a query and then a grouped report using the wizard. Covered by US Patent.
the file exists!The first few files are:000001_ML_strong.doc000001_VG_hall.doc000001_VG_nichels.doc000001_VG_soper.docWhen it gets to the 000001_VG_nichels.doc file it bombs out. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old. - Increase transparency - Onboard new hires faster - Access from mobile/offline Try Copyright © 2004 - VBA Express MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store http://gmailpush.com/visual-basic/visual-basic-400-error.html What I am trying to do is provide a method for users to edit reports that are generated by an application my team developed.
Then you appear to be missing at least the Drive information from the file path. The file DOES exist!!! I misunderstood.
Join the community of 500,000 technology professionals and ask your questions. Reference: the Microsoft site explains how to turn on the Developer tab. 2 Go to the Developer tab and click on Document Template. I just needed to read the documentation on the Dir function. The application runs in Windows 7 64-bit using Excel 2010 32-bit.
First time, no error. By joining you are opting in to receive e-mail. Register now while it's still free! http://gmailpush.com/visual-basic/visual-basic-divide-by-zero-error.html as follows.
Any ideas? 0 Question by:wball1217 Facebook Twitter LinkedIn Google LVL 11 Best Solution bybloodymalth5 Sorry I thought tha you were trying to make a file open in word. The time now is 08:53 PM. -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top Powered by vBulletin Version 3.8.1Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. If not you will have to introduce some error correction. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2013,07:14 AM #5 RoryA MrExcel MVPModerator Join Date May 2008 Location East Sussex Posts 28,422 Re: Trying
Join Us! *Tek-Tips's functionality depends on members receiving e-mail. All contents Copyright 1998-2016 by MrExcel Consulting. Close Box Join Tek-Tips Today! Your cache administrator is webmaster.
Or, it could be the permission as well, i.e. After that - it gives me the error. If so, when I move it in production, the path is longer, so I will have the same problem. –Geoff Lentsch Aug 5 '14 at 19:52 @guy Is the Joe Reply With Quote Quick Navigation Word Help Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Announcements Announcements Introductions VBA Code & Other Help How
But for some reason my looping doesn't work. The report exists... It doesn't get to all of the files...Sub Merge()'' Merge Macro' Macro created 10/22/2003 by ssga'Dim strcurrentfilename As VariantDim Wrd As Word.ApplicationDim newcurrentfilename As StringDim firstnine As StringDim originalfilename As StringDim
© Copyright 2017 gmailpush.com. All rights reserved.