Open, run macro, and close workbook from another workbook vba code

[WGRoad]

Hello guys,

I have this code inserted in a macro in workbook1:

Workbooks.Open ("C:\workbook2.xlsm")
    INSERT_CAFETARIA
    Workbooks("workbook2.xlsm").Close savechanges:=True

When I do run this, it opens the workbook , runs the macro, but the it goes onto reopening the workbook again, giving me a message asking if I am sure I want to reopen workbook2...

If I only put this:

Workbooks.Open ("C:\workbook2.xlsm")
Workbooks("workbook2.xlsm").Close savechanges:=True

... without the macro that runs from that workbook2, then it opens, saves and closes without a problem. There's nothing wrong with the macro, as it runs well if I directly run it from workbook2. Any thoughts on what might be the problem?

Thanks in advance.

 

[jaybee3]

What does the INSERT_CAFETARIA bit of code do? Can you post that?

 

[WGRoad]

Well, I found the problem... both macros had the same name, making it run in a loop, ence always keep asking me if I was sure I wanted to open again that workbook... solved the problem .

 

[bamaisgreat]

how do you close a workbook that has a name that changes? my sheet saves as date and time so I am unable to put in a specific path.

 

[WGRoad]

Well, you can do a simple ThisWorkbook.save. I believe that might solve the problem?