On Saturday, September 3, 2016 11:42 AM, GENIUS
wrote:
THANK YOU VERY MUCH MR GAURAV DEVRANI AND ALSO THANKS FOR MR XLS S for a new
way of doing the same.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
THANK YOU VERY MUCH MR GAURAV DEVRANI AND ALSO THANKS FOR MR XLS S for a
new way of doing the same.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
Hi,
I believe your code is extracting the file name from the path which you are
browsing.
Your code had problem in substitute formula. Please check
Function Extractfilename(url As Variant) As String
For i = 1 To Len(url)
If Mid(url, i, 1) = "\" Then
x = x + 1
End If
Next i
'n = Application.Worksh
For list of file name, use enclosed code.
--
On Fri, Sep 2, 2016 at 10:33 PM, Izhar wrote:
>
> Please open the file and see the question
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https
