pickup the amount from the workbook
Hello,
I have the workseet summary which layout is like below: Job. amount: --- ---------- A 1000 B. 2000 Currently, the way we prepare the summary is to open workbook A and copy paste to A, and we take the amount 1000 from Cell lets say C2, we do the same for Job B. All the workbooks have the same cell address as the source of the above summry. My question is how can we make macro, without openning it and do like what we want in the summary. All the workbook/excell files are in folder:C:\projects\* Name of the file varying as per name of the job, for example job A, is in C:\Projects\A. Thanks for any idea -- H. Frank Situmorang |
pickup the amount from the workbook
G'day Frank
you could try Ron DeBruins Website, he has a few examples that may set you in the right direction. http://www.rondebruin.nl/ado.htm http://www.rondebruin.nl/copy7.htm HTH Mark. |
pickup the amount from the workbook
Thanks mark for your response. One fo the VBA that I need to understand:
ShName = "Sheet1" '<---- Change Set Rng = Range("A1,D5:E5,Z10") '<---- Change How if I wan to set that the range is not the continues range, but it is to take the content of the certain cells which is vertically this: D114,D59,E59,D66,f66,D73,F73,D102,F95,D103,D104. The content of those cells are formula, but I want to copy it a sheet to combine from all invidual Jpb workbook. Thanks in advance -- H. Frank Situmorang "NoodNutt" wrote: G'day Frank you could try Ron DeBruins Website, he has a few examples that may set you in the right direction. http://www.rondebruin.nl/ado.htm http://www.rondebruin.nl/copy7.htm HTH Mark. |
All times are GMT +1. The time now is 08:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com