documents

Hi People, I use the function below in Excel VBA to open different Word documents one at a time. I pass the Word document's name as a parameter to this function to open it. Please kindly show me how I can write another code to close a document that is already opened before I open another one...

Hello, I have an Excel VBA script that creates multiple Word documents. I've been using it for a few years and it's been working great. I have roughly 350 files. The script used to create the Word documents and save them as PDFs in about 45 minutes. In the last few months, it's slowed...

I'm trying to prepare some financial forecasts for a client as a planning tool for them moving forward. The forecasts need to look up information from excel order book documents saved on their servers (that are updated daily) and so I need to find a solution as to how I reference that data? The...

Hi, I'am trying to set up an excel tot make our office more paperless Documents will be stored in the cloud (OneDrive) synchronised Locally. Excel file should provide organised acces to the files. I already have a userform with a Webbrowser Control to preview documents chosen from a listbox...

Hi everyone, We have a document that is saved in a sharepoint. I want to make saving a copy easy for others but also give them the choice of where they save the document. so I created a save button and when click it runs this code: Sub filesave() Dim bFileSaveAs As Boolean...

Hello, I have 2 excel documents that I want to compare both have the same information, is just one has been updates where things have been removed. One has 80K entries, and the other has 75K, is there a way for me to see what were those items removed in comparison with the first document...

I'm trying to make the value of a textbox become dynamically inserted into a message box. In the code below, I want NAME replaced with Me.TextBox2.Value. MsgValue = MsgBox("Are NAME's documents filed?", vbYesNo, "Training Documents") Thanks!

I have a folder with many documents, excel, word, outlook e-mails, etc. I'm looking for a macro that would open, refresh and close all Excel documents where the name starts with "FI". There are many sheets, tables, pivottables, connections, etc. found inside the excel documents. Is there an easy...

Hey, I have an excel file with a lot of document numbers, and those numbers are corresponding to documents in a map on onedrive. Is it possible to create a vba so excel will search to the corresponding documents in onedrive and create automatic hyperlinks? So if I add numbers to the excel file...

I have some code working right now where there are 2 master lists of documents that may be needed in a file. The user goes through and puts an "x" next to the documents they want. The code is doing what it is supposed to,... it copies any document with an x next to it, and moves it to the...

I am involved in converting ASP e-elearning courses to Storyline. These ASP courses are defined by Excel documents. The Excel documents are broken down to three worksheets: Training, Question and Exam. (I'm focusing today on the Training worksheet.) Storyline allows for the importation of...

I'm not quite sure if I'm using the right formula to be doing what I'm trying to do, but let me walk you through what I'm looking for. I'm trying to put together a dashboard that facility managers for my company throughout the US can use as a one stop for all of the compliance documents that...

This is my issue. I am trying to scan several documents into picture form. From there I am trying to line them up so there for I can set up the page breaks for printing each page. However, the scan is 8.5 by 11, when i put it in excel it doesn't print out the same. It either prints smaller or in...

Is there a way, in Excel 2007, to remove just 1 entry from the Recent documents list? In my personal QRG for Word 2007, I have a note that says that Alt+Ctrl+- (minus) will change the cursor to a thick vlack bar, which can then be used to remove entries from menus, including the Recent...

Hi, Need a bit of help if possible, I have multiple .xls documents in a folder (approx 200) all identical format i want to be able to sum the value from cell A1 in all these documents, could anyone point me in the easiest direction? Many thanks DM

Hi all, I have an annoying problem that must not be present for a file I am making for end users with little Excel expertise. I have a file that copies a worksheet from it to another workbook. If the user saves the originator file (the file from which the worksheet was copied from), the...

I am currently working with a large excel spreadsheet with multiple links to other documents. I have setup the linked documents to only update on prompt - as intended for this application. Whenever I open my master excel file and begin to make changes, the file will begin to require too much...

I have an excel table with a large amount of file names (PDFs) and their description, as part of a list of documents that had to be delivered. All those files are in a folder (hard drive) organized within many subfolders, and I would like to check whether the documents they presented as...

Dear all, recently I had a test on which I was required to insert a data from a word document's table, but the table in the word wasn't itself on a regular table, but instead in for of image. I did not complete that assignment as I didn't have a mere idea how it even can be done. Anyone familiar...

I'll start by saying, I'm not good at all with VBA - but if you have easy to follow instructions that would be great A user of mine, has a spreadsheet with around 300 linked documents in a spreadsheet. The problem being, the documents are either on their own desktop, or a couple of other...