getting the value of a cell from a closed workbook

[sammendac]

Help

I have several workbooks and a master. I need to get the values of cells in the other workbooks into my Master. I need the VBA solution and as I am fairly new to VBA I would like it to be simple.

Any Ideas and thanks in advance.

 

[Xeroh]

You can get individual cell data from closed books without using VBA - is this not a desired solution?

 

[Xeroh]

Something like: ='T:\File Path\[File Name.xlsx]Tab_Name'!C32

 

[sammendac]

You can get individual cell data from closed books without using VBA - is this not a desired solution?

Thanks for the reply.
Yes it could be but how?

 

[Xeroh]

You can also use this link like any other function: ='T:\File Path\[File Name.xlsx]Tab_Name'!C32 * -1 would negate the value if you are dealing with credits/debits

 

[sammendac]

You can also use this link like any other function: ='T:\File Path\[File Name.xlsx]Tab_Name'!C32 * -1 would negate the value if you are dealing with credits/debits

Thanks Xeroh. I already use that but I thought that it would be easier to use VBA.

again Thanks

 

[GTO]

Extracting data from a closed workbook cell-by-cell may be slow. If it is only a few cells per workbook, and keeping the workbook closed is a big desire, you can check out VBA Express : Excel - Extract Data From Closed Workbooks

Hope that helps,

Mark

 

[sammendac]

Extracting data from a closed workbook cell-by-cell may be slow. If it is only a few cells per workbook, and keeping the workbook closed is a big desire, you can check out VBA Express : Excel - Extract Data From Closed Workbooks

Hope that helps,

Mark

Mark Thanks

As I only want to look at 1 cell per Workbook, I will take a look and see if it does what I want. The reason why I want to use VBA is I need the data from the other workbooks to appear on an action (press a button) as they must be blank until then.