I have a vbs file that is scheduled to open up an excel spreadsheet as follows:
Dim objShell:Set objShell=CreateObject("Wscript.Shell")
sRun="cmd /k Start excel " & chr(34) & "M:\Bloomberg\NBF LDN\NBF-BBG-DOWNLOADS" & chr(34)
objShell.AppActivate "Window title" 'of the program's popup
objShell.SendKeys "~" 'send Enter key
What I would like is to have an addition to the code that allows for the spreadsheet to be opened up but without establishing any links.