Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
get file chosen 1
- Thread starter Johnny42
- Start date
-
1
- #2
Easy way is to change the Sub to a Function, and set it's return value to the result you want
...You may need to edit out the Workbooks.Open etc
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts
Code:
Function OpenSingleFile() As String
' as existing down to last line
OpenSingleFile = Filename
End Function________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts
- Status
Similar threads
