Change your statement to...

Application.Run wbTemp.xls!timesheetFeed


-----Original Message-----
I have a sub that loops through a series of files whuch
are given the name
"wbtemp" which is an xls file. After various processing
I then want to call
a macro called "timesheetfeed" contained in this file.
I am trying to do
this by this line of code with variations on using ""
etc:

Application.Run wbTemp!timesheetFeed

I get a runtime error 438 which is "object doesnt
support this method..."
can anyone suggest what to do?


.