1. R

    Code in VBA about rotate an image

    i am very new in codes specially in VBA. My intention was to make a template in excel for reports in my job, it will replace words from excel to a special template in Word and at the end it will load an image from a folder in pc give it other size and rotate for example 90°. this is the code i...
  2. P

    Insert data to Word

    Hey Guys just found your forum a couple of days ago! I have been trying to make some reports from excel to word, and I could get it right! let's say I have 5 customers from which I have to make a report, they could n customers! (this is my hardest part) Which i have to add them on the blank...
  3. A

    Excel vba for creating a summary word document from the comparison of 2 word documents

    Hi, I created a vba script in Excel in order to create a word document as summary of comparison of 2 word documents. Here my script: Option Explicit Private Sub ButtonSummaryReport_Click() 'Initialize the progressbar and the label Dim k As Integer Dim filesNumber As Integer...
  4. M

    Is there a way to run a mailmerge that merges multiple rows into a table based on a key field?

    I am trying to do a mail merge from an excel file that has multiple rows for each employee. Each row lists an application or process they are not qualified for. The data is provided in an excel document and currently we are copying and pasting it into a word document to then sending to...
  5. Erin81

    How to jump to top of word document's selected bookmark?

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

    Need macro/VBA/Sub... that will paste data from the clip board into a single cell

    This macro/VAB/Sub... needs to be able to paste data into a single excel cell. The copied data may be one word or multiple paragraphs from a word document. Either way it needs to be pasted into one single cell. The code needs to pick up from this point: ' Paste info from clipboard starting at...
  7. A

    VBA in Excel to >> update links in word file then save it as PDF

    Hello, I have an Excel file with some data entries (20 different variable cells) these data are copied & pasted special in a Word documents (in different portions) every time i change in the data in the Excel sheet i have to go to the word document and update the links there and then print the...
  8. O

    Code to delete unused cropped region

    Hi there, My goal is to delete the cropped space of images that is currently unused. That is, after an image has been cropped, I want to use "compress picture" function in excel/word/powerpoint to batch process this over multiple files. My problem is that I can do this just fine in excel...
  9. M

    Save word/excel file on Sharepoint with VBA

    I have managed to extract data from excel to a specific word format and save it on my local disc with use of VBA. Now I need to set the code so that the file is saved to a specific Sharepoint folder. The code I got now is; SaveName = Environ("UserProfile") & "\Desktop\ " & _...
  10. M

    How to create a Word report using Excel?

    Hi There, I am fairly new to this but I am trying to make a report in Word, I have a template that I am working from but I can't seem to find what I need online. Basically I want to be able to type details in excel such as company name, address, products, specific products used. I have started...
  11. I

    VBA, Unable to SaveAs2, Error 438 "Object does not support this property or method"

    I'm using Office 365. Trying to save each of my named ranges in Excel as their own separate Word docs (docx). I get this error 438 in the line I highlighted in Red. Any help appreciated. It seems like the issue is with wdDoc or activeDocument? Sub CopyWorksheetsToWord() Dim wdApp, wdDoc, nm As...
  12. J

    Convert PDF to Excel and Copy into existing excel sheet

    Hi, I want to convert a pdf file to excel and be able to transfer the data into another workbook using VBA. Based on research, converting pdf to excel can be done by first converting to Word document and then to excel. But I want to know if the excel conversion can be transferred into an...
  13. F

    (Word VBA) set CellAlignVerticalTop for every tables in selection

    Hi, I want to create VBA that helps me set Word Table format as follow: - align each table to center of the document - this one work fine. - set text format in each cells Align Top Left (this is identical to select Table and go to Table Tools > Layout > click Align Top Left at Alignment area.)...
  14. Dermot

    Merging Excel to Word and Powerpoint

    It is not difficult to merge Excel data to Word documents, but this destroys the bookmarks, and if you find you want to redo the merge after you've substantially modified the Word document, that can be frustrating. I wanted a merge that could be repeated as often as required, which meant...
  15. 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...
  16. khawarameer

    Converting HTML Code to Table in MS Word

    Dear All, I have an html code available in an excel column (Please refer below table). My aim is to send that code to Word Document using mail merge and convert the code in to a Table when it is merged in word document. However when excel column in merged in Word Document the html code is not...
  17. D

    Delete text outside the <<...>> brackets

    Hi, I have a question, I have a word document which is in arabic, the file has a lot of text that I have placed between the following brackets: «............» Is there any way i can delete ALL the text in the document and just preserve whats between these two brackets? Please help me... Thanks
  18. O

    Excel VBA create listboxes not working - error 1004

    Hi, Done some searching and sheet is not protected as others have had the issue with - its just being created as a new workbook. So this is part of a word macro I am updating that I wrote before, but inside the macro I call the Excel creation function. The goal is I want to create an excel...
  19. 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 =...
  20. 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

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