documents

Hi all I was wondering if anyone could help me out with a problem. I have about 1,500 word documents with tables that represent student evaluation. It is a tick box exercise where we have very good, good, needs work. I was wondering if it would be possible to make some VBA code that opens each...

I have a large number of documents saved in a folder. In Excel, I have written the name of one of the files in the active cell, including the extension. The code below opens Windows Explorer when the macro is run. I have the following issues: (A) Ideally Windows Explorer is opened in a...

Afternoon All Hoping I can get some help here. I manage a team of call handlers, and want to get a process whereby they can use a userform in excel to then populate two word documents. And also based on some answers on the userform to then fire off some email templates which are partly...

Hello, I don't really know where to start with something like this. I've got a spreadsheet that has a documents going down column C and the paths of these documents listed in column D. (example) What I need VBA to do is go through all of the various paths down column D and save a copy of that...

Hi, I need some help with a macro i am trying to build. I need to be able to print multiple xls documents to PDF via CUTEPDF Writer (this is a must) however there are around 4000+ documents so I it would be easier if the macro could automatically add in the filename. Does anyone know a way of...

Hello, For years now, I have executed many Macros and have never had a problem getting Message Boxes to appear on top of open Excel documents or Windows Explorer windows. However, with some recent changes to Excel, Message Boxes are now almost always buried under either open Excel documents or...

Hi Im quite new to this site, loving it already. This question might have been asked numerous times already, just dont know what to search for. I require assistance in creating tiers. This is based on tally system. Apologies if it is not clear enough. Not sure how to ask this correctly...

I have 6 excel documents that I need to combine into one large excel document with one sheet on it. I need it set up to where if changes were to be made on one of the 6 excel documents, it would be reflected on the large excel document. Each excel document contains things like name, position...

I am trying to get a VBA code to work. I have a sheet with a coloumn (A) with a header called: "Documents - close to deadline" I then have Coloumn C is "weeks until deadline" Coloumn D is "Document name". I can have any number of documents (not predetermined) depending on the project or...

Hi All, I am stuck in one formula and need your help!!!. I wanna calculate the number of particular documents from Sheet1 to sheet 2 which should show the number of documents in a certain date. for example in the attached excel in sheet 2, I used the formula...

simply put, I'm trying to create a macro VBA to copy a line of data in one work book and paste it into a central recording WB on the next empty line This macro will be put onto a number of documents (all the same) which are audit documents that record scores. Then I click a button and it will...

Hi, I am trying to make the following steps work but Step 5 (macro) simply does not work. Step 1 I have a worksheet where a user is able to enter data in one tab, Step 2 which is stored in another tab by way of macros, Step 3 which populates cells in another tab, Step 4 the cells will then...