Re: $$Excel-Macros$$ Help required-Macro to Convert numeric value to words in Excel

[NOORAIN ANSARI]

Dear Vikram,

Please find attached Converter.

On Sun, Feb 12, 2012 at 8:00 PM, Vic Kumar  wrote:

> Hi,
>
> Please find enclosed macro to convert numeric value to words in excel
> (Rupees).
>
> I have enclosed macro related to Dollar value but i need the same for
> Rupees.
>
> Kindly help regarding the same if possible.
>
> Regards,
> VENUS
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Convert Number to Text(Excel and VBA Both).xlsm
Description: Binary data

Re: $$Excel-Macros$$ seeking help on Date format

[in . vaibhav]

Go to control panel and change date format in regional setings.

-Original Message-
From:  .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:*
¨¨*:•.   vadnalaki...@gmail.com 
Sender: excel-macros@googlegroups.com
Date: Sun, 12 Feb 2012 22:25:06 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ seeking help on Date format

Dear Excel Experts

I have a problem in excel date format in column A
whenever i enter the date dd/mm/ it changes to mm/dd/

I tried to change column A with format cell option
but does the same

could you pls help me how to resolve the problem

Regards
V.Kiran Kumar

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Help required-Macro to Convert numeric value to words in Excel

[Vic Kumar]

Hi,

Please find enclosed macro to convert numeric value to words in excel (Rupees).

I have enclosed macro related to Dollar value but i need the same for Rupees.

Kindly help regarding the same if possible.

Regards,
VENUS

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs

[Maries]

Hi,

Try this code:

*Sub LacsChange()
On Error Resume Next
Dim MyCell As Range
For Each MyCell In Selection.Cells
MyCell.Value = MyCell.Value / 10
Next
 On Error GoTo 0
End Sub
*

Regards,

MARIES.

On Mon, Feb 13, 2012 at 9:59 AM, Ashish Bhalara
wrote:

> Dear expert, is there any macro code to transfer value only selected cell
> by running the code?
>
>
> On Fri, Feb 10, 2012 at 6:59 PM, Sam Mathai Chacko wrote:
>
>> This does exactly what you need
>>
>> http://www.ozgrid.com/forum/showthread.php?t=144212
>>
>> Regards,
>>
>> Sam Mathai Chacko
>>
>>
>> On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad 
>> wrote:
>>
>>>  Divide from lac  =165221/10 (1.65221)**
>>>
>>>
>>>   *From:* Ashish Bhalara 
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:* Friday, 10 February 2012 5:34 PM
>>> *Subject:* $$Excel-Macros$$ Transfer number in unit Rs.Lacs
>>>
>>> Dear expert,
>>>
>>> I require the macro to transfer the number in unit Rs.Lacs.
>>> For example the cell which contain number of 165221 then run macro for
>>> selected cell and its value transfer to 1.65221
>>>
>>> Thanks & regards
>>>
>>> Ashish Bhalara
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate threa

Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs

[Ashish Bhalara]

Dear expert, is there any macro code to transfer value only selected cell
by running the code?


On Fri, Feb 10, 2012 at 6:59 PM, Sam Mathai Chacko wrote:

> This does exactly what you need
>
> http://www.ozgrid.com/forum/showthread.php?t=144212
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad wrote:
>
>>  Divide from lac  =165221/10 (1.65221)**
>>
>>
>>   *From:* Ashish Bhalara 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Friday, 10 February 2012 5:34 PM
>> *Subject:* $$Excel-Macros$$ Transfer number in unit Rs.Lacs
>>
>> Dear expert,
>>
>> I require the macro to transfer the number in unit Rs.Lacs.
>> For example the cell which contain number of 165221 then run macro for
>> selected cell and its value transfer to 1.65221
>>
>> Thanks & regards
>>
>> Ashish Bhalara
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Add in for compare work sheets

[NOORAIN ANSARI]

Dear Sandeep,

Please check below link
http://www.exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html

On Sat, Feb 11, 2012 at 10:04 AM,  wrote:

> Dear Excel Expert,
>
> I am a ardent follower of this group and I have seen that some one has
> posted in this forum a Add in to compare two worksheet.
>
> May I request the expert to repost the add in again.
>
> Thanking You,
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Price Download from NSE - Urgent

