Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pickup the content of Cells ( in formula) | Excel Worksheet Functions | |||
To delete paired numbers or pickup last cell for each item | Excel Discussion (Misc queries) | |||
Vlookup (pickup the last row... | Excel Worksheet Functions | |||
excel won't pickup an Access query for a pivot table | Excel Programming | |||
VBA: Reference to a workbook / amount of days | Excel Programming |