mkz wrote:

Connection:="Data Source=" & strWorkbookName & ";Mode=Read",


I did not try that but I am not sure if that is valid connection string.
Try to google some examples or setup connection manually and read
connection property.