Hey everyone,
I'm currently stuck within the development of a macro to transfer data from an Excel Sheet to a word template with bookmark.
For now, the main of the macro is working, the data are well transfered to the Template but I have several issues that I cannot fix since three days, and I...
Hello all,
I am creating an Excel flowchart with buttons for each step that when clicked, open a Word doc with instructions. I've bookmarked each step in the Word doc and the code works to bring the user there, however I would like for the selected bookmark to appear at the top of the page, and...
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 =...
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 =...
Hello, I am trying to insert a word file at a bookmark in Word (through Excel VBA) but I cant seem to get it right. It keeps pasting the document contents (badly formatted) where I want to just include a copy of the file.
The line I cant get right is Bolded for ease.
Sub CreateContract()
Dim...
Hey all. I'm using Office 2016. I'd like to make a macro that loops through each heading in a document, and then creates a bookmark at the heading's location using the heading text (modified as necessary) as the bookmark name. Most of the headings are in X.X.X.X format, such as "3.3.4.1...
Hi, I have this error message just popping everytime but I don't see wht , can you help me:
If Application.Workbooks.Count = 0 Then
MsgBox "No files open to process"
Exit Sub
End If
If ActiveSheet.Type <> xlWorksheet Then
MsgBox "You can only run...
Hello All!
I am using Bookmarks and a UserForm to populate data in Word. My apologies if this is on the wrong forum. I am using VBA and assumed it is similar.
After setting my bookmarks and creating a user form, I can populate text in my word document with the following:
Private Sub...
Hi everyone ,
I have an excel file that contains my data , and a word form .
I want to fill The word form with my excel data . (I've bookmarked texts that needs to be fill out )
for example i want to choose row 2-10 in excel and and click on a button to export 9 word document that filled out...
I am somewhat new to VBA, I have created a userform that will open a word document and update several lines of text within the document before saving and closing it. I know that it is possible to insert text at a bookmark, but I do not currently have the understanding to do this. My code is as...
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I have about 2,000 lines of data and must create a set of 2 charts for over 50 Word reports. I know this can be done using bookmarks, but can’t find the instructions. I think...
Hello,
I'm using Excel 2010 and have Acrobat XI Standard.
I have about 50 Excel files that I want to turn into 50 individual PDF files. Each Excel file has many sheets, and I want each PDF file to contain all the sheets and have a bookmark for each sheet. The bookmark should be the same as the...
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...
Hello All,I am a newbie in MS-Word and need to find a way to access a given number of pre-defined bookmarks in a word-2007 document and assign values to their text property.Eg.How we access ranges in MS-Excel,Thisworkbook.sheets("sheet1").range("A1:C1").value = Array("Name","Age","Gender")So...
I have a list of student names in an Excel 2010 worksheet in column A. Each student has two worksheets that I need to link to (from columns B and C). Can I create a bookmark link that takes its worksheet name from the column A. This would allow me to create spreadsheets for many different...
Hello,
I am trying to generate Report using a predefined template. I select the reports i want from a listbox then run the macro. The first report generates successfully; however the second report will cause an error: "Object variable or With block variable not set " when calling a table from...
I wish to open and view a specific location in a pdf document, (from an XL File) by creating a hyperlink in XL file, for the pdf-document-bookmarks.
This is possible with a word document, but am unable to do the same for a PDF file.
Also I am using Foxit reader, as this helps in bookmark...
I created a (Menu) sheet, full of text and image hyperlinks. Most are Bookmarks to other worksheets.
Although they all work perfect for me, they do not work for the person I need to share the workbook with. When they click on a Bookmark/Hyperlink, they get the following error message:
"This...
Hi,
I want to run a macro in word wherein, I want word to display a dialog box, which will accept my input.
Based on that input, I want to vlookup in an excel file and get the relevant data into word.
Not sure how to do this.
Appreciate if anybody could help?
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 MrExcel.com.
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 "mrexcel.com".
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.