1. S

    Delete two lines above bookmark - keep bookmark VBA

    Hello, I hope you all are well. I want to write a macro to delete two lines above a bookmark in a word document. So far so good, but the bookmark itself should not be deleted. I have come up with the following code: Sub DeletetwoLinesAboveBookmark1() Dim r As Word.Range Set r =...
  2. S

    Format text between two bookmarks in word (VBA)

    Hello, i hope you all are well. I am looking for a way to format text (e.g. size, fond and line spacing) between two bookmarks ("Start" and "End") of a word document using VBA. Do you have ideas / tips how i can solve this problem? Thanks in Advance and best regards, Sarah
  3. S

    Insert Text between two bookmarks of a word document into a new word document (after bookmark)

    Hello, i hope you all are healthy! I want to insert the text written between two bookmarks ("Beginning_old") and ("End_old") of an baseline word document, into a new word document. In the new word document, the text should be inserted between a bookmark called "Beggining_newdoc" and a...
  4. S

    Insert text from Excel into word document - after bookmark

    Hello, I hope you all are well. I want to insert text from an excel-cell (B16) into a word document. The text should be inserted after the respective bookmark ("B1"). I have written the following code: Sub InsertAfterBookmark() Dim objWord As Object Dim ws As Worksheet Set ws =...
  5. S

    Delete content of Word chapters but keep the title - VBA

    Hello, I hope all of you are healthy. I have a word document that contains several chapters including assessments concerning various topics. Since I have to update the document each week, I have tried to write a macro that deletes the contents of all chapters, but keeps the title of the...
  6. B

    Keep Excel text formatting when transferring data to Word with Excel VBA

    Hi Guys! I'm using the following Excel VBA code to generate a WordDoc and then transfer text from my ExcelDoc to the WordDoc: Sub Generate_WordDoc() Dim WordDoc As Object Dim FileName, TagName, TagValue As String Dim CustRow As Long Dim WordContent As Word.Range With Sheet1 Set wordapp =...
  7. M

    Replace charts in a Word document at bookmarked locations

    Hi there, I have an Excel spreadsheet and a Word document that work in pair. The spreadsheet is reviewed and updated regularly so the charts there represent the most up-to-date information. On the other hand, the Word document which contains the same charts (previously pasted as pictures)...
  8. 3

    Excel VBA - Copy text from nested Word tables

    Hi Guys, Does anyone know a macro which would open a word document and copy all tables, included nested tables to an excel sheet? I have tried a couple different ones online but they don't seem to capture the nested tables. Another solution would be top copy ALL text from the word document to...
  9. M

    Export Comments with referred text and line numbers from Word to Excel

    Hello, Unfortunately, I have no idea about Macros and VBA and everything I find in the internet is half information so I hope someone can tell me step by step what to do: For my master thesis, I commented on interviews in Word. To analyse further, I need to export the comments with the...
  10. J

    How to copy date from excel to word

    Hi, I have the below code which opens a word document and find words in column A and replaces it with the text in the adjacent cell in Column B. This works well. My issue is that when it copies a date from one of the cells to word, it displays the date as a number rather than a date. Public...
  11. G

    Key Word Search

    I am currently using a nested '=find(text,cell)' formula to categorise a list for example. If the term Doctor, Surgeon, Nurse, OT is in cell containing job title then the formula will return 'Medical'. This I have done by nesting separate find fictions for each key work with an if statement...
  12. L

    Copying multiple rtf file contents with formatting into a single cell in Excel

    I am busy making an eCommerce website, I have made a csv database with all the information that I need. The issue I am facing now, I have thousands of rtf files for each items product description that I would like to add into excel. The contents of each rtf file should be copied into a single...
  13. G

    Excel-Word Interop, Add Watermark Issue

    I have a workbook that will convert multiple word documents at once into PDF format. I am combining two macros I found on the web to try and get them to open a word doc, place a watermark on the doc, and then export it as a PDF. It will do this once for each file in a folder that I specify in...
  14. M

    Noob Help Please

    I am hoping someone can help. It seems like such an easy thing to do and I just can't find the answer anywhere. So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes" The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell...
  15. T

    Help with Word Table

    Good day all I need help with a MS Word form. I've searched all over the net and followed everything I've seen (I think) and I'm still stuck. I have a word table that I want people to fill out as a form. but I don't want the person to be able to change the forms layout. Specifically the height...
  16. willow1985

    LEFT function of a certain word by a certain amount of characters

    Hello, I am looking for a formula that can find a certain work and return only 10 characters to the left of that word. For example OTHER INFORMATION.... FOR PO# 55222 FROM COMPANY Left of "From Company" I want it to return the PO# 55222 Any help would be appreciated Thank you! :) Carla
  17. J

    Bookmarks in a word document

    Hi There! I have two columns of data, one that has a list of bookmarks and another with corresponding data in a workbook. I need to write a macro that looks at the data column, assesses to see if it blank. If it is not blank, it needs to look at the bookmark name and put the data into the...
  18. S

    Conditional Formatting Formula

    I need to write a formula that highlights cells that contain an error if the next cell contains the word "Venmo." IF (AND (I3=ISERROR , J3 CONTAINS THE WORD VENMO)) then color the cell red I know my formula is silly, but think it conveys what I am trying to do?? :-D TIA!!! Sarah PS, I know...
  19. B

    VBA in Excel to format all tables in Word document

    Hello All, My inexperience is showing here and I hope someone can help. I have some VBA code in an Excel workbook that creates a Word document then copies various objects from the workbook to various associated bookmarks in the Word document. After I have completed copying and pasting some...
  20. G

    Conditional Format with Search and Days

    Hello, I'm attempting to add conditional formatting to a sheet. The Conditional Format is based on: 1) Column A contains the word "Sales" AND Column C is < 30 2) Column A does not contain the word "Sales" AND Column C is < 90 I attempted to build out the formula, but it does not work as...

Some videos you may like

This Week's Hot Topics