Late Binding of Word in Excel Macro

[msquared99]

OK, I have this macro that I created in Excel 2010. The issue is I have used Object References and that is causing issues with Office 2007 users. So I am trying to late bind Word so I do not have to use the Object Reference.

I have tried to get late binding to work but keep haging different issues.

I get Run-time error '5861': 'Name' is a read only property. on this line of code: wdDoc = Dir(Path & "\*.doc")

Could some please help me understand what is incorect in my macro?

Thanks a lot. I am still new at VBA.

 

[NARAYANK991]

Hi ,

The problem is that the Dir function returns a String type variable ; instead of assigning this string to a variable which is of type Object , you need to declare a String type variable , as in :

Dim file_name as String

and then assign to it the result of the Dir function , as in :

file_name = Dir(Path & "\*.doc")

Narayan