[Maries]

http://www.mrexcel.com/tip103.shtml

On Mon, Feb 13, 2012 at 8:37 AM, sharad jain  wrote:

> Hi Experts,
>
> Can anyone suggest a way to directly download the prices from NSE website?
> I can provide ticker in a cell.
>
> I am talking about downloading the latest price following url:
>
>
> http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD
>
> Please treat this as an urgency.
>
> Thanks,
> Sharad
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Price Download from NSE - Urgent

[sharad jain]

Hi Experts,

Can anyone suggest a way to directly download the prices from NSE website?
I can provide ticker in a cell.

I am talking about downloading the latest price following url:

http://nseindia.com/live_market/dynaContent/live_watch/get_quote/GetQuote.jsp?symbol=JUBLFOOD

Please treat this as an urgency.

Thanks,
Sharad

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Synchronizing two Pivot tables.

[Awal]

Maries,
With just the data validation the 2 pivot tables in the file you've
attached  are not synchronized;  Am I missing something? Please
advise.
Thanks.

On Feb 12, 8:50 am, pawel lupinski  wrote:
> Maries,
>
> Thanks
>
> regards,
>
> Pawel
>
> 
>  From: Maries 
> To: excel-macros@googlegroups.com
> Sent: Sunday, February 12, 2012 12:58 PM
> Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
>
> Hi Pawal,
>
> Instead of using Combo box & Index formula, I have used Daa validation in B4.
>
> Also I have used the following code to update the data input to pivot filter 
> when worksheet change condition.
>
> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>  If Target.Address(False, False) = "B4" Then
>     ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").CurrentPage = 
> Range("B4").Value
>     ActiveSheet.PivotTables("PivotTable3").PivotFields("Date").CurrentPage = 
> Range("B4").Value
>  End If
> End Sub
>
> Thats it.
>
> Regards,
>
> MARIES.
>
>
>
> On Sun, Feb 12, 2012 at 3:50 PM, pawel lupinski  wrote:
>
> HI MARIES,
>
>
>
>
>
>
>
>
>
>
>
> >Can you let me know how you've done this, please
>
> >Regards,
>
> >Pawel
>
> >
> > From: Maries 
> >To: excel-macros@googlegroups.com
> >Sent: Sunday, February 12, 2012 5:33 AM
> >Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
>
> >Hi,
> >
> >Find the attached file. I have done without INDEX.
> >
> >Regards,
> >
> >MARIES.
>
> >On Sun, Feb 12, 2012 at 7:00 AM, Lawali  wrote:
>
> >Mahesh,
> >>I have resolved the problem. I've used INDEX and Macro Recorder. See 
> >>attached file. But any better solution is welcome..
> >>Thanks.
>
> >>--
>
> >>"Imagine life as a game in which you are juggling some five balls in the 
> >>air. You name them - Work, Family, Health, Friends and Spirit and you're 
> >>keeping all of these in the Air. You will soon understand that work is a 
> >>rubber ball. If you drop it, it will bounce back. But the other four Balls 
> >>- Family, Health, Friends and Spirit - are made of glass. If you drop one 
> >>of these; they will be irrevocably scuffed, marked, nicked, damaged or even 
> >>shattered. They will never be the same. You must understand that and strive 
> >>for it." 30 second Speech by Bryan Dyson (CEO of Coca Cola)
>
> >>--
> >>FORUM RULES (986+ members already BANNED for violation)
> >>
> >>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) Cross-promotion of, or links to, forums competitive to this forum in 
> >>signatures are prohibited.
> >>
> >>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> >>owners and members are not responsible for any loss.
> >>
> >>- 
> >>-
> >>To post to this group, send email to excel-macros@googlegroups.com
>
> >--
> >FORUM RULES (986+ members already BANNED for violation)
> >
> >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) Cross-promotion of, or links to, forums competitive to this forum in 
> >signatures are prohibited.
> >
> >NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> >owners and members are not responsible for any loss.
> >
> >-- 
> >
> >To post to this group, send email to excel-macros@googlegroups.com
>
> >--
> >FORUM RULES (986+ members already BANNED for violation)
> >
> >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) Cross-promotion of, or links to, forums competitive to this forum in 
> >signatures are prohibited.
> >
> >NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> >owners and members are not responsible for any loss.
> >
> >-

