Trying to copy data from one workbook in another and return one field as result

Hello Excel-Experts,
I have a problem with a vba Macro I wrote. Aim of the Function is to:
- Save the data in fixed relative Positions to the cell the function is located in
- enter the saved data in parameter fields in another workbook
- return as "value" of the field the function is written in the value of one field in this second workbook.
After some problems now the function gets compiled as correct - but when entering the function in a cell nothing happens
(I can't see the values being entered in the second workbook, the Cell with the function only shows "#Value"
I wrote the same stuff as "sub" which does exactly what i want - i would just prefer having it as a formula.
Thanks for your Help,
PB

Please Login or Register  to view this content.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

Try:

Please Login or Register  to view this content.