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 a
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 this
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
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 =NOT(EXP(E:RT)
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 off
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
--
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 line
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
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
Hi Mandeep,
I've changed my code to the following. In terms of the revision times, I
want to check whether it's following the format or not as well. Other than
that, I'm not sure how to put the date modified in it as well.
On Monday, 11 January 2016 17:50:35 UTC+8, Mandeep Baluja wrote:
>
>
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
=TIME(2,D
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 column
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 @
> https://www.facebook.com/discussexcel
>
>
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 wrot
>
> 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
15 matches
Mail list logo