Questions tagged [automation]
Making a process run completely or in part without the need of any user input once the process is started.
1,339
questions
-1
votes
0
answers
17
views
Automatically run a macro in Word whenever I perform a specific action
I would like to write a macro similar to the Auto Macros described in Microsoft, but these are limited to a few actions like open and close, and I'm looking for a general method that could be used for ...
- 19
0
votes
0
answers
7
views
Mailutils sending automatic personalized emails from my gmail account
I want to create a script (or use one if it exists) that will do the following:
Personalize the body of the text based on the name/email of the recipient (i.e., Hello {name}, bla bla…)
...
-1
votes
0
answers
27
views
How do I automatically generate subtitles for a 3-hour-long movie?
Sorry I don't have anywhere else better to ask this question
I have a Japanese video that is 3 hours long. There are two-people conversations throughout the mp4 video with long pauses in between. I ...
0
votes
1
answer
24
views
Keep User Instance Signed-in, Signing back in, if signed out
We have a requirement to have an executable running on a specific user's profile to enable our reports to run for some 3rd party software we use.
It's fine if the session is 'disconnected'.
Auto-boot ...
- 1
-1
votes
0
answers
43
views
How to automatically insert a table based on cell value
I have a question that I'm not sure is doable but I want to try anyway.
I am creating a form where depending on the answer, I want a table to populate. For example:
Question 2: How many substances ...
- 1
0
votes
0
answers
17
views
How to automate a process in hex editor
Im trying to make a mod work for ps4 which according to a video basically requires extracting a file, going in the folder, opening the xml file in hex editor, going in hex editor and replacing win64 ...
1
vote
0
answers
31
views
How To Add VPCS To Cisco Packet Tracer 8.2.1?
I am trying to automate tasks in packet trace version 8.2.1, and I am trying to run some commands on a group of routers using a Python script as described by chatGPT. Here is the script:
# Define the ...
- 149
0
votes
0
answers
42
views
Can't run Start-Process with RunAsUser from .ps1 file
Wrote a script that copies a .exe file to a folder then tries to run it as another user but the Powershel window just closes without running the .exe.
The command that runs it works fine if I run it ...
- 1
0
votes
1
answer
31
views
How do I make an applescript that waits for an application to start then quits the application?
I want to make an applescript that when started, will wait for an application to open then quit out of that application.
Here is my code:
repeat until application "Steam" is running
...
- 1
0
votes
1
answer
56
views
Indicate the window is "always on top"
Good day!
I would like to add a red border/shadow to the window that is Always on top to identify its state. At the moment my way of identifying it is by reducing the opacity.
Any recommendation? ...
- 21
0
votes
0
answers
31
views
How to automatically move a window to secondary display on MacOS?
At the end of recorded Zoom calls, a transcoding window appears for a long time, floating above all other Windows. Quite a nuisance.
I'm looking for some automated solution, eg an AppleScript that ...
- 9,593
0
votes
0
answers
25
views
Can't get Winlogon automatic restart sign-on (ARSO) to work on a specific machine
I'm trying to get Windows ARSO to work on a machine but am unable to. (Windows 10 Pro 22H2)
It runs on other machines just fine, but not this specific machine. I've read through and double checked the ...
- 312
0
votes
0
answers
22
views
Open multiple files at once not after one another with Automator
I am trying to create an automator script to export selected Fotos and open them with Outlook to send via email. Outlook does not support the share sheet and that's why we have to take this detour.
My ...
- 1
0
votes
2
answers
84
views
Is there a way to automate 'control userpasswords2'
The command 'control userpasswords2' displays a GUI that allows you to set it to where users are not required to enter a username and password to login. If you uncheck it and hit apply, it prompts ...
- 111
0
votes
1
answer
78
views
Start a VMWare guest on the second monitor automatically?
I'm trying to automate some daily chores, one of them starting a virtual machine on my secondary screen.
Right now I have to
start VMWare Player (automated already)
drag the Player window with mouse ...
- 197
0
votes
0
answers
56
views
Fully automate Windows Install from Boot drive
I have a few things that I have not been able to automate with the Windows Setup. I have made an Unattend.xml file which does most of the heavy lifting. However, there are somethings that I am ...
- 1
0
votes
0
answers
42
views
Upgrade powershell version 2.0 to version 4.0+ using cmd or powershell
I have a problem, I work in a large organization we have several computers with windows 7 and many of them are very old versions, and come with a powershell 2.0.
I was creating some scripts to solve ...
Arthur Gonçalves
0
votes
0
answers
65
views
Windows 10 Answer File: How to automate Edition Selection
I work for an MSP where my job is mainly to take the computers that we receive from Dell and reimage them. I have automated part of the setup with an answer file. Specifically the part after windows ...
- 1
0
votes
0
answers
34
views
Excel formula to give a certain value based on referencing 2-3 rows, help in reducing the manual work
I am searching for the formula which looks for value"X" in the column J, if the value in J is "X" I want the formula to look into column H and refer the concerned row, the row ...
- 1
0
votes
0
answers
84
views
how to automate adding new data every month
Every month, I add new data from csv file to an excel table. How can that be automated? Looking at the table photo I attached, I have two questions:
I want to automatically add new columns with data ...
0
votes
1
answer
208
views
variables for an SFTP transfer script
I am attempting to do the following:
export a database (maybe make a .tgz of it, that's trivial)
pack up a whole tree into a .tgz
copy both files into a named directory on a different server.
I can ...
- 33
0
votes
0
answers
138
views
Mac Ventura 13.2 Show Current Resolution of Main Display
How can I use AppleScript or Terminal to ascertain the current resolution of the main display if I have two? Currently, main display is 2021 MacBook Pro 16" (Silicon, M1) and extended display is ...
- 101
1
vote
1
answer
301
views
How to add lines above and below a certain line in Powershell based on regex pattern?
03,201779,,01354,73923309,,,TEST2,7962753,,,0343,5087632,,/#end of line
04,399,777873,,,,text234,,,,/
33,TEST1,,,0343,,93493,,,343,,,,TEST3,,,,,,/
37,TEST37,text
49,24605597,6,343,343,343,,,3434,,,/
...
- 11
0
votes
1
answer
53
views
Why isn't File Explorer immediately affected by Task Scheduler's light/dark mode toggler?
Through Task Scheduler, I set up Windows to automatically switch between Light and Dark Mode. However, although the process works overall--for example, Outlook, Word, Firefox, etc. all seem to work--...
- 77
0
votes
0
answers
75
views
Vagrant + Virtualbox cannot `sharedfolder add` during VM provisioning
I am automating the provisioning of a custom Ubuntu Server 22.10 (custom-built with packer) in Virtualbox using vagrant. During provisioning I get the following error:
2023-01-12T07:39:14.671+0200 [...
- 101
1
vote
1
answer
440
views
How to open MS Edge as minimised with task scheduler?
I created a scheduled task to open MS Edge with task scheduler and wanted to open it minimised.
I tried the arguments: /background , /min but it did not seem to work. Edge still opens maximised. ...
- 11
1
vote
1
answer
177
views
Automatically adjusting Windows' screen brightness through task scheduler
I have been trying multiple apps, but I do not know how to adjust Windows' screen brightness automatically. Is there a way this can be done through Task Scheduler?
To give a specific scenario, I'd ...
- 77
2
votes
0
answers
70
views
Is there a way to ease the pain of setting Windows 11 file associations?
I just used Windows 11 for the first time and the file association business there is really awful, I have to set every single extension one by one to my preferred application. Whereas on Windows 10, I ...
- 595
0
votes
1
answer
193
views
Is there some way to make a foobar2000 playlist automatically track and update its file paths?
I have a lot of poorly named music files. They are poorly named because when they were digitized or converted, there either was no metadata at all, or it was incomplete/inconsistent, etc.
Manually ...
- 9
0
votes
0
answers
26
views
How to print PDF along with some text metadata of it on the same page?
I would like to print PDFs (Invoices received) along with the additional metadata corresponding to those PDFs(my purchase records) on a single page. I have tried MailMerge initially, but at maximum, ...
- 1
0
votes
1
answer
27
views
How to reassign previous Bitlocker encryption to new system disk
My previous PC had 2 disks and both were Bitlocker encrypted with password. I remember vaguely that I could configure it in a way that the second disk will be unlocked when the first disk got unlocked ...
- 121
0
votes
1
answer
72
views
How can I bypass this message on Windows Server 2022?
I got following cmd command and I want to start an .exe installer with this, but when I execute it the message after it pops up.
START "DSM-Agent setup..." /WAIT /D %PATH% InstallClient.exe
...
- 1
0
votes
0
answers
32
views
Provisioning ubuntu from another install or from infrastrucutre as code
I am gona get a new (portable) computer soon and plan on using a dual boot linux/windows on it. The windows will be "just in case" and the linux will be my daily OS.
I want my OS to be fully ...
0
votes
1
answer
49
views
Automation on Windows: Launch/close of second app due to launch/close of first app
I want to create an automation on Windows 10 where if I open the first app, I want to a second app (predetermined) to open up as well. And when I close the first app, the second app should close as ...
- 3
0
votes
0
answers
42
views
Auto delete video after uploading on youtube
Is there any tools that will auto delete video from my hardrive after I uploaded it on youtube?
I uploading tens of videos regularly and it often hard to see what I can delete and what not.
0
votes
1
answer
308
views
How to pass the credentials window with wds and an xml file on startup?
Good morning,
I installed a windows server 2019 with the Windows Deployment Service (WDS) in standalone mode and I am trying to skip the configuration steps with an xml reply file, which is supposed ...
- 1
1
vote
0
answers
34
views
What is a more reliable way to scan for user commands that will run administrative commands on a user system?
On an AD domain, with a Windows 10 "deployment server" and 50 other Windows 10 hosts, I want to add a way for users to make LOCAL GPO changes by issuing a command. Each user has their own ...
- 357
0
votes
1
answer
104
views
Automating a repeating pattern across multiple worksheets
TL;DR: I need to automate a cyclical pattern that repeats over intervals that span blocks of cells across multiple sheets.
So... I have a spreadsheet that I maintain for our work group that we use for ...
- 390
0
votes
2
answers
84
views
Excel move into data table with enter key only
I need to enter data into Excel using a bar code scanner which add a "enter" key press at the end of the scanned code. I need to scan two codes on a device and link them in a database. ...
- 123
0
votes
0
answers
37
views
How can I configure Firefox to load a bookmarklet just after loading any URL under a specific domain?
Imagine a web example.com + a bookmarklet that powers example.com up
Suppose a page example.com for which I don't control the source code, but I use on a daily basis (imagine any 3rt party cloud ...
- 493
0
votes
1
answer
504
views
MS Excel: generate a table with the number of rows depending on the input variables
So I want to make a matlab/r-like tool in excel that mimics more code driven calculations than the more common excel worksheet applications typically contain
This workbook should contain:
input sheet
...
- 103
0
votes
0
answers
361
views
How to automatically connect to WiFi once ethernet stops working
So my problem is fairly easy:
The wired ethernet connection stops working from time to time but stays connected.
What I want to do is keep the WiFi turned off, or at least disconnected, as long as the ...
0
votes
0
answers
113
views
Autocomplete text
Here's a doubt, there is a tool that has the autocomplete function (such as https://www.autohotkey.com/board/topic/60998-autocomplete-12/) with the addition that if I start to write another word and I ...
- 1
1
vote
0
answers
59
views
Set up a new PC with Windows 10 - More efficient/quick with cmd or powershell
Sometimes i have to set-up a few new pc's with windows 10 professional x64.
The system is already installed.
When i turn on the PC i get to the first-time-login screen and have to set various options
...
- 21
0
votes
1
answer
52
views
Have Excel move user input into another sheet and clear the original sheet
I did quite some looking around trying to find a solution for this but came up empty.
What we are trying to do is build an excel file that basically has 3 sections. We want to use it to monitor the ...
0
votes
0
answers
106
views
How can I trigger my gaming mouse driver software to run automatically when I plug in my mouse on a windows 11 laptop?
I use a RedGear Manta gaming mouse, and its main driver and optimization software is a ".exe" file and has to be started after plugging in the mouse every time. The mouse itself does ...
- 1
0
votes
0
answers
33
views
Is there a way to open a specific program when the laptop detects a mouse is connected?
I am using an application called Fastkeys which is a gestures app, but it only comes in handy when I am using a mouse.
So is there a task scheduler script that I can use to automate opening this ...
0
votes
0
answers
29
views
How to automate splitting clips into segments, shuffling them and joining them again?
Right now I am doing these 5 steps manually:
Split a clip into 15 second segments with: ffmpeg -i "funnyvideo.mkv" -ss 0 -f segment -segment_time 15 -vcodec copy -reset_timestamps 1 -map 0:...
- 1
0
votes
0
answers
376
views
Auto Restart Minecraft Server?
The server is ran with a start.bat file. Is there anyway I can run something that will auto restart that file if it stops (Internet goes offline, computer reboots, etc)
- 1
0
votes
1
answer
300
views
How to return a specific cell if another cell is equal to a given value, and also counting the amount of returned values (without duplicates)
Currently I'm working on automating a small Excel file (see screenshot). So I have a list of standard themes, and a code that I have to fill in manually (this can't be automated). Next to that I have ...
