This time I am trying to change from the workbook I am in (where the VBA code is located) to another workbook whose name is a string value of a specific cell in the VBA code workbook. Coming back to the original workbook is no problem as its name and location is static. I then need to save the destination file in a dynamic directory that will be based on the string value in a specific cell. I have tried all kinds of things to get this to work. ANy ideas?