objdoc

The title pretty much sums up what I am trying to accomplish but have had no luck whatsoever. I'm trying to copy a range from an excel worksheet to word but when I do, it changes the text formatting and the table extends beyond the first page (both to the right and onto the next page). So I'm...

Hello guys, I want to write an excel macro that opens up sheets of word in directories per request and prints them out I already have a full path created for each file, so all i really need to do is: 1) Open the word document with specific name 2) Print out only page 2, this i can achieve...

Sub wordopen() Dim objWord Set objWord = CreateObject("Word.Application") Dim objDoc Set objDoc = objWord.Documents.Open("C:\HR-Benefits\Enrollment\LifeInsurance-CoreAndSupplemental.docx") objDoc.PrintOut objDoc.Close objWord.Quit End Sub I wrote the above code and it works. From...

Please I need you guys help on this...I successfully copied and pasted a sheet as an image on word using the below VBA codes Sub luxation () Dim objWord, objDoc As Object Activewindow.view=xlNormalView Range(“B2:S73”).select Selection.copy picture Appearance:=xlscreen, Format:=xlPicture...

Hi all, I am using the macro to get the single document details. but in the folder i have more than 100 document. can you please help me for loop. Public Sub test() Dim objWord As Object Dim objDoc As Object Set objWord = CreateObject("Word.Application") Location =...

Hi all, been some time since I've worked VBA. Pulled up an old code but it isn't working. Basically, I'm trying to open a Word document to do some data crunching. Dim objWord Dim objDoc Set objWord = CreateObject("Word.Application") Set objDoc =...