The path may include the drive. It's not working though. Log In E-mail or User ID Password Keep me signed in Recover Password Create an Account Blogs Discussions CHOOSE A TOPIC Business Intelligence C Languages Cloud Computing Communications Technology CRM Covered by US Patent. http://www.mrexcel.com/forum/excel-questions/577169-chdir-not-working.html
Appreciate your help!!! :yes nathan231411-04-2010, 05:45 AMJust to add more clarification, the error pops up when the code gets to ChDrive MyPath. Join them; it only takes a minute: Sign up Use ChDrive & Chdir for Excel via Word VBA project up vote 1 down vote favorite So, I am having some issues I used a solution that I happened to already have on my laptop on an exam.
CONTINUE READING Join & Write a Comment Already a member? What power do I have as a driver if my interstate route is blocked by a protest? The time now is 13:48. Setcurrentdirectorya xld11-04-2010, 07:43 AMChDir won't work either, but I think you can get away without that stuf MyCompletePath = ActiveWorkbook.FullName MyPath = ActiveWorkbook.Path SaveDriveDir = MyPath FNames = Dir(MyPath & "\*.xls*") If
PCMag Digital Group AdChoices unused 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 Headlines Php Chdir Not Working Basically, the ChDrive function looks at the first character of MyPath and takes that as the lettered drive. it will be..Friday...it's always been crazy... ActiveWorkbook.SaveAs Filename:= _ "\\lpofs01\groups\Engineering\LAB\MI Calculations for Offspec Types\" _ & Range("C3").Value & "_" & Range("C5").value & "_MI Calc.xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False Select all Open in Does anyone have any ideas how to go around this?
Thanks for you help! http://www.vbaexpress.com/forum/archive/index.php/t-34851.html ChDir in Excel macro save as not working jillyd asked Jun 8, 2009 | Replies (7) Can't seem to get Chdir to work in macro when saving a file - any Chdir Not Working C MyCompletePath = ActiveWorkbook.FullName MyPath = ActiveWorkbook.Path SaveDriveDir = MyPath ChDrive MyPath ChDir MyPath The problem is that once I send this macro out to others, some will run it on a Vba Chdrive I read through the link (thank you for sending!) but it is a little out of my range...When I try to insert the "Declare Function..." line at the top of the
Join & Ask a Question Need Help in Real-Time? MrkFrrl replied Jun 9, 2009 Ask who's in charge of your network to give you the rights to save the file to the requested location. Let's look at some Excel CHDIR statement function examples and explore how to use the CHDIR statement in Excel VBA code: ChDir "C:\instructions" Result: Sets the current directory to C:\instructions ChDir How to find limit of function. Excel Vba Chdir
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Sep 7th, 2011,11:31 AM #4 Andrew Poulsom MrExcel MVPModerator Join Date Jul 2002 Posts 73,092 Re: ChDir Not Working But if it is run on a network, the first character is a "\" and so it gives an error. ChDir should only be passed a drive letter, for example like this: ChDrive Left(Activeworkbook.Path, 1) share|improve this answer edited Jun 5 '13 at 21:44 answered Jun 3 '13 at 20:10 JosieP No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers
ChDir "MYDIR" ' Assume "C:" is the current drive. Vba Dir Here is the code that I am using for the command button. Would the members of an online imageboard (or any community) be able to build a post-apocalytic society upon their reputation?
Clearly I am still an ametuer at this! Weird...may be something to do with the app I use for my phone http://i.imgur.com/GyrHI.jpg 2) No, it is a network location shared by my entire building....no passwords/credentials permalinkembedsaveparentgive gold[–]vertexvortex14 0 points1 point2 Share Share this post on Digg Del.icio.us Technorati Twitter Microsoft MVP - Excel Reply With Quote Sep 7th, 2011,11:26 AM #3 markf5998 Board Regular Join Date Jan 2011 Posts 98 Re: Always saved in the same folder but new data (and thus files) every week...
Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. You won't be able to vote or comment. 456VBA help. Can the ECS work in an unpressurized cabin? MS Excel Advertise Here 772 members asked questions and received personalized solutions in the past 7 days.
Promoted by Recorded Future Do you know the main threat actor types? All rights reserved.