empty chart after macro

I think I have it now. It reads both Def_dir and Data_File and sets thing up in both the connection string (via vba) and the command string (via a formula on the SQL page). To reset the command string, first you break it into pieces using the split command and then you change the pieces you want, and then you put it back together.