I want the excel file to open automatically during the computers startup. The way that I have decided to go about doing this is to write a batch script that opens the excel file and to then put that batch script in the computers startup folder.
The problem I am running into relates to the batch script. The RTD feed does not work if I use the default shortcut for excel. Instead I have to use a shortcut that has the following target line:.
If I open it using the first bash script the RTD feed doesn't work. If I try to run the second script the bash script doesn't run. First, I'd recommend using a scheduled task over the startup folder consistent behavior.
It looks like you may be passing the arguments out of order for the Excel exe. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?
In its simplest form, a batch file or batch script is a list of several commands that are executed when you double-click the file. Batch files go all the way back to DOS , but still work on modern versions of Windows. PowerShell scripts and Bash scripts may be more powerful, but batch files can still be plenty useful if you need to run basic Windows commands.
A batch file is simply a text file saved with the. Give it any name you like, but replace the default. You now have a batch file with the. Double-click it to run it. When you want to quickly run commands without seeing the output, you can omit this. The only thing you need to change is what you type into Notepad. To run several commands, you type each one on its own line and the batch file will run each one in order.
In the most basic form, we could simply place all those commands in a batch file, one after the other, like so:. For example, you might want to add comment lines. This is typically added to the start of most batch files.
There are other directions you could go with a batch file like this. For example, you might want to have your batch script run the above commands and then dump the output to a text file you can view later. The Command Prompt window will automatically close once the batch file is done running. However, many batch files are designed to be run non-interactively. For example, you could have a batch file that deletes multiple files or directories whenever you double-click it.
However, batch files can actually be significantly more complex than this. This is more like writing an actual small program than a quick and dirty script.
But now, you know the basics of how to throw a simple one together. The double quotes are removed by the following details are here :. You can then access the path by using! It doesn't contain any double quotes, so it is safe to say "! It removes the parameter using shift. To avoid having to register the.
Now the script honors command line parameters being passed to it. According to Artjom B. Optimized script structure, improvements added variable vbsGetPrivileges which is now referenced everywhere allowing to change the path or name of the file easily, only delete.
In some cases, a different calling syntax was required for elevation. It will add cmd. ADBailey has reported this. This is especially useful if you need to enclose parameters like paths in double quotes, e. As jcoder and Matt mentioned, PowerShell made it easy, and it could even be embedded in the batch script without creating a new script.
This way it's simple and use only windows default commands. It's great if you need to redistribute you batch file. Anyway, I find this way simpler than the other solutions proposed on the other answers, I hope it helps someone. I am using Matt's excellent answer, but I am seeing a difference between my Windows 7 and Windows 8 systems when running elevated scripts. Fortunately, there is an easy workaround by changing the current directory to the path of the current script:.
To test this, you can copy the following to a script. Run normally on either version to see the same result. Run as Admin and see the difference in Windows Matt has a great answer, but it strips away any arguments passed to the script.
Here is my modification that keeps arguments. I also incorporated Stephen's fix for the working directory problem in Windows 8. You can have the script call itself with psexec 's -h option to run elevated. I'm not sure how you would detect if it's already running as elevated or not Or, you could simply have the commands for the xcopy and reg. I use PowerShell to re-launch the script elevated if it's not. Put these lines at the very top of your script.
I copied the 'net name' method from Matt's answer. His answer is much better documented and has error messages and the like. This one has the advantage that PowerShell is already installed and available on Windows 7 and up. This method should work without any configuration or setup, as long as your PowerShell execution permissions aren't locked down. Check this :. Though like this there will be no UAC prompting the user will continue without admin permissions.
I wrote gsudo , a sudo for windows : that elevates in the current console no context switching to a new window , with a credentials cache reduced UAC popups , and also elevates PowerShell commands. It allows to elevate commands that require admin privileges, or the whole batch, if you want. Just prepend gsudo before anything that needs to run elevated.
EDIT: New one liner version that works with any windows language and avoids whoami issues :. See gsudo in action:. I recently needed a user-friendly approach and I came up with this, based on valuable insights from contributors here and elsewhere. Simply put this line at the top of your. Feedback welcome. I got this idea from this SO answer.
Most of the answers here feature net file instead though which works the same. This command is fast and compatible on many systems. The error level is then checked with the operator. If the check succeeds then it creates and executes a WScript which re-runs the original batch file but with elevated rights before deleting itself.
The WScript file is the best approach being fast and reliable, although it uses a temporary file. If the cmd file is long I use a first one to require elevation and then call the one doing the actual work. If the script is a simple command everything may fit on one cmd file. Do not forget to include the path on the script files. Although not directly applicable to this question, because it wants some information for the user, google brought me here when I wanted to run my.
The simplest approach was to create a shortcut to the. If there are none, PowerShell restarts the current script with its arguments in an elevated shell, and the non-elevated script closes. Inside zip you should find two files: Elevate. The latter is a native bit compilation, if you require that, although the regular bit version, Elevate. Copy the file Elevate. On Windows 10, there are two aliases available for the Invoke-WebRequest cmdlet: curl and wget.
So, to download a file from the Internet website, you can use a shorter command. Instead of typing a full cmdlet name, you can use for example :.
0コメント