From: gammaNO@SPAMblueyonder.co.uk   
      
   Thanks. I was not aware of this restriction.   
   Presumably using Workbooks.Open counts as a change!   
   I did wonder if it was a quirk of using a Function and tried calling a   
   Subroutine from the Function with the Workbooks.Open command in the   
   subroutine but that fails too.   
      
   Peter   
      
      
   "Elef"  wrote in message   
   news:E8E1e.23974$kC3.6054@tornado.fastwebnet.it...   
   > Are you aware of the following constraint when building functions to be   
   > called from a worksheet formula (User Defined Functions) ?:   
   >   
   > A function used in a formula can return a value. It cannot make any   
   > changes to the workbook.   
   >   
   > Hope it helps.   
   > Bye   
   > Elef   
   >   
   > "Peter"  ha scritto nel messaggio   
   > news:chy1e.14216$XH5.11163@fe1.news.blueyonder.co.uk...   
   >> If I have workbook "one.xls" open and try to open a second workbook from   
   >> within a subroutine using   
   >>   
   >> Workbooks.Open "E:\Data\Excel\Two.xls"   
   >>   
   >> "Two.xls" opens as expected.   
   >>   
   >> but if I place the same line of code in a Function rather than a   
   >> subroutine "Two.xls" does not open!   
   >>   
   >> Any ideas?  All I'm trying to do is to extract some data from one sheet &   
   >> copy it to another.   
   >>   
   >>   
   >> --   
   >> Peter   
   >> To err is human but it takes a computer to really mess things up!   
   >>   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)