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

Hey Kat, I am sorry but i didn't get the logic of this code which is totally different from your above query,Things which i understand its just checking whether file_name following the criteria or not, if 9th letter of the file name is equal to R then do something else show error in all

$$Excel-Macros$$ how to handle large data with vba code

Hi all, I was wondering what can I write for the code with large data in vba because the program always crash when I try to execute. The data I'm trying to deal with is more than 5GB. Thanks in advanced. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Re: Need Help

Sub Solution() Range("A7").Select Do Until IsEmpty(ActiveCell) ActiveCell.Copy ActiveCell.Offset(0, 1).Select ActiveCell.PasteSpecial xlPasteAll ActiveCell.NumberFormat = "MMM-YY" ActiveCell.Offset(1, -1).Select Loop End Sub On Sunday, January 10, 2016 at 8:51:53 PM UTC+5:30, Pankaj Sharma

$$Excel-Macros$$ Re: Combined Output

> > PFA !! Mandeep baluja -- 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, like Please

Re: $$Excel-Macros$$ Re: Combined Output

Thank u so much.. On Mon, Jan 11, 2016 at 1:31 PM, Mandeep Baluja wrote: > PFA !! Mandeep baluja > > -- > 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 @ >

$$Excel-Macros$$ Re: Higher and Lower value to show in different column

thakyou.. On Monday, January 11, 2016 at 5:47:48 PM UTC+5:30, Vinod Kumar wrote: > > Dear Team, > > pls do the needful, on the above mentioned subject. > > > -- 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

$$Excel-Macros$$ vba code for getting the date

Hi all, I'm trying to create vba code with corresponding date modified according to the file. Can anyone help me with the code? I would like to get just the date showed, not the time. When there is new file updated, i hope it can be updated automatically in the workbook. may I know how can I

$$Excel-Macros$$ Client in Houston TX need Sr. Applications RPG Developer--F@F must

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : RPG Developer* *Duration:** 12 months* *Location : Houston TX* *Interview Process:* *Face-to-face interview is required.* *Client:* Confidential at client’s request until candidates have been

$$Excel-Macros$$ Re: Higher and Lower value to show in different column

Put this in f8 =MAX($C$8:$C$11) put this in g8 =MIN($C$8:$C$11) Ticket closed - -- 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

Re: $$Excel-Macros$$ Higher and Lower value to show in different column

you can use =Max(C8:C11) and (Min(C8:C11) Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley

$$Excel-Macros$$ Higher and Lower value to show in different column

Dear Team, pls do the needful, on the above mentioned subject. -- 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$$ how to handle large data with vba code

Your question is much too broad.Actually, it isn't really a question.It is really a statement that you were "wondering" about something. secondly, "5Gb of data" doesn't really mean anything.I have a report that collects data from multiple sources.The workbook has 29 worksheets.It has 14,000

$$Excel-Macros$$ Urgent need Sr SAP Security consultant--Indianapolis

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :Sr. SAP Security consultant* *Location : Near Indianapolis* *Duration: 4+ months* Rate: market + Expenses. *JD:-* Interview to happen between Monday and Wednesday of coming week and immediate

$$Excel-Macros$$ CURSOR SHOULD BE ON NAME MANAGER WHEN EVER I OPEN THE FILE

Respected All I attached sample file I want there when ever I open this file For Ex -- my cursor should be on particular name manager in this --- CAL Please share the formula too so that I can use the same technique in other files too THANKS A LOT -- Are you =EXP(E:RT) or