View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default passing arguments by postion through application.run

ApplicationRun "workbook1.xls!module1.macro",noh,nohl

where noh and noh1 ae the variables holding the values passed.

--
Regards,
Tom Ogilvy


"ben" wrote in message
...
I am trying to call a macro from a seperate workbook than the one that

called
it, but the sub calling the other sub needs to pass named arguments
(noh(),nohl()) but the application.run method does not allow the passing

of
named arguments, it says it they need to be passed by postion. I'm not

quite
sure what that means, how do I cause that other macro to be open
"workbook1!module1.macro",noh,nohl while passing those arguments

(variables)
either with application.run or another syntax?