Re: $$Excel-Macros$$ seeking help on Date format

[Paul Schreiner]

The problem should be with your Windows Date format settings.
If your Windows Date Format is mm/dd/,
then when you enter anything into Excel that it can interpret as a date, it 
will 
convert it to an Excel date.
which is simply a number.
The number of days since 1/1/1900.
Then, the format of the cell will determine how it is presented (displayed).

With your current settings, you'll notice that if you enter a date like:
 30/04/2012
it will not change.
actually, what happened is: Excel did not recognize this as a valid date,
(30 is not a valid month)
so it left the cell as a text string.
But when entering 12/10/2011, Excel will ASSUME 12 is the month,
so it will change the value to 40887 (try changing the format to "general")
and changing the format to Long Date will result in:
Saturday, December 10, 2011

So, basically, Excel uses the Windows default date format for the basis in 
determining what is a "date" and what is a string of characters.

Setting your Windows date format is different depending on the verision of 
windows.

Let us know your version, and we'll help you change it.

Paul
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: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ 
To: excel-macros@googlegroups.com
Sent: Sun, February 12, 2012 3:25:06 PM
Subject: $$Excel-Macros$$ seeking help on Date format

Dear Excel Experts

I have a problem in excel date format in column A
whenever i enter the date dd/mm/ it changes to mm/dd/

I tried to change column A with format cell option 
but does the same 

could you pls help me how to resolve the problem 

Regards
V.Kiran Kumar


-- 
FORUM RULES (986+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
 
--

To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Difference between VBA and VSTO

[hanumant shinde]

Thanks Deepak




>
> From: Deepak Pal Singh 
>To: excel-macros@googlegroups.com 
>Sent: Sunday, 12 February 2012 11:53 AM
>Subject: Re: $$Excel-Macros$$ Difference between VBA and VSTO
> 
>
>I don't know much about VSTO, but you can read articles on Wikipedia and MSDN..
> 
>http://en.wikipedia.org/wiki/Visual_Studio_Tools_for_Office
> 
>As we all know that there're many office applications
(specially spreadsheets, text editor & presentations) available in the
market today. To retain the No# 1 spot, Microsoft has played a crucial strategic
card. Allowing CLR to develop office applications will give opportunity to the
developers to overcome the limitations of VBA to develop more secure and
interactive applications. VSTO still in a beginning stage & it'll be
interesting to see the chemistry between VBA & VSTO within a couple of
years..
> 
>Regards
>Deepak
>
>
>On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde  
>wrote:
>
>Hi,
>> 
>>Can somebody please tell me what is the difference between VSTO and VBA.
>> 
>>I have heard VBA has left short life after Office 2010 is released.
>> 
>>Can somebody please explain how much is the truth or what are the chances and 
>>etc, etc 
-- 
>>FORUM RULES (986+ members already BANNED for violation)
>> 
>>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)  Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>-- 
>FORUM RULES (986+ members already BANNED for violation)
> 
>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)  Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
> 
>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
> 
>--
>To post to this group, send email to excel-macros@googlegroups.com
>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Difference between VBA and VSTO

[hanumant shinde]

Thanks Noorain n Venkat.




>
> From: Venkat CV 
>To: excel-macros@googlegroups.com 
>Sent: Sunday, 12 February 2012 3:23 PM
>Subject: Re: $$Excel-Macros$$ Difference between VBA and VSTO
> 
>
>Hi Hanumanth,
>
>
>Look Below Link
>
>
>http://netindonesia.net/blogs/andriyadi/archive/2008/08/20/vba-vs-vsto.aspx 
>
>
>Best Regards,
>Venkat 
>Chennai
>My Linked in profile
>
>
>
>On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde  
>wrote:
>
>Hi,
>> 
>>Can somebody please tell me what is the difference between VSTO and VBA.
>> 
>>I have heard VBA has left short life after Office 2010 is released.
>> 
>>Can somebody please explain how much is the truth or what are the chances and 
>>etc, etc 
-- 
>>FORUM RULES (986+ members already BANNED for violation)
>> 
>>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)  Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>-- 
>
>
>
>
>
>-- 
>FORUM RULES (986+ members already BANNED for violation)
> 
>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)  Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
> 
>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
> 
>--
>To post to this group, send email to excel-macros@googlegroups.com
>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ seeking help on Date format

