View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Can I pull data from worksheets with a batch file?

Hi Alex

If you want links then use this macro for cells in workbooks
http://www.rondebruin.nl/summary2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Alex" wrote in message ...
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.