View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
David Sisson[_2_] David Sisson[_2_] is offline
external usenet poster
 
Posts: 15
Default run macro for all files in directory - error in my code

In that case, change

aLinks = wbk.LinkSources(xlExcelLinks)
to
aLinks = wkbk.LinkSources(xlExcelLinks)