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