you dont need access, you can continue using excel & thru DAO you can
retrieve data from closed workbook too..
On Wed, Apr 29, 2015 at 10:35 AM, Nasir Saikh wrote:
> r8 Pramod access is very easy and taking very less time than excel on huge
> data you can use it till 2 GB data.
>
> On Tuesday, A
r8 Pramod access is very easy and taking very less time than excel on huge
data you can use it till 2 GB data.
On Tuesday, April 28, 2015 at 11:34:45 AM UTC+5:30, Mandeep Baluja wrote:
> My mmaster file is large and i just want to do lookup on my sheet from
> master file without opening my mast
you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Mandeep Baluja
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
Why not you are using MS Access. It's pretty cool and can we use easy..
this is best for if some one have to work in large data
Pramod
On 28 Apr 2015 15:41, "Mandeep Baluja" wrote:
> Yes it works, Thanks for the same we can considered this issue is
> resolved. But one thing Excel is not usef
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
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\n025
