Questions tagged [document-automation]
The document-automation tag has no usage guidance.
26
questions
0
votes
0
answers
23
views
Auto Stoplight Colored Chart
Does anyone have code that will automatically color a traffic light-type icon for a red-yellow-green status? The only way I know how to do this is with multiple steps that have to be replicated each ...
- 1
0
votes
0
answers
18
views
Retrieving specific text data from all files present in a folder
I've some SQL queries (DBT) in a folder. I've to run the dbt sql files and validate them. Before running, I've to clone the sources used in the queries. I'm going through each file and making note of ...
1
vote
0
answers
612
views
How to Dynamically Create and Populate Word Document Templates with Form Data?
Preface
I’m working on a project where I need to digitize the form filling process for a testing lab company. The company currently fills out forms manually and makes 40 copies of each form. The form ...
- 66
1
vote
1
answer
1k
views
Custom Document Property in Word - Mapped Content Controls
I want to be able to insert into Microsoft word a field that is dynamically connected such that I can type anything in this field box and this is instantly replicated anywhere else in the document ...
- 111
0
votes
1
answer
65
views
MS word page numbering in file, continue after previous file
Good morning...
I wonder if automation in word has reached the level what i think ?
I have a folder that contains several chapters separately.
Now, Everytime when I change whatever/anything in my file,...
0
votes
2
answers
44
views
Find row where values have been skipped in a table
i have a long table like this:
a 1 2 3
b 2 3 6
c 4 6
d 4 4 7
e 3 3 3
f 3 6
g 2
in this example I would need a function now, that would return 'c' because the second value is missing. Same goes ...
- 1
0
votes
1
answer
444
views
Automated excel worksheet export without formatting
I have several hundred excel files with varying numbers of sheets within each.
I need to export each sheet as a CSV (preferably with "each","cell","in","quotes" ...
- 101
1
vote
0
answers
632
views
Automating Excel to save file as CSV and run live updates
For starters - I am raw and have limited skills, thus the guidance here is important to me.
We have to supply data to a 3rd party in CSV format. The data must be updated at frequent intervals with a ...
- 11
0
votes
1
answer
1k
views
How to retrieve currently open documents in LibreOffice (calc, writer, etc.)
I need to read / retrieve / get / enumerate currently open documents in any LibreOffice app (Writer, Calc, Present, Draw), on linux.
What I tried:
Searching the command line history is not helpful: ...
- 1,533
0
votes
0
answers
463
views
Automating a Data Entry Job in Excel with Automator or any other app
I have to complete labeling process in excel sheet with over 3000 rows. The excel sheet ( please see atttachment) has three columns, E1, E2, and Label. E1 and E2 are already type in and I need to ...
- 131
1
vote
0
answers
327
views
Docusign Gen for Salesforce error on custom object template button
I've created a DocuSign Gen template based on a Salesforce custom object and the preview works well. However, when I try to create the custom action (Lightning button), I get the error "Failed to ...
- 11
0
votes
1
answer
4k
views
Generated PDF doesn't show some characters in chrome
I'm generating PDF files with a document generation tool (Advanced Forms).
I recently turned off the option "embed fonts" to reduce file size and because we use the Calibri font which is installed on ...
- 101
2
votes
0
answers
682
views
sphinx autodoc: ModuleNotFoundError with sphinc-quickstart
Just installed Ubuntu 18.04.2 LTS on a fresh virtual box this morning and I'm trying to re-invigorate a project I had running on my legacy VBox/Ubuntu environment. I'm stumbling with getting sphinx ...
- 21
3
votes
4
answers
142
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 ...
- 51
0
votes
1
answer
464
views
Create a new document from a .dotm template on a weekly basis
At my workplace, we need to write a report on a weekly basis to document what we have gotten done during that time period.
For that, we have a MS Word template which uses VBA code to fill in date ...
