Hello guys,

Is it possible to give reference Book1, without it being saved to the hdd?

The thing is that Book1 is exported from a program with the default name of Book1. I want it to be read using another workbook that I can keep always open. And just run a macro from my workbook that reads data from Book1.

Help?