Thanks Dilip. I was trying to find something similar in other posts but nothing
about sumproduct with external file. My main problem is how to store the path
name for the file selected by the user in a way that sumproduct can understand,
store the first worksheet name, and pass both variables t
While importing data from 1 site
got msg like dis
This Web query returned no data. To modify the query, click OK, click
the name of the external data range in the name box on the formula
bar, and then click Edit Query on the External Data toolbar.
can any 1 help me out
--
Good tip, thanks for sharing!
Date: Sat, 30 Jan 2010 23:30:25 +0530
Subject: Re: $$Excel-Macros$$ Compare lists and return missing data
From: dilipan...@gmail.com
To: cecic...@hotmail.com
CC: excel-macros@googlegroups.com
Just wanted to share a tip here:-
In order to check if the variabl
Thanks! Almost done, but I have issues with evaluate SumProduct within VBA
can't make it work!! Sent in another e-mail
Date: Sat, 30 Jan 2010 23:27:36 +0530
Subject: Re: $$Excel-Macros$$ Function to return days by month
From: dilipan...@gmail.com
To: cecic...@hotmail.com
CC: excel-ma
Replied to that email seperately, let me know if you did'nt find the same.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 1/30/10, Cecilia Chiderski wrote:
>
> Thanks! Almost done, but I have
Just wanted to share a tip here:-
In order to check if the variables used in the code are empty or have some
values still left within them, you can use following code just before the
"End Sub"
msgbox e
Note:- It will show you the value of e in a pop-up message box.
Best Regards,
--
DILIP KUMAR
You are welcome Cecilia,
Let me know in case if you stuck somewhere in your project.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 1/29/10, Cecilia Chiderski wrote:
>
> Thanks Dilip, I upda
Dear Cecilia,
I was little occupied in some other month closing deliverables at my office,
hence late reply :)
Yes, the code is good. VBA will release the variables after end sub. I
believe e is the values which automatically finishes up during code
execution and a is the range which is set as e
*Can you please send me those e-books to my mail id*
On Sat, Jan 30, 2010 at 4:10 PM, ankur wrote:
> hi chetan
>
> i had send some ebooks at your email id plz check it
>
>
>
> On 30/01/2010, chethan wrote:
> > Hi Everybody,
> >
> > i am very new to the world of VBA macros. i would like to lear
Thanks Ankur for your kind words...
On Sat, Jan 30, 2010 at 10:40 AM, ankur wrote:
> very good approach by vinod
>
> krishnan , i think your query has been solved , if not plz explain
> more about it
>
> On 29/01/2010, Vinod N wrote:
>> Hi Gopi,
>>
>> PFA the solution...
>>
>> Thanks
>> Vinod
>
Hi Ankur,
Please forward the VBA E-Book to me as well... I want to learn VBA...
Thanks
Vinod
On Sat, Jan 30, 2010 at 4:10 PM, ankur wrote:
> hi chetan
>
> i had send some ebooks at your email id plz check it
>
>
>
> On 30/01/2010, chethan wrote:
>> Hi Everybody,
>>
>> i am very new to the wor
I would suggest that you use JitBit macro recorder for this purpose.
www.jitbit.com
Regards,
Alokeshwar
+1 617 710 8441
_
"There are known knowns. These are things we know that we know. There are know
I believe below is what you should use:
Range("ca5") = "abc" & Range("n" & i)
Regards,
Alokeshwar
+1 617 710 8441
_
"There are known knowns. These are things we know that we know. There are known
unk
hi i want to concatenate a text like "abc" to a cell then paste
tried this but not working
"abc"& Range("n" & i).text.Copy Destination:=Range("ca5")
Thanks
--
--
Some important links for excel users:
1. Follow us
hi manoj
after sending the file i notice one mistake
,just clear the cell which contains word "unique list". and unmerge the cell..
rest will serve your purpose
thnks
On 30/01/2010, ankur wrote:
> hi manoj
>
> plz check this attached file, your query has been solved fully, if you
> have any qu
hi manoj
plz check this attached file, your query has been solved fully, if you
have any query , mail me
On 30/01/2010, ankur wrote:
> hi manoj
>
> plz check the attached file
>
> i try to solve it acc to ur need, but not fully solved, may be it help you a
> bit
> thanks
>
> On 30/01/2010, manoj
hi chetan
i had send some ebooks at your email id plz check it
On 30/01/2010, chethan wrote:
> Hi Everybody,
>
> i am very new to the world of VBA macros. i would like to learn macros
> can anybody help me out in getting the proper way to get available
> materials to learn the VBA from the sc
Hi,
my requirement is
Get data (Example "Name" & "Number" ) from Excel sheet and fill the same in
two text boxes in an already opened internetexplorer and then submit. This
shall be repeated for the nexr row of data. like wise i want loop them for
100 similar postings
Please help me with complete c
Hi Everybody,
i am very new to the world of VBA macros. i would like to learn macros
can anybody help me out in getting the proper way to get available
materials to learn the VBA from the scratch.
--
--
Some importan
hi manoj
plz check the attached file
i try to solve it acc to ur need, but not fully solved, may be it help you a bit
thanks
On 30/01/2010, manoj kukreja wrote:
> Hi All,
>
> PFA excel working ,que is there
>
> Regards
>
> Manoj
>
> --
> -
20 matches
Mail list logo