word

I have a Word template that is used by various contributors to submit articles. At the bottom of the template, I have document fields that calculate the total number of pages and words (as separate document fields). I need to know how to dynamically link these document field results (the...

I just discovered that there is some discussion of Word vba here. In Excel, I am used to being able to turn screen updating on and off, and programmatically trigging screen refresh at will. Working with Word vba I have found what should be the appropriate commands; but I cannot make the screen...

hello we have an excel sheet that contain a macro who create a word document every time we running it it fill all line with "all tests" even if the line 7 is empty. not sure why. plus the word doc created put text sometime in 2 lines instead of 1 here the code : Sub Main()...

Hi all, I am trying to create a word document with inputs from Excel. Everything has been working well until I tried to create a bulleted list. The relevant portion of my code is posted below: Set wdApp = New Word.Application With wdApp .Visible = True .Activate...

Hello I use a macro to save mail merged documents into word and PDF files; very handy. I must select all the rows above the row I need in the recipient list for it to work. If I only ticked "Sam" and left "Connor" and "Vincent" unticked, the macro will produce a "runtime error 5631" on...

Hello, I have a feeling the answer may be no, but I'm looking to create a table - linked between Excel and Word - where part of the table is Excel data -> Word, and the other part is Word -> Excel. I would like my staff to enter comments against each student, but have been told by many that...

I am writing a macro( late binding) that runs through a word document and highlight all the values that is contained in my cell range in Excel. I have used the find function which works fine until I add the argument IgnoreSpace:= True, which I don't understand why it's resulting in error...

If I am thinking about this in the wrong way do not hesitate to say. I am new to VBA but I am not new to programming. I want to be able to automate the creation of Word documents. That is when the document does not exist already. If the document exists, I would like just to open it. Where I am...

I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2"...

Hi Excel Experts, I'm coming to you with a question, I'm helping out my friend with digitalizing their tools for their business, starting with a customer list, so they can use the details later for mailings, (now everything is on paper and in the word templates, so they don't have a nice...

Hi, I have a data set of descriptions and I need to find words in descriptions combined with numbers and letters. As an example cell A2 includes a sentence "Repair A4040D" so cell B2 should include information "A4040D". The equipment number is combination of letters and numbers max of 6...

Followed below instructions for the below code, only for step 7 there were no "Microsoft Outlook Object Library", so used "Microsoft Outlook 16.0 Object Library " But nothing happens when code runs, at all, not even an error. Using below code as a next best thing to figuring out how to...

Hi guys, how are you? I need your help because I want ran from boring and hard job to work with PDF and I want to convert the table from PDF to Excel. I read different forums and watch different videos on youtube but cant find the solution. I found only good advice to convert PDF to Word...

Hi all - I am very new to using Macros with Excel and I am looking for help. I am using code to attempt to automatically generate a word doc with upcoming deadlines/due dates in my Excel sheet. Currently, it will only generate a word doc if I manually run the code. Also, I am having trouble...

Hello All :) Currently I have vba code: 'Some code above If OfertomatMain.cmbUnderwriter1.Value <> "" Then For b = 2 To 20 Step 1 If OfertomatMain.cmbUnderwriter1.Value = wudoc.Cells(b, 1).Value Then Let underwriterstanowisko1 = wudoc.Cells(b, 2).Text Let...

Hello, When I copy from a Excel sheet data into Word it rounds the numbers behind the . I think all this is because of all the different cell formats all the columns have. Is there a way to copy and paste the data with all the numbers behind the . like 12.03767 ? After copying in Word this is...

Hello, I have somewhat of an advanced question... I have a long list of names in a column in excel (range name, "Names"), what I want to do is create a code that I can run that will open a template (named "CART") and based on the list of names the code would open a copy of the template and...

Hi all, I've got a document I'm using as a template with several sections. Page 1 is a title page with the: Document Title Published Date Updated Date Those three items are all bookmarks. Those three items are also included in the header of each page. When I'm ready to finalise the file...

Hi All, I know this is not necessarily Excel-related, however, it is going to be VBA related. I have created a return-to-work form in word, which is sent to managers to complete return-to-work interviews for sick employees. The document is restricted and only form fields can be completed...

I'm experiencing an issue with exporting the contents of a Word document to PDF. After pasting a table from Outlook into Excel, certain parts of the table are retained, then the new table is pasted into Word. The Word document is saved using a specific filename, the date, and a number to...