When loading my userform in word i get Run-time error 381: Could not set the list property. Invalid Property array index. The aim is to generate a userform with a dependent combobox (Attention) and independent combobox (CompanyName) grabbing info from a separate excel spreadsheet

Im trying to set the list of a dependant combobox in a userform in a word document to a range in excel that will change based on an independent combobox. There will be over 100 options in the independent combobox so i didn’t want to write code for each option. Each range will also have different total amounts of columns to cover.

I want to copy a range having merged cells from Excel to Word. I am also hiding a few columns I don’t need in Word. My code works fine except that the merged cells become unmerged. How can I preserve the merged cells?

I have an excel table that I am attempting to create code to export that data to a new MSWord Document, two-columns per page, LANDSCAPE orientation. Admittedly, I am a noob so bear with me. My code is below. I am able to create the two columns in the doc without issues, but the document that is created is not being set to landscape orientation.

I am trying to create an MS Word file using VBA (from VBA code running in MS Excel) to move columns of Excel data over to the Word document, but I want the Word document to have two data columns. In other words, each column of the Word doc might have multiple columns of Excel data moved to it. Make sense?

I am writing a VBA routine in excel that creates an rtf file and then opens it in Word. The file opens quite happily (both from explorer and from within Excel). But from within Excel, it remains minimised. The Word icon in the task bar indicates that there is a file open. If I click the Word icon in the task bar, it shows up fine. But I don’t want to have to click the icon, I just want it to appear in front of the Excel window.

I feel like this is ridiculously simple, but I have not been able to find any definite answer for moving between columns in word that are NOT in a table. I have this document with 8 columns and have tried to do things like Selection.MoveRight Unit:= wdColumn, Count:=2 which gives a Bad parameter error and Selection.MoveRight Unit:= wdColumn, Count:=2 which doesn’t do anything.

I have written a VBA macros in Excel to read data from Excel and create a document in Word. It works in “sections”. When I add text using instructions of format below it works:

I want to transfer a table of Data from Excel to Word but i’m facing a problem.
I want the following architecture for my word document :

Closed 2 days ago.