PDA

View Full Version : Solved: New to VBA - How do I open WORD?



pilgrim_153
02-04-2012, 06:04 AM
I'm attempting to open a .doc file from VBA within Excel. I understand that Activex is not available but how do I get round it?

This is what I've got that doesn't work.

appwd.Documents.Open txtpath & lettername

I would appreciate any help.

Thanks.

Bob Phillips
02-04-2012, 07:13 AM
Dim app As Object
Set app = CreateObject("Word.Application")
app.Documents.Open txtpath & lettername

pilgrim_153
02-04-2012, 07:34 AM
Thanks, I'll give that a go.

pilgrim_153
02-06-2012, 06:34 AM
That took me into Word, and another set of problems, for which I shall go to the Word part of the Forum.

Thank you for your help.