1. C

    Excel VBA Errors when trying to copy and paste objects from Excel to Word

    Hello All, I have some VBA code that I need help refining. The problem I am having is inconsistent and unexplained errors, from my research it appears that the issue is with the clipboard crashing. How the VBA code works: I have an embedded Word documents with various bookmarks and reference...
  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. 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...
  5. O

    Extract only the first portion of bold text from text string

    While this is not being implemented within Excel, it does involve the use of strings similar to those used within Excel and I am hopeful someone can assist. I am working on trying to create a template letter that uses bookmarks to generate a UserForm and then selections on the UserForm are...
  6. O

    Bookmarks looking from bottom up

    Good afternoon everyone, I have a document in which I added some bookmarks in tab1 and in tab2, I added the link to those bookmarks in different cells. The issue I'm having is when I click on the bookmarks, it searches for it in tab1 based on the last active cell in the tab. Is there anyways...
  7. P

    VBA - Word Document Bookmarks extracted into Excel Sheet Text Box's

    I'm looking to find code that takes bookmarks on word and copy/paste's those bookmarks into text box's in an Excel Workbook (keeping text formatting). The reason for this is that it's much easier to write and format in Word, and this would save time in copy and pasting these paragraphs. If...
  8. K

    Creating tables at bookmarks in a Word document through Excel VBA from dynamic controls

    All, I'm hoping someone can help me on this as I have been banging my head against this for about a week or so. I have a userform that creates a set of controls (3 text boxes and a combo box) and interates a counter by 1 each time the button is pressed. I have written an Excel VBA Macro that...
  9. S

    Firefox Bookmarks to .xlsm [SOLVED]

    I figured out how to get my bookmarks out of Firefox and into Excel. A macro processes them, and other macros get you around the Worksheet. It uses: 1.) Firefox, 2.) SQLite3, 3.) DOS, 4.) Excel VBA, 5.) NirCmd (optional) All you have to do is to categorize your bookmarks, and then click the...
  10. S

    How do you create a Shortcut to “Other Bookmarks” in Firefox?

    I want to make a macro in Excel 2010 that goes to "Other Bookmarks" in Firefox . . . I can't figure out how to do it The closest I can get is, I open this "skin" / "chrome", and it default opens to "All Bookmarks" . . . "C:\Program Files (x86)\Mozilla Firefox\firefox.exe" -chrome...
  11. K

    Dynamic range in to word bookmark

    I've been trying to populate an excel template .dotx and saving it as .doc I managed to get most parts of the code working. But its 4 in the morning and i cant figure out the last part; Dim LastRow As Long LastRow = Groslijst.Range("A" & Rows.Count).End(xlUp).Row...
  12. P

    macro to save as pdf with name from bookmark

    hi all, i'm trying to create a command button in word and attach a macro that automatically saves the doc as a pdf to a specified folder with file with the name coming from 2 bookmark references with a space and dash in between name. here is what i have so far: Private Sub...
  13. C

    Copying a chart from Excel into a Word Template

    Hi there, I have created a chart in Excel and want this to appear at the Bookmark 'CIPChart' in a premade Word template. This is my code. The Word template opens fine but I can't get the chart to copy and paste into it. Where am I going wrong? Sub macro() Dim word As Object, templateFile...
  14. K

    Switching between 2 word documents via excel VBA - Do I have to use ActiveDocument?

    Hello all, I have a Userform that runs a macro that opens 2 separate word documents, a template letter and a letter with a few bookmarked text articles. I have been trying to get the macro to select a specific bookmark in the articles document based on the selection from a drop down box in the...
  15. S

    Excel VBA - Fill Multiple Word Bookmarks with one cell value

    Hi, I have a Word document with lots of references to a Project No. (and others). I use VBA to auto-fill these in from a spreadsheet. Because Word makes you give each bookmark a unique name I have lots of bookmarks relating to the same cell value in my worksheet. This makes my code long an...
  16. Jon von der Heyden

    Copy Excel table to Word Bookmark - issue with intersecting bookmarks

    Hi All Using Excel, but think I need help more related to Word. I am using a class in Excel to manage report creation in a Word document (template - for want of a better word). Public Function RangeToBookmark(ByVal rngTarget As Excel.Range, ByVal strBookmark As String) As Boolean Dim...
  17. F

    Word VBA to add variable bookmarks in mail merge

    Hello all, I've got an Access select query with the following output: User City Travel Type Place Customer user1 Paris private must see Eiffel Tower user1Parisprivate user1 Paris private art Louvre Museum user1Parisprivate user1 Paris private art Orsay Museum user1Parisprivate user1...
  18. A

    Cant get last Row value into word from Range

    This is workgin great and getting the info from g4 and pasting into word bookmark but Set wdRng = wdDoc.Bookmarks("ClientName").Range wdRng.Text = Range("G4").Value What I want to do is get the last row in G so that as new data is saved I can paste it into word. But all my attempts seem to...
  19. O

    save VBA bookmarks?

    Is there a way to reactivate the VBA-code bookmarks in Excel? Maybe by using VBIDE ?
  20. Z

    Moving bookmark in word

    Hello all, I would like to create a word document by copy-pasting the contents of several other documents to a bookmark. After pasting, I would like to have the same bookmark available one line below the previously pasted content. The program is working, but pastes every time at the...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back