ADVERTISEMENT

Using ChDrive And ChDir: Check If "PPG" Exists In "C:MEASURE-6000"

Jan 14, 2010

I can not figure out why the ChDir command doesn't change to "C:" as programmed, instead it defaults to (I'm guessing last active folder) on my "D" drive (Which is "D:Test")? My goal is to check if "PPG" exists in "C:MEASURE-6000", if not use "C:" as a default.

View 2 Replies View Related

Chdir Not Working Properly

Feb 5, 2009

I have a really strange problem i have two different hard directories o: & u:

i have the following code linked to a command button

chdir "U: foldername foldername foldername"
saveactiveworkbook.saveas range("c9")

View 6 Replies View Related

Chdir Not Opening To Correct Location

Nov 16, 2006

I am running a small segment of code in which the user is taken to a specific directory to choose the correct file.

ChDir "\Intranetuserscsandsads"
strInventoryOH = Application. GetOpenFilename

The dialogue box is not opening to the correct directory. I believe there are no permission issues as I have full access to this directory.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved