Brilliant idea Roy, I have a feeling this will work as intended but right now I am experiencing Run time error 91: object variable, on line Set docWord = objWord.Documents.Add("Path")
Macro to fill word template
- tr1face
- Thread is marked as Resolved.
-
-
Try this
-
This is exactly what I needed. Thank you for all your time & help Roy, you are amazing mate! You just saved me a ton of time!
I will leave the post unresolved 24 more h in case someone got to work something and wants to contribute, then I will mark it as resolved
-
Pleased to help.
Post back if you need further help.
Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.
-
-
What does the error message say exactly. Maybe attach a screen shot.
-
I'm not sure what the error was unless it was a reference to MS Word.
-
Many thanks to Roy, thread is now marked as resolved
-
Pleased to help.
-
-
Can you help me do something similar? I have an invoice template I need populated with information from excel.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!