Visual Basic Error 5174
Close Box Join Tek-Tips Today! 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 Also I have not encountered path's too long / too deep causing an error. –Alex Aug 5 '14 at 20:03 | show 1 more comment up vote 0 down vote accepted Join & Write a Comment Already a member? http://digitalfishbowl.net/visual-basic/visual-basic-namespace.html
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 Hope it helps. Another one guys, I have tried to solve it but I'm not getting anywhere anymore. All rights reserved.
This assumes that strPath exists and that the bookmarks and content controls exist in the documents. 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. 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. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed
Microsoft Office Forums > Microsoft Excel > Excel Programming Run-time Error 5174: Open Word Documents from Excel User Name Remember Me? What is the macro trying to run do? 0 LVL 11 Overall: Level 11 MS Applications 2 MS Office 1 Windows Networking 1 Message Expert Comment by:bloodymalth52007-06-20 Also look at Check your macro settings in word. https://www.experts-exchange.com/questions/22646191/MS-Word-Error-5174.html Thank you!
What does a `#` attribute do in HTML? Give it a shot. Run-Time Error 5174This is a discussion on Trying to Open a Word Doc in Excel VBa... 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
The real path is like C:\users\myfirstname.lastname\Documents\work\weeklyreports? 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 Why was Vader surprised that Obi-Wan's body disappeared? Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action.
Here's my code: Set wrd = CreateObject("Word.Application") fileout = "C:\Test.rtf" wrd.Documents.Open fileout Reply With Quote Nov 24th, 1999,02:30 AM #2 netSurfer View Profile View Forum Posts Hyperactive Member Join Date Jun his comment is here 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 The file DOES exist!!! Then you appear to be missing at least the Drive information from the file path.
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. Share it with others Like this thread? 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 http://digitalfishbowl.net/visual-basic/visual-basic-2015-pdf.html I realized I was getting the error because my code didn't know which directory to find the files.
The path the error was returning is the default Documents path, and it failed to work, I must have changed something when it worked. Get 1:1 Help Now Advertise Here Enjoyed your answer? RE: Run time error 5174 I don't know why RobBroekhuis (TechnicalUser) 23 Oct 03 07:52 Please post your code Rob RE: Run time error 5174 I don't know why PleaseGiveHelp (Programmer)
I've run Debug.Print to output the string that was created and it matches character for charater with the path and file name of the report I want to open.
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 Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? 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 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
Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Resources Jobs Join & Ask a Question Need Help in Real-Time? Like I said it will run if I add a .doc file in the directory, and also if I don't use the Dir function, and add a file in the path, Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum!
Connect with top rated Experts 16 Experts available now in Live! I just needed to read the documentation on the Dir function. However, this article shows that the latest Office 2016 apps (installed with an Office … Office 365 MS Office Office / Productivity Document Imaging Document Management Defensive Browsing Article by: Kiefer I know the path is correct.
Run-Time Error 5174 What is in B6? Please try the request again. Not the answer you're looking for? 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?
Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. Why cast an A-lister for Groot? 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. If this is your first visit, be sure to check out the FAQ by clicking the link above.
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 = By joining you are opting in to receive e-mail. Just a thought. ------------------ Quadrex [email protected] Quadrex Programming Reply With Quote Quick Navigation Visual Basic 6 and Earlier Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home