Thanks Bob, the "'" did the trick...
Helmut

"Bob Phillips" wrote:

Try

Application.Run "'" & Activeworkbook.Name & "'!Sort_by_ID"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Helmut" wrote in message
...
Hi Stefi,
I get a Run-time-Error 1004.... actual workbook name!Sort_by_ID cannot be
found.
any other suggestions?
Helmut

"Stefi" wrote:


Try Application.Run Thisworkbook.Name & "!Sort_by_ID"

Regards,
Stefi

"Helmut" ezt Ã*rta:

Hi,
I have a Master workbook called "MESSER" to be used over and over by
new
people.
Upon first use, the name of the workbook is changed to whatever name.

The following statement:

Application.Run "MESSER.xls!Sort_by_ID"

obiously doesn't work in the new workbook with a different name.
Is there anyway to have "MESSER.xls" replaced by an expression which
reflects the new workbook name i.e. the 'currentworkbookname' whatever
that
is?
thanks
Helmut