[♥ . • : *¨¨* : • . ♥ . • : V . Kiran Kumar : • . ♥ . • : *¨¨* : • . ♥]

Dear Excel Experts

I have a problem in excel date format in column A
whenever i enter the date dd/mm/ it changes to mm/dd/

I tried to change column A with format cell option
but does the same

could you pls help me how to resolve the problem

Regards
V.Kiran Kumar

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ alert for duplicate name or number while entering the data in the sheet

[NOORAIN ANSARI]

Dear Rajey,

Check Below Link..

http://msdn.microsoft.com/en-us/library/gg508922.aspx


On Fri, Feb 10, 2012 at 12:30 PM, rajeyssh aggarwaal wrote:

> Hello Sir,
> Is it possible while we entering the date in the sheet system alert us
> that the name or number or text already in the sheet but not limit the
> entry of the data, if yes let me know how can we do it and is it possible
> to imply the rule in few rows not in all the rows.
> thanks & regards
> rajesh
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Difference between VBA and VSTO

[NOORAIN ANSARI]

Dear Hanumant,

Please see
http://stackoverflow.com/questions/7492983/what-has-a-better-user-experience-vsto-or-vba-macros

On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde wrote:

> Hi,
>
> Can somebody please tell me what is the difference between VSTO and VBA.
>
> I have heard VBA has left short life after Office 2010 is released.
>
> Can somebody please explain how much is the truth or what are the chances
> and etc, etc 
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
 ** *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Synchronizing two Pivot tables.

[pawel lupinski]

Maries,

Thanks

regards,

Pawel




 From: Maries 
To: excel-macros@googlegroups.com 
Sent: Sunday, February 12, 2012 12:58 PM
Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
 

Hi Pawal,
 
Instead of using Combo box & Index formula, I have used Daa validation in B4.
 
Also I have used the following code to update the data input to pivot filter 
when worksheet change condition.
 
Private Sub Worksheet_Change(ByVal Target As Excel.Range)   
 If Target.Address(False, False) = "B4" Then
    ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").CurrentPage = 
Range("B4").Value
    ActiveSheet.PivotTables("PivotTable3").PivotFields("Date").CurrentPage = 
Range("B4").Value
 End If
End Sub
 
Thats it. 
 
Regards,
 
MARIES.

 
On Sun, Feb 12, 2012 at 3:50 PM, pawel lupinski  wrote:

HI MARIES,
>
>
>Can you let me know how you've done this, please
>
>
>Regards,
>
>
>Pawel
>
>
>
>
> From: Maries 
>To: excel-macros@googlegroups.com 
>Sent: Sunday, February 12, 2012 5:33 AM
>Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
>
>
>
>Hi,
> 
>Find the attached file. I have done without INDEX. 
> 
>Regards,
> 
>MARIES.
>
>
>On Sun, Feb 12, 2012 at 7:00 AM, Lawali  wrote:
>
>Mahesh, 
>>I have resolved the problem. I've used INDEX and Macro Recorder. See attached 
>>file. But any better solution is welcome..
>>Thanks.
>>
>>
>>-- 
>>
>>"Imagine life as a game in which you are juggling some five balls in the air. 
>>You name them - Work, Family, Health, Friends and Spirit and you're keeping 
>>all of these in the Air. You will soon understand that work is a rubber ball. 
>>If you drop it, it will bounce back. But the other four Balls - Family, 
>>Health, Friends and Spirit - are made of glass. If you drop one of these; 
>>they will be irrevocably scuffed, marked, nicked, damaged or even shattered. 
>>They will never be the same. You must understand that and strive for it." 30 
>>second Speech by Bryan Dyson (CEO of Coca Cola)
>>
>>
>>
>>-- 
>>FORUM RULES (986+ members already BANNED for violation)
>> 
>>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) Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>-- 
>FORUM RULES (986+ members already BANNED for violation)
> 
>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) Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
> 
>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
> 
>--
>To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>-- 
>FORUM RULES (986+ members already BANNED for violation)
> 
>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) Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
> 
>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
> 
>--
>To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)
 
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'

