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 Join Now For immediate help use Live now! LEARN MORE Join & Write a Comment Already a member? All rights reserved. check over here
Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. brain dead. How or where should I add a required connection string for a feature in Helix? Join UsClose Register Help Remember Me?
Generated Mon, 31 Oct 2016 21:33:11 GMT by s_mf18 (squid/3.5.20) Register Help Remember Me? Portal Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Knowledgebase Articles If this is your first visit, be sure to check out the FAQ by clicking the link above. 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 Then we would open the Word document...
Run-Time Error 5174This is a discussion on Trying to Open a Word Doc in Excel VBa... Ive put it below. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Following adding the file, the code will go through all files in the directory like it should.
SUBSCRIBE Join & Write a Comment Already a member? You may have to register before you can post: click the register link above to proceed. Quite frustrating. Join Now For immediate help use Live now!
Suggested Solutions Title # Comments Views Activity Merge two cells into one cell in Excel 2013 6 27 13d VBA: export, split csv file every x lines 13 27 11d Assign The time now is 02:33 PM. All rights reserved. Trying to convert text to t… MS Word CommandBars (Part III) - Using Built-in Shortcut Menus Article by: Dale Fye Preface: When I started this series, I used the term CommandBars
To start viewing messages, select the forum that you want to visit from the selection below. check my blog In the directory there are .docx and .docm files. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2013,07:14 AM #5 RoryA MrExcel MVPModerator Join Date May 2008 Location East Sussex Posts 28,422 Re: Trying 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
It all just depends on what you want to be in there and what exactly you want this to do. Not the answer you're looking for? It doesn't get to all of the files...Sub Merge()'' Merge Macro' Macro created 10/22/2003 by ssga'Dim strcurrentfilename As VariantDim Wrd As Word.ApplicationDim newcurrentfilename As StringDim firstnine As StringDim originalfilename As StringDim this content I can't do that with the above path name - there is no "Documents" folder within "U1830" - the final file is correct though.
Movie about encountering blue alien In the future, around year 2500, will only one language exist on earth? Can Wealth be used as a guide to what things a PC could own at a given level? After that - it gives me the error. The directory and the files are correct.
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 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 Rob Red Flag This Post Please let us know here why this post is inappropriate. have a peek at these guys ive placed some code below with an attempted change that you suggested.
it just won't open. 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) 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. The real path is like C:\users\myfirstname.lastname\Documents\work\weeklyreports?
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 = Not only that, but the path in the error message - as far as I can tell - doesn't exist. I misunderstood.