I am working on an Excel-document to make a (project-)folder structure manageable, using
HYPERLINKs to important files and folders (Word/Excel, etc.).
Since we are also using TFS, I want to add the possibility to check out and check in right from within the Excel sheet. The one-stop landing and overview page.
If I simply have
I get a security warning, but the program executes.
In the end, I want something like
=HYPERLINK("C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\TF.exe status $/MyProject/Documents /recursive";"Find local Check Outs in Document folder")
However, this does not work for spaces in the file path and also for the command line arguments. Is there any way to make this run without using VB? Even if I wrap parts of the hyperlink with quotes (using double double quotes for Excel: "" -> ") does not improve anything, I get "file not found" error.
And.. only only only if I have to use VB (I do not like the security warning), what would be the best way to do this?