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 Connect with top rated Experts 16 Experts available now in Live! I am sure this path exists though, I have copied it from Explorer. –Geoff Lentsch Aug 5 '14 at 19:46 Is it possible the path is too long? 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. http://forumyaren.com/visual-basic/visual-basic-400-error.php
Any help would be greatly appreciated. Is it in Word itself, or some other application? 0 Featured Post How your wiki can always stay up-to-date Promoted by Quip, Inc Quip doubles as a “living” wiki and a Run-Time Error 5174 Results 1 to 5 of 5 Trying to Open a Word Doc in Excel VBa... ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.1/ Connection to 0.0.0.1 failed.
Please, help me if you can! 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. The path the error was returning is the default Documents path, and it failed to work, I must have changed something when it worked. Reply With Quote Nov 27th, 1999,05:20 PM #4 Quadrex View Profile View Forum Posts Visit Homepage Junior Member Join Date Nov 1999 Posts 26 Maybe you need to close the file
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 Structure your content using Maps and Blocks Questions? 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 https://www.experts-exchange.com/questions/22646191/MS-Word-Error-5174.html Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We
Share Share this post on Digg Del.icio.us Technorati Twitter Rory Microsoft MVP - Excel ʅ_(ツ)_ʃ Add-in for posting ranges as copyable tables (bottom of the page) - Win & Mac Posting Microsoft Office Forums > Microsoft Excel > Excel Programming Run-time Error 5174: Open Word Documents from Excel User Name Remember Me? The time now is 11:53 PM. Run-Time Error 5174 Just a value.
Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. weblink Thank you! Not the answer you're looking for? 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.
Result: This brings up the Templates and Add‐ins screen. I moved the files to the Documents directory, and it works as its supposed to. Please try the request again. navigate here Feedback?
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 Appreciate it. 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
asked 2 years ago viewed 928 times active 2 years ago Blog Stack Overflow Podcast #93 - A Very Spolsky Halloween Special Related 4Dir Function in Excel 2010 VBA not working2VBA:
All times are GMT -5. Then we would open the Word document... All rights reserved. Run-Time Error 5174 Originally Posted by MrPicture15 Just a value.
First time, no error. Solution Use the following procedure to resolve this error: Step Action 1 In Word 2007 or 2010 you need to turn on the Developer tab. Thanks share|improve this answer answered Sep 20 '14 at 19:22 Geoff Lentsch 9717 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using his comment is here Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature.
Close Box Join Tek-Tips Today! like C:\users\myfirstnam....\weeklyreports\. I misunderstood. 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
All rights reserved. Quite frustrating. I am no longer getting the error. I misunderstood.
Solved MS Word Error 5174 Posted on 2007-06-20 MS Office Windows Networking MS Applications 1 Verified Solution 4 Comments 4,156 Views Last Modified: 2012-06-22 I'm trying to open a Word file Your cache administrator is webmaster. You will find that FSPro.dotm and/or FSPro.dot is missing from the Global templates and add‐ins list. 3 Click Add and browse to For 32‐bit systems: C:\Program Files\Information Mapping\FS Pro 4.x\FSPro.dotm For In the directory there are .docx and .docm files.
Join them; it only takes a minute: Sign up vba dir function error 5174 up vote 0 down vote favorite I have been getting a runtime error 5174. 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 If not you will have to introduce some error correction. I can't do that with the above path name - there is no "Documents" folder within "U1830" - the final file is correct though.
Starting from then, it returns the error stated in the codes below: How could I fix it? Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. Try one or more of the following: * Check the spelling of the name of the document * Try a different name.This error occurs when the macro finds a file that