documents

Hello, I have an excel file that gives the above warning message when saving. I've tried to find references to any .xl. files with find but this gives zero results. Is there another way I can find unsaved documents in an excel file? Thanks. B

Hi all, I have hundreds of word documents. I would like to extract the contents from the word documents and add them into excel with each cell in a single representing a unique word document. For example, B1 would represent word doc 1 B2 would represent word doc 2 .... ... . B897 would...

Good day. After writing a rather lengthy question, I found out that I am not allowed to attach documents to my post. What privilege do I need to be able to do that? Thank you, Dan Wilson...

I have an spreadsheet that summarizes various documents and includes the file path to each document. I have created a mail merge that creates a document summary page for each document based on the data in the spreadsheet. What I would like to do next is generate a single PDF that places the...

I am building a workbook to track training sessions. One worksheet will have fields to be completed for each training session. Some of the data would need to be copied into a log multiple times based on a couple of different factors: how many different documents were used in the training and how...

Hello, I need to search a keyword across multiple word documents saved in a folder. There are hundreds of such documents and its impossible to open each doc and search for the keyword. I am looking for an excel macro which will go into each of the word documents and return the name of the...

Hi All, I'm trying to create a code to compare two word documents if identical. However, I always get the error, "User-defined type not defined" Sub CompareAllFiles() Dim strFolderA As String Dim strFolderB As String Dim strFolderC As String Dim strFileSpec As String Dim...

I have a large number of RTF documents that I am opening using Access. I would like to reformat the document and then copy them into a control. I am able to open the documents, and go though all the paragraphs in the document (using the paragraphs object). I found that my macro's are missing...

Hi Bit of a shot in the dark here, but know that this is likely the best possible resource to ask. My department admins have a lot of documents to print every week for various other departments, and printing these out is not only tedious and labour intensive - but open to errors and missed...

Hello, I’m making a simple database to store scanned documents for multiple users. I uploaded the documents using the access feature and am able to open the documents in the table. However I can’t open the documents in queries r reports. I wanted users to be able to open the attachments from a...

I have a spreadsheet with an embedded .PDF file in it. I put that document there when I was using Adobe products and the formula for the document shows a formula as =EMBED("Acrobat Document",""). New documents I embed show up like this: =EMBED("PDF",""). And if I double-click the Acrobat...

Hello guys, This is my first post. Please let me know if I should post in a different thread. I want to run a VBA Makro that searches for a keyword in several Word documents and generates a list of document names when the keyword is found. - lets say we have 50 word documents, all in one...

Hi all I'm looking at building a dashboard in O365 using the snazzy dynamic array formulas that I've been reading about, but I'm running into a theoretical hitch with how to accomplish something. I can schedule exports from our database to run automagically and save csvs with the data...

Hey all. I'll try to make this brief and simple. :) I have 40 or so boilerplate word documents with a series of fields (Name, address, etc) that need to be filled in. This is historically done manually, but it's repetitive and cumbersome. A workbook where a user has filled a huge set of...

Hi, In a table, with 500 rows and 20 columns, of documents that cost 200,000 dollars. How do I extract 25% of these costs to physically check the documents (sort of sampling but random). Thank you.

is there a way to search text documents ( pdf and docx) for a combination of words and highlight it using excel ? thank you

Hello! I have a workbook with 39 tabs that need to be saved individually as PDFs. To save myself time, I created a macro that does this. Code is below. Problem is, I can't get the PDFs to be saved/exported to a specific folder consistently. I've tried a few solutions I looked up online, but...

- On Sheet 1 (FEED-2) I have the fiscal year (B5) with other information not applicable to this question it is just a what I call a feeder page. To get the fiscal year I have a table I created that is based off of the date to get the year, I tried just typing 2019 and still the same result...

Hi guys, I have a list of file names listed from 1-15 for examples. I also have documents scanned in to a folder. The first scanned item (determined by the time it was scanned compare to others) is generally the 1st file name. The second scanned item will be done few mins after the first...

Hello, I have a list of hyperlinks to documents in an excel column that i created by specifying the folder path then adding the doc names and ".doc" to the end. However, some of the links are broken since some of the documents have a ".docx" instead. Is there a way to go through the list, check...