Questions tagged [automation]
Making a process run completely or in part without the need of any user input once the process is started.
0
votes
0answers
3 views
How can I create an automatic calorie counter in excel with a reference database?
I have a small database of nutritional facts of the foods I eat on a daily basis.
Right now, to calculate daily intake, I put the information in individually for each unit of food consumed. I'm ...
0
votes
0answers
10 views
OS level role/command based privileged escalation for use with automation via a front-end/back-end process with additional authentication
I want to develop a LAMP web app/solution and after a fair amount of searching I am starting to think it is not possible to do what I want. Not sure how to explain this succinctly so I apologize for ...
0
votes
0answers
15 views
How do I programatically check disk partitions on windows 8 and 10?
I'm aware of diskpart, but that doesn't work in my case because I need to do this programatically, with no user input. diskpart doesn't provide any output when you give it a script so my program can't ...
0
votes
0answers
25 views
Automatic file copying upon phone USB detection, how to? [on hold]
So I just bought a Note 9 for college purposes and since I rely a lot on the camera and scans in my college life, I want to create an automated response to connecting my phone to my windows desktop, ...
0
votes
0answers
15 views
Apply changes made to one file to other files [closed]
I will describe my problem in some simple scenarios, then ask the question, and finally discuss a bit how I imagine a solution could look like.
Consider the scenario that I do a research and put a ...
0
votes
0answers
28 views
Including .msp updates for Microsoft Office in the Updates folder for initial installation
I read this technet blog post about including .msp updates for Microsoft Office in the /Updates folder in the installation directory for Microsoft Office.
I downloaded and extracted all the .msp ...
0
votes
0answers
13 views
PPTX with linked presentation slide objects - Source file changes name - How to automize the fix/update
I have created this "Master Presentation Deck" in powerpoint consisting mostly of linked powerpoint presentation slides from other presentations. The whole idea is that we need a master presentation ...
1
vote
0answers
43 views
Windows .. utility for installing on a number of networked machines?
I'm not a power user of Windows, so wondering about the following:
In the lab we have sets of PCs - generally Windows10 if it matters. So there are usually 6, 2 or 5 such PCs, sometimes more.
(FTR ...
0
votes
0answers
22 views
Possible to stop ansible and run an autoit script non-silent?
I have a vast ansible script i run. But there are some things I need to do manually but can do they via autoIt. Is there a way to run win_shell or win_command so that ansible let's autoIt run in the ...
0
votes
1answer
47 views
Windows 7 Ultimate: replace “Hibernate after” with “Shutdown after”
Sometimes I put my laptop to sleep (suspend to RAM, not hibernate), but could happen that I don’t reactivate it for days: in such case, despite the fact that the sleep state consume little percentage ...
0
votes
0answers
44 views
How to automate “Windows Welcome” with unattended installation
I'm successfully automating my Windows 10 installation using an unattend.xml file. Everything runs and installs without a single user prompt.
My image contains multiple scheduled tasks, some of them ...
0
votes
0answers
17 views
Skype For Buisness Auto-Reply Add-in Suggestions
Are there any decent Skype Add-ins or a feature in Skype that I can set up an auto-reply for incoming chats?
I looked at Pamela For Skype, but it didn't work and checked for features built within ...
0
votes
1answer
53 views
How to programmatically upload files to Telegram?
Since Telegram is an infinite cloud service, I use it as a secondary backup location. I would like to automate this so that I don't have to remember to do it every month (in the last two years I ...
0
votes
0answers
32 views
excel 2007 hyperlink function to link cell to pdf in same folder
I am completely new to this and trying to find a way to save time creating hyperlinks so I can quickly find drawings.
I have a spreadsheet which lists drawing numbers in one column, has their ...
0
votes
0answers
65 views
Calling Documents.Open for Word.Application Error converting msoFalse to type Object
How can the Documents.OpenNoRepairDialog method be invoked by powershell with all the parameters supplied at least up to the point that word documents open without errors, dialogs, or macros; and that ...
0
votes
1answer
96 views
Chromium-Browser Kiosk Mode
I am running a Raspberry Pi with Chromium-Browser in Kiosk mode. The purpose is to make available an ADP clock-in/clock-out Kiosk for employees in our building's entrance.
@/usr/bin/chromium-browser -...
2
votes
0answers
52 views
Is there any way to script Windows 10's “color filter” feature programmatically?
I'm trying to get Windows 10 to emulate the new "Digital Wellbeing" feature that Google released alongside Android 9. Basically it changes the screen to grey-scale at night-time to try and incentivize ...
3
votes
3answers
33 views
Add only working days in grid style using Microsoft Excel
I like to have a calendar date view of the five working days in Excel.
I manually built a first row with dates from 30th July 2018 to 3rd Aug 2018 (Mon to Fri, which are working days) and a second ...
0
votes
1answer
70 views
AutoHotKey: How to make my script run only within a specific program?
I have made an AHK script that adds metadata to video clips within Avid Media Composer (video editing software). It does this by entering all the necessary sub-menu's and sends mouse clicks to ...
0
votes
0answers
38 views
How to Merge a layer automatically from different Group and save as JPG in Photoshop
I have 3 Different Groups having the same layer but different in positions in Photoshop. Now I want to show only layer 1 from all group and save as Jpg then show layer 1 from Group 1 & Group 2 and ...
0
votes
1answer
67 views
Set display option by getting working area uses in a .bat
I'd like to make a simple .bat to set the right display option depending of screen usage. Can you help me out?
I don't see what's not working with what I've done so far, but I only have little ...
1
vote
0answers
19 views
Python - Press key after certain program runs
So I have this program that has to be running 24/7, and whenever it crashes, this window pops up
And all I wanted to schedule is an enter keypress whenever either this program runs or this window ...
2
votes
1answer
43 views
What is the proper way to to automatically reboot a Windows Server? [closed]
I started this little venture maybe 15-20 years ago. All Windows Servers need to be rebooted every other week to keep them running right. I started out using a little utility called "Power Off" to ...
0
votes
1answer
52 views
Set zoom for built in display?
Is there a way to set the zoom for the internal display? I know if I were to use powershell to input:
$Host.PrivateData.Zoom = 150
it would zoom just the powershell window to 150%. I need "...
1
vote
1answer
13 views
Opening a URL from the terminal in different spaces macOS
If I run open https://example.com from the terminal and then switch to another space with a safari window open and run the same command, the safari window in my current space will just get focused and ...
0
votes
1answer
95 views
How to easily reconnect to hidden WIFI network - Windows 8
If I turn off my laptop when it is not connected to the hidden WIFI I use, I have to manually select the "hidden network" item in the WIFI network list, then enter the SSID, and then enter the ...
0
votes
0answers
31 views
How to schedule Windows Update to run on closed lid at night?
I am trying to figure out a way to schedule Windows Update at night, for example between 04:00 and 06:00 on my laptop even if the lid is closed and the laptop is in sleep mode. I don't think there is ...
0
votes
1answer
109 views
Automatic formatting of axis in Excel stacked bar chart to start at start date?
I have used this blog https://peltiertech.com/excel-gantt-charts/#comment-1455520 to create a Gantt chart in Excel that acts as a template for others to input their information (i.e. tasks, start ...
0
votes
0answers
25 views
Run OptiPNG automatically for every new png file created in a directory
Is there a way to write a batch command to constantly watch a specified directory and when it finds a new .png file, it automatically runs OptiPNG on that file?
0
votes
1answer
43 views
Can I set a default imported picture width in Word 2016?
Background:
If I drag an image into a Word 2016 doc, a sufficiently large image is automatically scaled to fit within the left and right margins, and a smaller image is scaled to a width proportional ...
0
votes
1answer
84 views
Add an <h1> tag from filename on Linux
I have a folder with a bunch of html files and I wish to add an
<h1>Filename without extension</h1>
line just after the <body> tag.
How could I go about having a script or one-...
1
vote
1answer
83 views
Auto attach a file to a specifc email template
Every morning i have to update a file with some data and then send it to people and its getting a bit laborious having to attach the same file over and over again each day.
I have a template with the ...
0
votes
0answers
10 views
Is it possible to use Automator to print a new page from where it left of?
Sorry if the title is not clear.
To give you a real life example, my printer stops working if I print more than 20 pages. And I have a 400 pdf file I would like to get it printed using Automator.
...
0
votes
0answers
119 views
Automate Plink serial connection
To open Plink using Python in Windows, I use Subprocesss.Popen().
I would like to create a script that interacts with the Plink console, after the opening of the Serial session, by entering the login ...
0
votes
0answers
48 views
Automatization of port scan proccess
I have a task in my company, that I need to scan all open ports from my external range of IP's and I need to create something to do this task every week or month and update the results with the new IP'...
2
votes
0answers
82 views
Automating creation of this chart in Excel 2016
I am trying to figure out a way to create this graph automatically on Excel and link it to PowerPoint so that when the data in Excel gets refreshed, the PowerPoint chart gets updated as well. ...
0
votes
0answers
35 views
Any way to pull multiple images out of a single png, by whitespace / transparency?
I have a file with a bunch of cleanly separated objects, but I need them as separate .pngs or photoshop layers.
I've looked into imageMagick and Mogrify's trim options, but they only seem to trim ...
2
votes
0answers
80 views
Automated webpage browsing [closed]
I want to find a way to open https websites in my browser (or any other script-based way??) while running tshark or wireshark. My goal is to collect the ssl dialogues and then via tshark I can export ...
0
votes
0answers
99 views
Firefox Quantum / Chromium: How to trigger page update from script?
Sometimes I'm working with HTML-generators like Sphinx, etc. which continuously generate new versions of HTML content which I'd like to see instantly in my already opened browser. (best case: editor / ...
0
votes
1answer
38 views
How to automate the creation of pdf's? [closed]
I want to create multiple pdf's that look like this :
"Hello , {Name}!
... some generic text ..."
where {Name} takes values from a csv file .
How can I automate this process?
0
votes
0answers
196 views
Changing the color of multiple series in a stacked bar chart in excel
I'm attempting to make something akin to a Gantt chart in Excel. Each data point I'm working with has a start date and an end date. The data also contains categories. I'm attempting to make a ...
6
votes
4answers
816 views
How do I backup & archive files automatically in Windows? [closed]
I am looking for a way to automatically backup and archive certain files on my hard drive to a NAS in Windows 10 pro 64bit. By that I mean that I can add files to the directory on my disk and it will ...
-4
votes
1answer
72 views
Automate the “Reset this PC” process
On one of my Windows 10 PCs, I perform the "Reset this PC" process every week, removing everything from the storage device (files, applications, etc). Every time I do so, I need to click through ...
0
votes
0answers
54 views
How to send text to favorite editor without switching windows
I want to send selected in web page contents (text + images) to Word or Libre Writer via right button of shortcut right from browser without switching windows.
I searched through several automation ...
-4
votes
1answer
219 views
keyboard typing number 6 itself [duplicate]
I don't know what the hell happened with my laptop but it just keeps on typing number 6 itself. I tried to disable the key with KeyTweak and many other apps but it didn't worked. I can't type anything ...
0
votes
1answer
25 views
OneDrive doesn't download files despite having the option enabled
I have following option ticked in OneDrive on my desktop computer:
When I upload files from my phone, OneDrive shows this on my computer:
Those files with little cloud icon are not downloaded, they ...
0
votes
0answers
43 views
Is there a way to schedule something that unlocks Windows and performs a task?
Is there a way to setup a scheduled task that, at a given time each day, performs the following steps:
Unlocks Windows
Performs a series of clicks and drag+drop actions with the mouse cursor.
What I'...
3
votes
1answer
122 views
Run executable file from task scheduler NOT in background W7
I created an Autoit script that opens a certain app, and procedes with a certain behavior. When I compile it, Autoit gives an executable file. If I run it, it works finely and smoothly.
Now I need ...
0
votes
0answers
35 views
How to send key strokes for right mouse click? [duplicate]
I am looking to right click in a windows application using Powershell. Is it possible?
I tried "Shift+F10" and the application is not taking it in.
If not what is the sendkey for copy and paste?
I ...
1
vote
0answers
44 views
In Excel, calculate sum of a column where multiple cells contain specific text
I have a large dataset I'm working with consisting of many records that represent lines on a map. The order heirarchy is State -> County -> Line # -> Line Class -> Line Length. There are multiple ...
