View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Can I pull data from worksheets with a batch file?

I have several workbook with a seperate sheet for each week; the same data is
always in every row. Is there a way to pull data (e.g.
='07-03-2006'!$F$60,'07-03-2006'!$H$60,'07-03-2006'!$J$60,'07-03-2006'!$L$60,'07-03-2006'!$N$60)
from a worksheet with a batch file or some command line utility? It would
really simplify my day if I could automate this process. Thanks in advance.