pickup the amount from the workbook

[Frank Situmorang]

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

 

[NoodNutt]

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.

 

[Frank Situmorang]

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