help with data from a second wokbook in the open workbook

Hi Team,

With help from this forum I have become reasonably adept at bringing back a single cell value from another workbook using this code as an example

Please Login or Register  to view this content.

My current challenge (ie. issue / problem ) is this:

I really would like to return a string that is the concatenation of (in this case) cells B6, B7, B8 & B9 but despite experimenting with various code solution have dismally failed to get the right result (the cells in question contain a "fielded" address in an different workbook and I want to "join them together" for simple one line summary display in the primary workbook)

In practice, I can probably live with just the first cell as that will generally be enough information to the end user but the full address would be much better

Cheers

Jmac

Hi Jmac,
try this (code in a standard module)

Please Login or Register  to view this content.

Try recording the concatenation and see what formula it returns.

Without actual worksheets, books and paths, it would be hard for me anyway to understand why the recorded code doesn't give a satisfactory solution. However another suggestion would be to use a helper cell in your property_register workbook to do the concatenation, and then pull off of that cell instead of B6.

Hi John,

I suspect we are at cross purposes here.

In my last post i included the code generated by the formula in excel itself. It may be that I am mis-understanding your "record the code" so I will give it a different attack this time.

In the meantime I had already implemented a "helper cell solution" as my "Plan B" so I am happy that you agree this is also a valid option.

Thanks for your assistance

Jmac

@john H Davis and @nilem

Thanks again for your suggestions. As I mentioned in my last post I gave "recording" another try but didn't make much progress so as time is of the essence I went for the low tech solution of a helper cell (as also suggested by @john) and that works fine for me, it actually has a side benefit as well as being "low tech and simple" in that I can more easily deal with null components of a fielded address.

Again, thanks for taking the time to respond, as always I appreciate it

Jmac

You're welcome. Glad to help out and thanks for the feedback.