Am I being a "mean" instructor, denying an extension on a take home exam Add a language to a polyglot Script or function to return how many days from now until It's a 6 digit identification number. Try Code: Set myWordDoc = myWordApp.Documents.Open(Filename:=File1.Path & File1.FileName) You may also need to include the \ between the call to Path and FileName Code: File1.Path & "\" & File1.FileName __________________ The The application runs in Windows 7 64-bit using Excel 2010 32-bit. weblink
Run-Time Error 5174 Just a value. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2013,06:37 AM #2 MrPicture15 New Member Join Date Dec 2013 Posts 3 Re: Trying to Open a Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2013,07:41 AM #3 RoryA MrExcel MVPModerator Join Date May 2008 Location East Sussex Posts 28,658 Re: Trying but it keeps giving a Run-Time Error 5174 and stating that it can't find the file.
All rights reserved. In the directory there are .docx and .docm files. The system returned: (22) Invalid argument The remote host or network may be down.
I researched the error and found there can be problems when both the filename extension is not included as part of the FileName argument, and when the filename extension is something Word that includes "food, alcoholic drinks, and non-alcoholic drinks"? Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Password Register FAQ Today's Posts Search Search Forums Show Threads Show Posts Tag Search Advanced Search Go to Page...
Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time.. click for more info Following adding the file, the code will go through all files in the directory like it should.
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 Run-Time Error 5174 My apologies, I realized I did not post the relevant Excel and Windows version information. The real path is like C:\users\myfirstname.lastname\Documents\work\weeklyreports? Please try the request again.
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... http://www.vbforums.com/showthread.php?359-Error-5174-File-could-not-be-found Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. VBA Visual Basic School program... I would try to re-install the visual basic runtime files.
For instance, I had read-only access to some drives, when then set a file's attribute to read-only, an error will occur. Learn the most practical features and best approaches for ASP.NET. The time now is 03:46 AM. -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top Powered by vBulletin Version 3.8.1Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. http://sortoutlookemail.com/visual-basic/visual-basic-vsa-error.html Check your macro settings in word.
Run-Time Error 5174 Results 1 to 5 of 5 Trying to Open a Word Doc in Excel VBa... That way you can figure out problems faster. Disabling on-the-fly projecting in Arcmap?
Try using LIKE: sMyDir LIKE "C:\weekly\" & "*.doc?" Edit: Your sDocName does not provide with a full path as well share|improve this answer edited Aug 5 '14 at 20:59 answered Aug You might need to set up a loop to test whether the Word app has loaded before continuing. __________________ Cheers, Paul Edstein [MS MVP - Word] #3 10-01-2013, 01:23 Results 1 to 3 of 3 Thread: Run-time error '5174' - File not found. I have tried to do what I saw in some of the other threads here, but I do not know enough to trouble shoot it.
Run-Time Error 5174 Hello all, I have been reading this forum for years and have found much helpful information, so I am hoping that someone can help me out here. I misunderstood. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Is it a coincidence that the first 4 bytes of a PGP/GPG file are ellipsis, smile, female sign and a heart?
KreeZiE General 18 04-24-2003 05:45 PM Open a Word Doc in the same Document some times. Are you sure you're getting the error at the .Visible=True statement rather than the .Open statement? (Of course that doesn't explain why the file may have disappeared, but still, first things sMyDir = "C:\weekly\" & "*.doc?" sDocName = Dir(sMyDir) While sDocName <> "" Documents.Open FileName:=sDocName, Visible:=False ' Does stuff sDocName = Dir() vba ms-word share|improve this question asked Aug 5 '14 at I have tried to do what I saw in some of the other threads here, but I do not know enough to trouble shoot it.
vvhrcon Word, PowerPoint, Outlook, and Other Office Products 1 04-27-2003 09:22 PM Beginner help with timers. http://www.microsoft.com/downloads/details.aspx?FamilyID=bf9a24f9-b5c5-48f4-8edd-cdf2d29a79d5&displaylang=en Also it may be something to do with Macro security.