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 http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Feb 10, 2012 at 10:46 PM, hanumant shinde

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

HI MARIES, Can you let me know how you've done this, please Regards, Pawel From: Maries talk2mar...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, February 12, 2012 5:33 AM Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables. Hi,  

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) =

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

Maries, Thanks regards, Pawel From: Maries talk2mar...@gmail.com 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

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

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 arsfan2...@yahoo.co.inwrote: Hi, Can somebody please tell me what is the difference between VSTO and VBA. I have heard

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

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 rajey...@gmail.comwrote: 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

$$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+

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

Thanks Noorain n Venkat. From: Venkat CV venkat1@gmail.com 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

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

Thanks Deepak From: Deepak Pal Singh deepaktheind...@gmail.com 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

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

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

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

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 lupins...@yahoo.com wrote: Maries, Thanks regards, Pawel  From:

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

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

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

http://www.mrexcel.com/tip103.shtml On Mon, Feb 13, 2012 at 8:37 AM, sharad jain jainshar...@gmail.com 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

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

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, chhajersand...@gmail.com wrote: Dear Excel Expert, I am a ardent follower of this group and I have seen that some one has posted in

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

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 samde...@gmail.comwrote: This does exactly what you need http://www.ozgrid.com/forum/showthread.php?t=144212 Regards, Sam Mathai Chacko On

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

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

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

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: excel-macros@googlegroups.com Reply-To:

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

Dear Vikram, Please find attached Converter. On Sun, Feb 12, 2012 at 8:00 PM, Vic Kumar vikramahuj...@gmail.com 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.