What I'm looking to do is if a user downloads a qvw from access point, I want them to be able to click on a macro that sets a variable to the new qvw location, Then places a series of excels there, and rerurns the entire load script. Is there any way to get the new location of the qvw? QVWorkPath does not work as it appears to be set on reload. If i don't set the path it just puts it on C:\UserName\Documents, which i do not want.
