Excel macro problem

[Paul Meyer]

Hi there,

i currently convert an excel file to newer excel version. In the excel file
is a macro command named "FORMEL.SUCHEN.UND.ERSETZEN" (englisch:
FORMULAR.REPLACE). The problem is, that Excel crashes at this command and i
can't find the bug. Maybe the parameters has changed, but i can't find this
into help. Maybe someone can give me a hint what is todo

=FORMEL.SUCHEN.UND.ERSETZEN("f-month";"f-1-05";2;1;
(FORMULAR.REPLACE("f-month";"f-1-05";2;1;)

Regards,
Paul

 

[Dave Peterson]

This is one of those old XLM macro commands--so I bet the parms didn't change.

The help says it should have these parms (in English):

FORMULA.REPLACE(find_text, replace_text, look_at,
look_by, active_cell, match_case)

lookat = 2 is the same as part (doesn't have to match the entire cell).
lookby = 1 is looking by rows

====
Now my guess: Is the worksheet protected so that the change cannot complete?

You can get the old help files for these functions here:
http://www.microsoft.com/downloads/results.aspx?freetext=Macrofun

(but it's in English)

 

[Paul Meyer]

Dave,

thanks a lot for your answer.

Now my guess: Is the worksheet protected so that the change cannot

complete?

no, the file isn't write-protect or sheet-protected. If i use the "Search
and replace" Dialog, all works fine. But not with the macro, excel crashes.
The macro replaces placeholder to new values, wich are links to external
xls-files (= like c:\test\test.xls[]$G6).

Regards,
Paul

 

[Dave Peterson]

I don't have any other guesses.

If you know what the macro does, you may want to consider creating an equivalent
version in VBA.

Dave,

thanks a lot for your answer.

Now my guess: Is the worksheet protected so that the change cannot

complete?

no, the file isn't write-protect or sheet-protected. If i use the "Search
and replace" Dialog, all works fine. But not with the macro, excel crashes.
The macro replaces placeholder to new values, wich are links to external
xls-files (= like c:\test\test.xls[]$G6).

Regards,
Paul