current workbook name
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
|