Opening workbooks from UDFs

W

widdowb

Can anyone tell me if it is possible to open (extract data an
subsequently close) another workbook from within a user-define
function.

A standard workbooks.open command appears to do nothing within a UDF.

Many thanks
 

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

Need Help with Macro Security 1
From where is my UDF called? 8
Copying a UDF from an Add-In module to a workbook. 3
User Defined Function being called by changes to an independent workbook 13
UDF XLA and SQL queries 1
Calling one UDF from another in a different module 5
Time within time 8
Page numbering with Merged Document and IF statements 1

Top