Closing non-active workbook

[patelh9]

Hi,

I am not a vba excel. Below is the code that I am currently working on. It's pretty basic.
The macro copies data from one file which is referenced by "" & Range("O1").Value & "" and pastes it into the active workbook. The problem that I am facing is that I do not know how to close the workbook that is being copied from. Any ideas?

Thanks in advance.

Please Login or Register  to view this content.

[Leith Ross]

Hello patelh9,

You need to assign the other workbook to an object variable like you did with the ActiveWorkbook. Here is an example...

Please Login or Register  to view this content.

[mikerickson]

Why the illegal *** in your code?
But you might do something like this.

Please Login or Register  to view this content.