bookmarks

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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