application.run 'current' filename?
 

I have this code:

Application.Run "MESSER.xls!Sort_by_ID"

how can I make the "MESSER.xls" to be automatically the "current" Filename?

Helmut

application.run 'current' filename?
 

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

--
HTH

Bob Phillips

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

"Helmut" wrote in message
...
I have this code:

Application.Run "MESSER.xls!Sort_by_ID"

how can I make the "MESSER.xls" to be automatically the "current"
Filename?

Helmut