Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sub vs. function bhavior regarding 'Workbooks' obj. functions
Hello guys,
This is my first post here and i really need help. I'm writing a VBA function for excel that should parse its arguments from one sheet based on tables on an entirly different Workbook file. So, I wrote: --------------------------- Public Function foo(...) as String ... Workbooks.open Filename:= "path\filename.xls" ... foo = result End Function --------------------------- But the thing isn't working, it doesn't open the file, though it doesn't give any error messages. It just continue until it reach the stage where it tries to read from the file and terminate. This happens even when I manually open the file before hand! The really ODD thing is that once I replace "Public Function/End Function" with "Sub/End Sub" the file magically open!!! So, what makes the difference? PS: I really need it has a function. PPS: I use Office 2000 on Win2000 regards, Ali --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Functions Available for all Workbooks | Excel Worksheet Functions | |||
functions between workbooks. | Excel Worksheet Functions | |||
Indirect and sumif functions with multiple workbooks | Excel Discussion (Misc queries) | |||
How do I make my functions public to all workbooks? | Excel Discussion (Misc queries) | |||
Functions referencing unopened workbooks | Excel Worksheet Functions |