View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CraigJ CraigJ is offline
external usenet poster
 
Posts: 4
Default Run a macro when I open a workbook

How can I run a macro automatically when I open a workbook? Also, how can
linked data automatically be refreshed wihtout clicking any buttons? I
basically want to use the windows task scheduler to open a workbook with
linked information at a specific time each day and then run a macro. I don't
know much about VBA, so please keep the response simple.