Custom VBA function doesn't work

I wrote a function in VBA called OpenSPDFiles:

Please Login or Register  to view this content.

i pass it those parameters and it opens the file(s) specified by the parameters. in the end OpenSPDFiles equals a string that is just the concatenated filenames of the files it opened. if i dont pass an argument, a userform opens up and asks for the data.

when I call it from another VBA code, it works fine - the files open. but if i go into an excel cell and type =OpenSPDFiles(... the files dont open. but the cell value DOES show the file names of what was supposed to open. AND, if i dont supply one of the params, the userform DOES show. why doesnt the function open the files? I use Workbooks.Open (sPath & sFile) to open. when i step through the code called from the excel cell, i see it highlight the Workbooks.Open but it just doesnt execute. any ideas?


thanks,
Joe

Please read the Forum Rules about thread titles, and then start a new thread with an appropriate title.

You might also post the rest of the code.