Questions tagged [document-automation]
The document-automation tag has no summary.
25 questions
0 votes
1 answer
302 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 vote
0 answers
1k 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 ...
1 vote
1 answer
3k 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 ...
0 votes
1 answer
87 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
67 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 ...
0 votes
1 answer
548 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" ...
1 vote
0 answers
902 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 ...
1 vote
1 answer
2k 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: ...
0 votes
0 answers
514 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 ...
1 vote
0 answers
342 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 ...
0 votes
1 answer
5k 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 ...
2 votes
0 answers
734 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 ...
3 votes
4 answers
580 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
1 answer
567 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 ...
1 vote
1 answer
8k views
Can I hide a whole paragraph using Conditional Text Automation in Microsoft Word
I have a MS Word document shared between different projects. Some paragraphs only apply to some specific projects, so I'd like to hide them using custom fields. I found this interesting page explaing ...
1 vote
1 answer
377 views
How can I obtain all font files for fonts I use in an Impress presentation?
I want to have a(n installable) copy of all the fonts I use in a LibreOffice Impress presentation I'm writing. I don't think LibreOffice has any UI to make that happen, so I'm fine with doing it "on ...
2 votes
1 answer
71 views
automate software/page feature/notepad++ feature?
I'm wondering if there's something I can use to make something easier, it's easier if I explaint through an example. I'm working on a stats change in RPG Maker, and for this feature to work I need to ...
0 votes
1 answer
961 views
Batch make powerpoint titles
I am trying to make a powepoint that has a lot of slides. i would like to know if there is a way to "import" all my words and make each line a title of a slide. also, if anyone knows a way to do the ...
1 vote
1 answer
246 views
Batch file to automate a task
I run a job that creates 35 text files. The problem is I need to transmit these files after they are created, but before I can send them I need to go into each file and remove a space in order for the ...
0 votes
2 answers
609 views
Document with ability to change only certain words?
I am creating an contract template. Instead of highlighting words which needs to be changes each time new contract is created, I'd like to have a fixed and changeable text. How can I create a Word ...
1 vote
0 answers
57 views
Is there a way to change the page styles of a range of pages in Libre Office?
I copied in pages to a target document from source documents which had page 1 (which was the page I was always cutting from) set to "First Page" style. This caused all my pages in the target document ...
3 votes
0 answers
81 views
Automated merging of PDF graphs [duplicate]
Is it possible combine PDF graphs automatically? I have similarly named files in 4 different directories. I have been reading about Ghostscript, imageMagick and PDFtk but I am not sure which is the ...
4 votes
3 answers
727 views
Is there a good way to "automatically" scan business documents?
My parents own a relatively small machine shop and would like a way to have documents such as purchase orders and invoices scanned into a system where they can be entered into their accounting ...
0 votes
3 answers
227 views
How can I use vim to automate this...?
I'm implementing hundreds of similar functions at the moment which take on the form String name(String arg1, String arg2, String arg3, String arg4) { trampoline("name={name}&arg1={arg1}&...
0 votes
1 answer
252 views
Seeking document automation/template system to output RTF or text
I would like to automate the creation of routine office correspondence - letters, etc. I am currently using Hotdocs for this task but would prefer to find something that isn't tied to Windows and ...