G
Glen Mettler
Using Excel 2002
I am using the FileDialog sub provided in the help to open a file.
I want to call that from another sub and return the selected filename.
I change FileDialog from a sub to a function but I can't get it to return
the name of the selected file.
Here is what I want to do:
MySub()
MyPik = FileDialog("")
If MyPik = "" then
exit sub
end if
If MyPik <> xxx then
exit sub
else
openfile
endif
I can't get the FileDialog function to return the file name
Glen
I am using the FileDialog sub provided in the help to open a file.
I want to call that from another sub and return the selected filename.
I change FileDialog from a sub to a function but I can't get it to return
the name of the selected file.
Here is what I want to do:
MySub()
MyPik = FileDialog("")
If MyPik = "" then
exit sub
end if
If MyPik <> xxx then
exit sub
else
openfile
endif
I can't get the FileDialog function to return the file name
Glen