ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I pull data from worksheets with a batch file? (https://www.excelbanter.com/excel-discussion-misc-queries/118576-can-i-pull-data-worksheets-batch-file.html)

ALEX

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.

Ron de Bruin

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