How to access ranges in closed workbooks in custom functions

D

Deepak Agarwal

I have written a custom function. One of its arguments is
a range. This function works fine when the referred range
is in the workbook that contains the custom function.
However, when this range is in an external workbook it
works ok so long as the external workbook is open. But
this external workbook is closed, the function returns an
error.

What do I need to do to overcome this problem?

Please help!

Deepak
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access closed workbook range in Custom functions 6
Save As and new workbook new name used in existing code 8
Custom Document Properties in Word documents and Excel workbooks 13
dynamic reference to data in multiple closed workbooks 2
custom function closed workbooks 3
Problems with Custom Functions and Muiltiple open workbooks 8
Excel sum if and closed workbooks 2
Issue Accressing current range of a closed workbook 2

Top