date:20160111

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

2016-01-11 Thread Mandeep Baluja

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 columns.

try this : 


Sub Test()
Dim rw As Integer
Dim fso As Object
Dim oFolder As Object
Dim F As Object
Dim sf As Object
Dim col As Integer
Dim i As Integer
Dim fil As Object

rw = 2 ' first row
Set fso = CreateObject("scripting.filesystemobject")
Set oFolder = fso.GetFolder("E:\Macros_Collection\")
i = 1
Cells(i, 1) = "Master Folder"
Cells(i, 2) = "Location"
Cells(i, 3) = "File name"
Cells(i, 4) = "Revision times"
Cells(i, 5) = "Date Modified"
Cells(i, 6) = "Revision times"
Cells(i, 7) = "Date Modified"
Cells(i, 8) = "Revision times"
Cells(i, 9) = "Date Modified"

For Each F In oFolder.subfolders
Cells(rw, 1) = F.Name
Cells(rw, 2) = F.Path
For Each sf In F.subfolders
Cells(rw, 3) = Left(sf.Name, 8)
col = 4
For Each fil In sf.Files
If fil.Name <> "Thumbs.db" Then
If Mid(fil.Name, 9, 1) = "R" Then
Cells(rw, col) = Mid(fil.Name, 10, InStrRev(fil.Name, 
".") - 10)
Else
Range(Cells(rw, col), Cells(rw, 9)) = "error"
End If
End If
 rw = rw + 1
Next fil

Next sf
 Next F
 
End Sub


   

-- 
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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2016-01-11 Thread Kat

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,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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Need Help

2016-01-11 Thread Krishnasamy M

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 wrote:
>
> 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*
>
> *Greater Kailash-1, New Delhi*
>
> *Email   *
> *p ankaj...@gmail.com **Skype**  
>  pankaj.sharma_pj*
>
>
>
>
> -- Forwarded message --
> From: Debottam Roy 
> Date: Sun, Jan 10, 2016 at 5:18 PM
> Subject: Need Help
> To: Excel Prince 
>
>
> Hello Sir,
>
> I have attached one file. I faced one problem Please suggest.
>
> I have tried multiple times but still I got partial correct result. Please 
> help me as early as possible.
>
> Thanks and Regards:
>
> Dev
> Contact No: 9958975076
>
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Excel Prince" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excelprince...@googlegroups.com .
> To post to this group, send email to excel...@googlegroups.com 
> .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/excelprince/CADhaybARRbxSffkFiUk3nZVqUL22uLvVvLPYWgtW8WOEeWWHcQ%40mail.gmail.com
>  
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>
>

-- 
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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Combined Output

2016-01-11 Thread Mandeep Baluja


>
> 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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


combination (1).xlsx
Description: MS-Excel 2007 spreadsheet

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

2016-01-11 Thread Veera

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
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2016-01-11 Thread Vinod Kumar

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 forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2016-01-11 Thread Kat

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 achieve this?

Thanks in advanced.


Cheers

-- 
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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


trial.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

2016-01-11 Thread MADHU-GenuineItLlc

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
qualified

*Must have experience with the full SDLC, RPG ILE, and AS/400.*  *Good
communication skills are required.*



JD:-

The Senior Applications Developer is responsible for managing specific
projects and technical initiatives in an efficient/effective manner.  The
Senior Applications Developer must possess a high degree of technical
knowledge regarding software development, associated technology tools, data
structures and the *iSeries (AS/400)* environment using *RPG ILE, DB2, IBM
Operations Navigator, FTP, Windows, and Microsoft Office products.
Experience with Zend PHP a plus and BCD products (Presto, Websmart, etc) a
plus**.* This position contributes to the Applications team primarily in a
technical manner.



*Job Requirements:*

   - Must have 5-10 years experience in Information Systems.
   - AS/400 experience required.
   - Oil and Gas Industry experience required.
   - Bachelor's in Management Information Systems or Computer Science
   required.
   - *PHP experience a plus.*
   - Required to be on-call during work and off-hours as necessary.
   - May travel when necessary for system implementation and training



---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2016-01-11 Thread Mandeep Baluja

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 concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2016-01-11 Thread Paul Schreiner

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
- 

On Monday, January 11, 2016 7:18 AM, 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 forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


 
  

-- 
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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2016-01-11 Thread Vinod Kumar

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 titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


sample.xls
Description: MS-Excel spreadsheet

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

2016-01-11 Thread Paul Schreiner

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 lines of vba code that generates a "Data" sheet with over 151,000 rows 
and 74 columns.(over 11 million cells)
Yet this .xlsb workbook is less than 30Mb (it's 145Mb in .xlsm)I have another 
workbook that has 10 sheets that only use 60 rows and 15 columns (each).and IT 
is nearly a 2 Gb.The difference is: IT has graphics.

So, depending on what version of Excel you're using,what file format, what the 
data consists of, and how you're using it,there are LOTS of "tricks" to access 
a large collection of data.
But unless we know more about your data, there's no way to know what technique 
would work.

Also: define "crash".to some people, anything that causes the program to stop 
is a "crash".but especially with a large database, it could be as simple as a 
variable being used for a row number being defined as an Integer instead of 
"Long Integer". (Integer is limited to +/-32,767)

Another issue in Windows7 and Excel2010 is that for long program execution, 
Windows puts Excel in "background" mode.(it changes Excel to a lower "priority" 
so that you can do other stuff)When this happens, excel shows a "not 
responding" message, even though it's still running.People often interpret this 
as a "crash".
If you can provide a great deal more info (with sample data?) then I/we would 
be glad to help.
 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
- 

On Monday, January 11, 2016 4:51 AM, Kat  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,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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


 
  

-- 
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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2016-01-11 Thread MADHU-GenuineItLlc

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 offer for suitable candidate.

Must be able to work 5 days a week.



Client looking for a senior level security consultant that has had past
experience designing roles and applying those for various large projects.
The resource will be engaged in following activities, hence the
responsibility:



Skill :-

ü  Lead and drive the SAP security project plan per schedule

ü  Take full ownership of SAP security related tasks and drive them to
completion

ü  Work with BPOs and consultants to collect security requirements and
address them on a timely manner

ü  Work with another vendor, Internal IT and other to ensure changes
requested are in alignment with what is already there and assess the impact

ü  Work with Another vendor for affecting the role changes in SAP

ü  Work with leadership team to get approval on roles/proposals and take it
thru SOD checks and work with users to resolve any violations

ü  Work with Internal IT SAP team members for dependencies and conflicts

ü  Communicate with users, PMO and other key stakeholders in precise and
factual manner regarding the current status, activities and support required

ü  Use the security expertise to support and advise on role assignment,
design, or any other aspect of SAP security

ü  Work under very limited direction from client leadership

ü  Coordinate with technical and functional team members and user community
to ensure timely completion of tasks throughout project life cycle.

ü  During UAT – provide immediate support to issues discovered

ü  Work with users to ensure their access/ability to login to SAP



---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

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

2016-01-11 Thread big smile

 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)) 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 Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


SAMPLE PA FILE.xlsx
Description: MS-Excel 2007 spreadsheet

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

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

$$Excel-Macros$$ Re: Need Help

$$Excel-Macros$$ Re: Combined Output

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

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

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

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

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

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

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

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

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

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

14 matches

Site Navigation

Mail list logo

Footer information