Excel validation data to run macro..

[calvinle]

Hi,

I am working with 2 macro, 1 is for english and another one for french.
They are called. MacroEng, and MacroFre. All they do is format column and rows, and merge data. Nothing too important.
Now, in a master sheet, I have created a button to click open an excel file. Now, I want to be able to:
If the selected open file contains in cell A4 : Sommaire, then run MacroFre.
If the selected open file contains in cell A4: Summary, then run MacroEng.

This way, I won't need to add 2 separate button for French, or English. But only 1 button can do the job.

Here is my macro to call an open selected file:

Please Login or Register  to view this content.

Please help.

[pleas]

Please Login or Register  to view this content.

You don't say if the button is an ActiveX or forms button. The method to call the procedure varies. If it's an ActiveX button, then double click the button and add the procedure body to the Click event, otherwise right-click the button and use 'Assign Macro'

[calvinle]

I made a test like:

Please Login or Register  to view this content.

not working...

[alansidman]

What does not working mean? Are you getting an error message? If so, when you click debug, what line is highlighted?

[calvinle]

Sorry, I did not explain the error. There was no error. The only problem is that it runs the macro second call only and not the first call.

Please Login or Register  to view this content.

It runs the Call French for both scenario, unless it cannot detect the word Report Summary?

[calvinle]

Ah nevermind, I figure it out base on ur help.
I wrote it as:

Please Login or Register  to view this content.

Thanks