Run macro in another file

[mrmaso]

Hi,
I would like to run macro in different file. It means I have opened file (master) where I start up the macro which will open another file and there I need to do some actions. Is it possible to write macro in first (master) file or it must be somehow writtten in second (opened) file?

Thank you for help

 

[Kaper]

Your macro to process data in freshly-opened file can be in either of them (master or newly-opemned one).

If you do in master file:

worksheets.open "C:\my_folder\slavefile.xlsx"
sheets(1).range("A1")="Ammended by Kaper macro"
activeworkbook.save false
activeworkbook.close

your slave.xlsx will be opened, something written in its A1 cell in first sheet, then saved and closed.

So all changes occur not in master but in a "child" workbook.

 

[mrmaso]

This I understand. But it is possible somehow to write macro in master file which will done these changes?

 

[Kaper]

But this code IS in "Master" file and changes are in "Slave" ...

 

[mrmaso]

You are right, but I need to write macro which will done more actions. So one macro will open the file and second will done other tasks. But I try your solution with Cell change but there is also mistake and I dont know what I am doing wrong. There is error message
run-time error ´13´:
Type mismatch

when to come the line:
Sheets(Hárok1).Range("A47") = "Ammended by Kaper macro" - sheets name is "Hárok1"

So sheet is going to open but then is mistake.

Thank you.

 

[Kaper]

Use sheet name as a string - to let VBA know it is a string - use doublequotes as for text string to be inserted in a cell.

[COLOR=#333333]Sheets("Hárok1").Range("A47") = "Ammended by Kaper macro"[/COLOR]