Reference without writting to hdd

[DorianGrim]

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?

[TMS]

Yes, you can save a workbook as Book1.xls ... and subsequently open it. Bit confusing for everyone, but you can do it. If a file has been exported from another program, it's already been saved to your hard disc as Book1.xls.

Regards, TMS

[DorianGrim]

The book1 generated by the program is not saved to the disk. That's why I want it to be given as reference without saving it. Can it be done?

[TMS]

If it's not written to the disk, where is it? And how are you currently accessing it?

[DorianGrim]

Ok, I'll put it in another way.

Can a macro from Book2.xls read data from an unsaved Book1 file?

[JosephP]

yes-refer to Workbooks("book1")

[DorianGrim]

yes-refer to Workbooks("book1")

Can you please offer an example of code I must use?

[JosephP]

that was it.

Please Login or Register  to view this content.

if you want something more specific. ;-)

[DorianGrim]

that was it.

Please Login or Register  to view this content.

if you want something more specific. ;-)

But this code must be placed in the Book1. I want it to be used using the existing Book2.xls. If I use it in Book2.xls it doesn't work returning Subscript out of Range.

[JosephP]

But this code must be placed in the Book1.

no-it will work in any workbook as long as the Book1 file is open in the same instance of Excel.

[DorianGrim]

no-it will work in any workbook as long as the Book1 file is open in the same instance of Excel.

Subscript out of Range.

[JosephP]

it will work in any workbook as long as the Book1 file is open in the same instance of Excel.

[DorianGrim]

it will work in any workbook as long as the Book1 file is open in the same instance of Excel.

What do you mean by the same instance?

[TMS]

This macro exists and is run from Book2.

Please Login or Register  to view this content.

The output is:

Please Login or Register  to view this content.

Both workbooks are open in the same instance of Excel. Neither workbook has been saved.


Regards, TMS

[DorianGrim]

I got it.

Guys. Thank you very much.

[DorianGrim]

I got it.

Guys. Thank you very much.

It appears it solved only half of the problem. Exported documents tend to behave and open like new Excel. This causes for the exported file to open in a separated window.

Does this happen to you too:

1. Open a saved document.
2. Then open a new one using start/accesories/Microsoft Office/Microsoft Excel 2007

Does it open it in a separated instance? Cause for me it does. I use Office 2007 with the option from advanced/display/Show all Windows in the Taskbar unchecked.

[TMS]

I am assuming that the third party program has produced the Book1 file and opened it in Excel.

If that is the case, use File | Open... from within that instance of Excel to open the workbook with the code in it.

Regards, TMS