This code doesn't quite do what I want:

Set wbRemote = Workbooks.Open(temp, , True)

First, it opens the workbooks visibly, while I wish it to open in a hidden state. Second (probably due to the first), it changes the ActiveWorkbook. I also tried this

Set xlTmp = New Excel.Application
xlTmp.Workbooks.Open temp, , True

This works, but I it lacks in clarity. I like having a Workbook object to refer to, rather than the Excel.Application object, which I'm less familiar with. Any hints on how to get a Workbook object referring to an open (but invisible) workbook?

Gustaf