Re: $$Excel-Macros$$ vba code for listing folder name and file name

Hi Mandeep, The revision time in my snapshot is the one I use writing. The real code isn't showing. It's not showing the folder name and file name as well. In terms of revision times, it's fine if the changes are done in certain interval. On Monday, 11 January 2016 15:34:15 UTC+8,

Re: $$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

When you are subtracting, you are excluding the start date. On Mon, Jan 11, 2016 at 10:30 AM, Izhar wrote: > Please open the attachment see the question. > Thanks in advance. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Please elaborate what do you mean by "revision times". Do you want to show the time when it was most recently updated or you want to show how many times has it been updated? On Mon, Jan 11, 2016 at 9:52 AM, Kat wrote: > Hi all, > > I want to create a xlsm file which

$$Excel-Macros$$ vba code for listing folder name and file name

Hi all, I want to create a xlsm file which list out the folder name, file name and revision times with its corresponding date modified. When there is new file updated, i hope it can be updated automatically in the workbook. may I know how can I achieve this? Thanks in advanced. Cheers --

$$Excel-Macros$$ QUESTION FOR DAYS DIFFERENCE

Please open the attachment see the question. Thanks in advance. -- 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

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Please see if this solves your purpose - http://www.vbaexpress.com/kb/getarticle.php?kb_id=837 On Mon, Jan 11, 2016 at 11:55 AM, Kat wrote: > Hi Abhi, > > In terms of revision times, I want to show all the current revision times. > Also, in the future, if there is any

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Hi Abhi, Unfortunately, the code doesn't apply for my case. On Monday, January 11, 2016 at 2:52:34 PM UTC+8, Abhi wrote: > > Please see if this solves your purpose - > > http://www.vbaexpress.com/kb/getarticle.php?kb_id=837 > > On Mon, Jan 11, 2016 at 11:55 AM, Kat >

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Revision time ?? I have not heard about this while searching it on the internet I found this http://excel.tips.net/T002868_Using_Revision_Tracking.html which track the changes done workbook shared on network. Is revision time being noted anywhere in your workbook your snapshot is not showing

$$Excel-Macros$$ Required Missing Date

Dear All members, I have an excel sheet which being extracted from a fingerprints device that shows all dates employees had put their fingers already to prove their presence. My request is how to make equation that shows to me the other dates employees didn't put their fingerprints in the

Re: $$Excel-Macros$$ Required Missing Date

Hi Plz share a sample workbook. On Sunday, January 10, 2016, Ahmed Emam wrote: > Dear All members, > > I have an excel sheet which being extracted from a fingerprints device > that shows all dates employees had put their fingers already to prove their > presence. > > My

Re: $$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

in Conditional formatting use formula: =AND($F5>=TODAY(),$F5<=TODAY()+14) Applied to : =$A$5:$AI9 and secondly in Function GetConcat formula coding use : Application.Volatile for Auto refresh *Pankaj Sharma * *MIS Analyst* *Greater

$$Excel-Macros$$ Refresh d15 automatically when last any entry of any raw change

Respected All Thanks a lot High light Raw works properly But still Second option do not work Enclosed file for details 1] In Cell - D 15 not work according to my question If I make any changes in any cell ex -- If I make the change any other raw Then all the details pertaining --

Fwd: $$Excel-Macros$$ Refresh d15 automatically when last any entry of any raw change

use this: Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Long: r = Target.Row If r >= 5 And r < Sheet1.Range("A" & Rows.Count).End(xlUp).Row Then r = r - 3 Range("C15").FormulaR1C1 = "=OFFSET(R[-12]C[1]," & r & ",0)" End If End Sub *Pankaj Sharma

$$Excel-Macros$$ Fwd: Need Help

use this: Sub Reporting() Dim abc As Long: abc = Sheet1.Range("A" & Rows.Count).End(xlUp).Row Sheet1.Range("B7:B" & abc).FormulaR1C1 = "=IF(RC1=,,TEXT(RC1,""mmm"")&""-""(RC1,""yy""))" End Sub *Pankaj Sharma * *MIS Analyst*