As you can see, the path in the error message is different to the path in my code. All contents Copyright 1998-2016 by MrExcel Consulting. 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 First time, no error. http://prcflow.com/visual-basic/visual-basic-namespace.html
Run-Time Error 5174 My apologies, I realized I did not post the relevant Excel and Windows version information. Here is some of the code I was helped out with in a previous post (Word 2010): varFile = Dir("F:\Joe\Test Folder\Test Destination\*.docx") Do While varFile <> "" Set oDoc = Documents.Open(varFile) it just won't open. 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! click resources
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 Check your macro settings in word. 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. Run-Time Error 5174 Results 1 to 5 of 5 Trying to Open a Word Doc in Excel VBa...
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 anything you can see? Modify the report design after the wizard is done to make it look better. By joining you are opting in to receive e-mail.
The application runs in Windows 7 64-bit using Excel 2010 32-bit. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices. 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 useful reference It's a 6 digit identification number.
I am no longer getting the error. All times are GMT -5. You may have to register before you can post: click the register link above to proceed. Following adding the file, the code will go through all files in the directory like it should.
How should I deal with players who prefer "realistic" approaches to challenges? http://www.vbforums.com/showthread.php?359-Error-5174-File-could-not-be-found Run-Time Error 5174 within the Excel Questions forums, part of the Question Forums category; Hello all, I have been reading this forum for years and have found much helpful information, so Why cast an A-lister for Groot? You may have to register before you can post: click the register link above to proceed.
Starting from then, it returns the error stated in the codes below: How could I fix it? this content I realized I was getting the error because my code didn't know which directory to find the files. 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 After that - it gives me the error.
What I am trying to do is provide a method for users to edit reports that are generated by an application my team developed. I've tried other solutions I found here to no effect. Close this window and log in. weblink Quite frustrating.
But for some reason my looping doesn't work. 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 What grid should I use designing UI for the desktop app?
Join UsClose Register Help Remember Me? 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! like C:\users\myfirstnam....\weeklyreports\. http://www.microsoft.com/downloads/details.aspx?FamilyID=bf9a24f9-b5c5-48f4-8edd-cdf2d29a79d5&displaylang=en Go to Solution 4 Comments LVL 11 Overall: Level 11 MS Applications 2 MS Office 1 Windows Networking 1 Message Expert Comment by:bloodymalth52007-06-20 Usually the 5174 error means that
Get 1:1 Help Now Advertise Here Enjoyed your answer? 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 So when I used the open method I added the path before the variable which stored the filename. http://prcflow.com/visual-basic/visual-basic-6-runtime-error-70.html I just needed to read the documentation on the Dir function.
If this is your first visit, be sure to check out the FAQ by clicking the link above. Please try the request again. Now that it works on another path, it's pretty sure the code isn't the issue. 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
To start viewing messages, select the forum that you want to visit from the selection below. Connect with top rated Experts 16 Experts available now in Live! Rob Red Flag This Post Please let us know here why this post is inappropriate.