Excel: activating a different workbook without knowing its name.

Hello there 1. I have a file where I record a list of information. 2. that information is copied, by a macro, from an XML file such as 6550010000305931007020640-procNfe.xml 3. first I change it to .xls and open it, (or even without changing it) it opens as pasta1, pasta2..... I´m trying to execute the macro that is on the permanent workbook. (I have for that macro a button on the excel menu) but clicking on it, gives a massage that the macro is not available on the that workbook (pasta1, pasta2.... name keep changing) I would like to know how do I get the macro to start without its workbook being active ? Or if I start with it, how do I tell excel to look for the other files ? Thanks Moty

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of July 18, 2014.

For more resources for Microsoft Excel