activating a different workbook without knowing its name.

[motybetesh]

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

 

[Andrew Poulsom]

Do you mean that you added a button to the QAT? Or are you using Excel 2003?

 

[motybetesh]

escel 2010

 

[Andrew Poulsom]

Please list the steps you took to add your button.

 

[motybetesh]

Top Menu - customize - More commands - on the list of commands choose Macros - and then choose the macro I need.

It worked on Personal.xlsx, what would be the command to execute a macro 4.0 ? (that is a part that I need to do afterwords )

 

[Andrew Poulsom]

Where do I find "Top Menu - customize - More commands"?

 

[motybetesh]

It´s the little arrow on the left of the menu where the save, undo, redo buttons are. can I attached screen prints?

 

[Andrew Poulsom]

If by menu you mean Quick Access Toolbar, I don't see that control in my version of Excel 2010.

 

[motybetesh]

oops, Sorry, my excel is 2007.
what would be the command to execute a macro 4.0 and how do I address the macro 4.0 that is on the workbook that records the data?

 

[Andrew Poulsom]

I don't see it in Excel 2007 either.

You can use Application.Run in VBA to run an Excel 4 Macro. There's an example here:

Calling Excel 4 Macros From VBA [SOLVED]

Assign the VBA procedure that runs the Macro to your button.

 

[motybetesh]

Thanks, I recorded the procedure I needed in a macro in VBA . and now it works. thanks for your patience .
If you want me to send you screen prints of the procedure to add a button for the macro send me your Email