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. |
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. |
All times are GMT +1. The time now is 07:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com