Re: $$Excel-Macros$$ Macro is not working

2016-09-03 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
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

Re: $$Excel-Macros$$ Macro is not working

2016-09-02 Thread GENIUS
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

Re: $$Excel-Macros$$ Macro is not working

2016-09-02 Thread Gaurav Devrani
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

Re: $$Excel-Macros$$ Macro is not working

2016-09-02 Thread Learner Excel
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

$$Excel-Macros$$ Macro is not working

2016-09-02 Thread Izhar
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://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles