Leith, It effects only one workbook. I have a subroutine that creates a new directory with name "east_rfi_x" where x is a number developed in another subroutine, then changing the directory with ChDir to the previously created directory, then saving the current work book into directory "east_rfi_x" with the name "east_rfi_x.xls". For some reason, ChDir has worked maybe 3 times today but doesn't work everytime. I am kind of at a loss as to why. The majority of the time, the new directory is created with the correct name, however the associated workbook is saved in "My documents". I'd really appreciate any insights you might have and apologize in advance if I haven't been clear. Sterling
Hello Sterling, Can't say that I do. I have never had a problem using ChDir. Is the problem isolated to a single workbook or VBA project or does it effect all workbooks? Leith
Find latest posts