I'm curious about your file size and response issue. What version of Excel are
you using?As ask because I use Excel 2010 and have a file that is generated
from 5 different data sources.The file contains 29 sheets,one of which contains
145,500 rows and 74 columns.There are 27 macro modules containing 13,700 lines
of VBA code. This, to me, seems to be a rather large file. If I save it as
Excel97-2003 format (.xls) it is 83Mb,If I save it in Excel2010 macro format
(.xlsm) format, it's 55Mb.If I save it in Excel2010 binary format (.xlsb), it's
only 17Mb. (the .xlsb format runs MUCH faster) So, I'm curious as to why your
file is 350mb.Does it contain graphics/images?Are there lots of formulas?
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
-----------------------------------------
From: Mandeep Baluja <rockerna...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Tuesday, April 28, 2015 6:11 AM
Subject: $$Excel-Macros$$ Re: Query to retreive data
Yes it works, Thanks for the same we can considered this issue is resolved. But
one thing Excel is not useful for large files On Daily basis I got files of
350 mb having data of 2-3 lakh rows and I am unable to combine the same jjust
because excel not responds.
On Tuesday, April 28, 2015 at 3:10:42 PM UTC+5:30, Nasir Saikh wrote:
Hi Mandeep As per my suggestion you can use table link vloopup as I am using
and it is working fine. Example is given below. Sub LoopUp()
Dim iRow As Integer
Dim MaxRow As Long
MaxRow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
Range("B2").FormulaR1C1 = "=VLOOKUP(RC[-1],'C:\Users\
n0258542\Documents\[Aakash - Copy.xlsx]Input_Consolidated'! R1C2:R44C5,4,0)"
For iRow = 3 To MaxRow
Selection.Offset(1, 0).Select
Selection.FillDown
Next
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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
