Running macro from different workbook

[koklok]

Can somebody tell me how to fix this ?

I have this macro but it only works in this workbook “Obrisi.xls”
I think I need to change the row “Windows("Obrisi.xls").Activate” to be able to do it in the workbook that I have open at the time rather then the workbook in which macro is saved.

I know I can change the code every time I run it but the point is to take currently open workbook and paste there what is needed.

I hope I’m clear with the explanation.

Please Login or Register  to view this content.

[DonkeyOte]

Assign the current workbook name (short version) to a variable at the commencement of your code and use that to switch windows

Please Login or Register  to view this content.

[Leith Ross]

Hello koklok,

I clean your macro code up for you. You don't need to change the directory to a workbook if it is in a different directory. You only need to include the full path.

Please Login or Register  to view this content.

[koklok]

Leith Ross,

The code that you provided me doesn’t work as it should:
If I open a new work (for example: Book1) and run the macro, macro opens a new workbook (Book2) and runs the macro in the new workbook.
And gives me a error message same as below

If I save the empty work book and try to run it from there I get the message:
“Run-time error ‘438’: Object doesn’t support this property or method”
and following is highlighted as error.

Range (“A1”). Paste

Any idea what the problem is?

[Leith Ross]

Hello koklok,

Here is the revised macro. You may need to change the worksheet and workbook names.

Please Login or Register  to view this content.

Sincerely,
Leith Ross