Problems running a word macrofile from within excel!

Hi there!

Ill do my best to try to explain the process im struggling with. feel free to ask followupp Qs.

I have A excel workbook with data that i work in. to this i have a button on first sheet that has a macro connected that i cant get to work.
The Macro should rund a wordmacro file.

The word file works as follows. When i run the word file "Intern syn NCC_Hornbach.dotm" in the folder. ( by dubbelklicking it) it runs, then gets a standard template from another file called "Intern_syn_NCC.dotm" och makes a new document with the standard template as page one. then it looks in an excel file wich has say 10 rows with data. and populates the first page with row one. then gets the template again and makes page 2, populates it with data from row 2 in the excel fil and so on untill page 10.

then the word file "Intern syn NCC_Hornbach.dotm" closes leavin a new document with no title open with 10 templatepages populated with data from the 10 rows it got from the excel datafile.

My problem is that when i run the macro. i get runtime error and can klick terminate. allthough the macro opens the wordmacro file.
but doesnt runt it. so it remains open with 1 page.

the code i use is as follows

Sub GetWordDoc()

Dim myDocPath As Selection
'Opens a Word Document from Excel

Dim objWord As Object

Set objWord = CreateObject("Word.Application")
objWord.Visible = True

'Change the directory path and file name to the location
'of your document

Set objDoc.Selection = objWord.Documents.Open(Filename:=ThisWorkbook.Path & "\Intern syn NCC_Hornbach.dotm")

End Sub

how do i solve this so the macro just runs the wordfile, and doesnt open in? so it will work as it does when i dubble klick it in the folder?

Many thnx in advance and i hope its not to confusing!

cheers

Thanks for the reply OllieB!

Now i dont get any error msg att all, so macro runs without fault. but it still opens the wordfile "Intern syn NCC_Hornbach.dotm" and leavs it open with no further action.

When i run the wordfile alone from folder, it starts, runs its macro and closes. and leavs a new document unsaved with all the templates populated from another excel file. Thats what i want the excel macro to do aswell.

Many thanks!

Hi there again!

Thanks for your time and help m8!

Im attaching the wirdfile im trying to run via excel macro, and a excel datafile the word file uses, easier if you se how it works, maybe then its easier to know why atm it wont run as intended from excel macro!

Hope it helps!

if u extract and keep bot files together and dubbleklick the word macrofile u can se what it does. in it there are 3 macros that runs upon running the word file. "KopplaData", "Makro1" and "Document_New"

Cheers!

Hi!

Very strange that it works for u, the button and macro assigned doesnt work for me. it runs the wordfile, and the macro1 in i. but it cant find the NCCExport file to import data.
I get an error when it opens the word file, and cant find the file. it for some strange reason starts looking in sysmtem32 folder for it. and says it cant find the local file NCCExport.

As when u run just the wordfile itself by dubbleklicking it it has no problem locating the NCCExport in the same folder and running the macro.

Im very confused :S

Thanks for the help!

Then im verry sorry for not being clear on the problem at hand, And you should know that i appriciate your time and effort helping me very much! Cant thank you enough!

Allthough it still doesnt work dispite adding that line of code and keeping all 3 files in same folder. the word file is not to be opened, if u just dubblecklick it it works fine and crates the unsaved document as wanted. thats what i want the macro to do, to run the word file, not open it.

I still get the same error, that it runs word file but sticks as it cant find the correcr files, wich for me is strange because when i dubblecklick just the wordfile it has no problem executing its onw macros and crating the new doc. So the macros in the wordfile works fine when u double klick the word file and run it. but when i run it via excel macro it doesnt work.

Cheers!

Hi!

I get runtime error 9105, string longer than 225 in row 39 atm, trying to figure out how to break the string

Ok Now!

It works as intended!

But it crates to word document for some strange reason. maybe u know why? it makes one called "Document 1" that i dont need and want. with only 2 pages. ant then it crates the one i want called "Standardbrev1" or "standardletter1" i have swedish office . with the correct data in it. and with all the pages matching the datarows in NCCExport

Many thanks m8! You are the best!!
Moving it to a shorter path worked! i have all the files in folder "Test" on C:

Cheers

Hi!

Thank you verry much! Your effort in helping me just made my day! Works perfect now!

Cheers m8!

Hi OllieB!

And once again thank you! i replaced the current code with the sorter one you posted. works like a charm in a path that was to long before!

Many thanks!

Cheers!

Just wondering. whats the big diff from the 2 code strings you posted?
I used the shorter string, but its no difference in the by how the document is crated and the data from NCCExport is transfered?

Cheers