Re: $$Excel-Macros$$ Synchronizing two Pivot tables.

[Maries]

Hi Pawal,

Instead of using Combo box & Index formula, I have used Daa validation in *
B4*.

Also I have used the following code to update the data input to pivot
filter when worksheet change condition.

*Private Sub Worksheet_Change(ByVal Target As Excel.Range)
 If Target.Address(False, False) = "B4" Then*
*ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").CurrentPage
= Range("B4").Value
ActiveSheet.PivotTables("PivotTable3").PivotFields("Date").CurrentPage
= Range("B4").Value
 End If*
*End Sub*

Thats it.

Regards,

MARIES.


On Sun, Feb 12, 2012 at 3:50 PM, pawel lupinski  wrote:

>  HI MARIES,
>
> Can you let me know how you've done this, please
>
> Regards,
>
> Pawel
>
>   --
> *From:* Maries 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sunday, February 12, 2012 5:33 AM
> *Subject:* Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
>
>  Hi,
>
> Find the attached file. I have done without INDEX.
>
> Regards,
>
> MARIES.
>
> On Sun, Feb 12, 2012 at 7:00 AM, Lawali  wrote:
>
> Mahesh,
> I have resolved the problem. I've used INDEX and Macro Recorder. See
> attached file. But any better solution is welcome..
> Thanks.
>
> --
> "Imagine life as a game in which you are juggling some five balls in the
> air. You name them - Work, Family, Health, Friends and Spirit and you're
> keeping all of these in the Air. You will soon understand that work is a
> rubber ball. If you drop it, it will bounce back. But the other four Balls
> - Family, Health, Friends and Spirit - are made of glass. If you drop one
> of these; they will be irrevocably scuffed, marked, nicked, damaged or even
> shattered. They will never be the same. You must understand that and strive
> for it." *30 second Speech by Bryan Dyson (CEO of Coca Cola)*
> *
> *
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>   --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to t

Re: $$Excel-Macros$$ Synchronizing two Pivot tables.

[pawel lupinski]

HI MARIES,

Can you let me know how you've done this, please

Regards,

Pawel




 From: Maries 
To: excel-macros@googlegroups.com 
Sent: Sunday, February 12, 2012 5:33 AM
Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
 

Hi,
 
Find the attached file. I have done without INDEX. 
 
Regards,
 
MARIES.


On Sun, Feb 12, 2012 at 7:00 AM, Lawali  wrote:

Mahesh, 
>I have resolved the problem. I've used INDEX and Macro Recorder. See attached 
>file. But any better solution is welcome..
>Thanks.
>
>
>-- 
>
>"Imagine life as a game in which you are juggling some five balls in the air. 
>You name them - Work, Family, Health, Friends and Spirit and you're keeping 
>all of these in the Air. You will soon understand that work is a rubber ball. 
>If you drop it, it will bounce back. But the other four Balls - Family, 
>Health, Friends and Spirit - are made of glass. If you drop one of these; they 
>will be irrevocably scuffed, marked, nicked, damaged or even shattered. They 
>will never be the same. You must understand that and strive for it." 30 second 
>Speech by Bryan Dyson (CEO of Coca Cola)
>
>
>
>-- 
>FORUM RULES (986+ members already BANNED for violation)
> 
>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) Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
> 
>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
> 
>--
>To post to this group, send email to excel-macros@googlegroups.com
>
-- 
FORUM RULES (986+ members already BANNED for violation)
 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Difference between VBA and VSTO

[Venkat CV]

Hi Hanumanth,

Look Below Link

http://netindonesia.net/blogs/andriyadi/archive/2008/08/20/vba-vs-vsto.aspx

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *



On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde wrote:

> Hi,
>
> Can somebody please tell me what is the difference between VSTO and VBA.
>
> I have heard VBA has left short life after Office 2010 is released.
>
> Can somebody please explain how much is the truth or what are the chances
> and etc, etc 
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com