I went ahead and made your profile work, so if you do this you should be in good shape.
We are adding a new feature...literally as we speak here, that allows you to have pre and post scripts that execute. You would have to write a pre-script that sets the folder for you...which honestly I recommend against. This is a setting on the SQL Server side of things and when you start moving the MDF file locations...well...it becomes a full time job and your responsibility instead of SQL Servers. But if you have this need you will be able to set the folder location via a pre-execution script in the next update.
If it is not in use, then just "smoke it" but if it IS in use, then you may have to detach it first. Again, this would need to be done via a script...or manually through the Management Studio.