Returning value from Library function

K

Kevin

I am a new developer, and have just begun developing
generic library functions. In my current application, I
am attempting to assign a folder name for an Excel
spreadsheet using a library function BrowseFolder which
utilizes the FileDialog method by:

[Form Button Code]
strFolderName = BrowseFolder("Choose Export Folder")
MsgBox BrowseFolder Returns ""

[Library Function Code]
BrowseFolder = varSelectItem & strFileName
MsgBox BrowseFolder, Returns <correctpathname>

I tested and debugged this code prior to making it a
separate function. The library function still assigns the
right path, but the value is not being passed to
strFolderName.

Anyone know why?
 

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

Top