Home > Visual Basic > Visual Basic Error 5174

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: Connection to 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

Quite frustrating. It looks like the very first time I open a document, it's fine. I would try to re-install the visual basic runtime files. Coding Standard - haphazard application more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life

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

Registration on or use of this site constitutes acceptance of our Privacy Policy. Starting from then, it returns the error stated in the codes below: How could I fix it? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2013,06:41 AM #3 RoryA MrExcel MVPModerator Join Date May 2008 Location East Sussex Posts 28,422 Re: Trying http://digitalfishbowl.net/visual-basic/visual-basic-capture-error.html In order to provide the flexibility we need, the code first builds the name of the file to be opened using a string variable.

Privacy Policy Site Map Support Terms of Use current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Results 1 to 4 of 4 Thread: Error 5174 - File could not be found Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid 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 After that - it gives me the error.

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