Bad filename error

[Reset]

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 = objWord.Documents("C:\Users\me\Desktop\TestFile.docx").Activate

I thought it worked before, but it's been a while and I'm just a novice. Can anyone see the problem? Thanks.

 

[MrKowz]

I'm admittedly not too well versed in VBA as it relates to word, but my guess is that this file needs to be opened first.

Perhaps try:

Dim objWord
Dim objDoc
Set objWord = CreateObject("Word.Application")
Set objDoc = objWord.Open("C:\Users\me\Desktop\TestFile.docx")
objDoc.Activate

 

[Reset]

Tried that, now the error is "Object doesn't support this property or method". But thanks for the input.

 

[Fluff]

try

objWord.Documents.Open "C:\Users\me\Desktop\TestFile.docx"

 

[Reset]

That worked, now I just have to debug more downstream. Thanks, Fluff!

 

[Fluff]

Glad to help & thanks for the feedback