$$Excel-Macros$$ RE: Creating Custom Ribbon

2012-09-11 Thread manan....@gmail.com
-Original message- From: Prince Dubey Sent: 11/09/2012, 23:00 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Creating Custom Ribbon Hi Vinay. Pls follow below mentioned steps. 1: download customUI editor And install it in ur system. 2: open ur workbook in ur UI edito

Re: $$Excel-Macros$$ Please give suggestion to make flip chart

2012-09-11 Thread PRAVESH KUMAR
Thanks a lot Rajan For help and solved my Query. On 9/11/12, Rajan_Verma wrote: > See the attached > > > Public blnFlag As Boolean > Sub FlipChart() > > Dim ChtChart As Chart > Set ChtChart = Sheet1.ChartObjects("Chart 2").Chart > If blnFlag Then > ChtChart.ChartType = xlBa

Re: $$Excel-Macros$$ Creating Custom Ribbon

2012-09-11 Thread Sam Mathai Chacko
The threads in this link talk a lot about Ribbon development in very simple steps http://www.excelfox.com/forum/f10/ Regards, Sam Mathai Chacko On Tue, Sep 11, 2012 at 10:50 PM, wrote: > ** > Visit > > www.rondebruin.nl/ribbon.htm > > Sent on my BlackBerry® from Vodafone >

Re: $$Excel-Macros$$ FW: macro for pivot

2012-09-11 Thread Mangesh Vimay
Thanks Rajan. On Tue, Sep 11, 2012 at 8:46 PM, Rajan_Verma wrote: > *Is it?* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay > *Sent:* 11 Septem

$$Excel-Macros$$ Re: Creating Custom Ribbon

2012-09-11 Thread Prince Dubey
Hi Vinay. Pls follow below mentioned steps. 1: download customUI editor And install it in ur system. 2: open ur workbook in ur UI editor. 3:Put XML from following Link( http://msdn.microsoft.com/en-us/library/office/dd756403(v=office.12).aspx) Code into ur Editor. 4:Click on Validate XML thats

Re: $$Excel-Macros$$ Creating Custom Ribbon

2012-09-11 Thread koul . ashish
Visit www.rondebruin.nl/ribbon.htm Sent on my BlackBerry® from Vodafone -Original Message- From: t vinay Sender: excel-macros@googlegroups.com Date: Tue, 11 Sep 2012 22:48:24 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Creating Custom Ribbon hi Team,m Can

$$Excel-Macros$$ Creating Custom Ribbon

2012-09-11 Thread t vinay
hi Team,m Can any one help me in creating a customized tab in excel ribbon, when i share that excel file to others they, those button should be able to see them. Thanks -- Regards, Vinay. T -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1

RE: $$Excel-Macros$$ Please give suggestion to make flip chart

2012-09-11 Thread Rajan_Verma
See the attached Public blnFlag As Boolean Sub FlipChart() Dim ChtChart As Chart Set ChtChart = Sheet1.ChartObjects("Chart 2").Chart If blnFlag Then ChtChart.ChartType = xlBarClustered blnFlag = False Else ChtChart.ChartType = xlColumnClustered bl

$$Excel-Macros$$ Re: Stock management software in excel

2012-09-11 Thread Prince Dubey
Hi Sagar, I think stock management criteria for several firms or companies could be different so pleas explain requirements (functionality as u require) to be in ur macro. regards prince On Tuesday, September 11, 2012 11:04:42 AM UTC+5:30, ca_k...@yahoo.co.in wrote: > > Dear all, > > Any

$$Excel-Macros$$ Re: Please give suggestion to make flip chart

2012-09-11 Thread Prince Dubey
Hi Pravesh, Can you plz express ur idea about flipiing the chart in more general trems, I mean what do mean by flipping the chart. regards prince On Tuesday, September 11, 2012 9:30:32 PM UTC+5:30, PRAVESH KUMAR wrote: > > Hi Team, > > Could you help me to make Flip Chart through VBA Coding.

Re: $$Excel-Macros$$ Please give suggestion to make flip chart

2012-09-11 Thread Paul Schreiner
?? "I think what we have here is a failure to communicate" In Excel, to "flip" a chart means to reverse the Axes. You don't "make" a flip chart. Therefore, I have to assume that you're using an old-school term for the type of chart projected for demonstration or teaching purposes. Which is what

RE: $$Excel-Macros$$ Please give suggestion to make flip chart

2012-09-11 Thread Rajan_Verma
How this FLIP Chat looks like ? Can you provide an example ? Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of PRAVESH KUMAR Sent: 11 September 2012 9:30 To: excel-macros Subject: $$E

$$Excel-Macros$$ Please give suggestion to make flip chart

2012-09-11 Thread PRAVESH KUMAR
Hi Team, Could you help me to make Flip Chart through VBA Coding. -- Thanks & Regards Pravesh Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor th

Re: $$Excel-Macros$$ FW: macro for pivot

2012-09-11 Thread Mangesh Vimay
Hi Rajan, I need that file for pivot code. Can you provide same again as I am unable to see as an attachment. Thanks. On Tue, Sep 11, 2012 at 8:41 PM, Rajan_Verma wrote: > *Paste that Code in Respective Sheet Code Module * > > *e.g If your pivot sheet is Sheet3 then Double Click on Sheet3 in VB

RE: $$Excel-Macros$$ FW: macro for pivot

2012-09-11 Thread Rajan_Verma
Paste that Code in Respective Sheet Code Module e.g If your pivot sheet is Sheet3 then Double Click on Sheet3 in VBE And paste that code Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Vimay

Re: $$Excel-Macros$$ FW: macro for pivot

2012-09-11 Thread Mangesh Vimay
Where is the file ? On Sun, Sep 9, 2012 at 7:49 PM, Sara Lee wrote: > > > --- > ** > > *From:* Sara Lee [mailto:lee.sar...@gmail.com] > *Sent:* 09 September 2012 7:41 > *To:* Rajan_Verma > *Subject:* Re: macro for pivot > > ** ** > > once i copy and paste into a new module, how to run this

Re: $$Excel-Macros$$ Stock management software in excel

2012-09-11 Thread SAGAR KASANGOTTUWAR
Dear Rajan, I want to make the excel base software for the managing Share stock. where following purpose will be solve; 1. Entry of goods purchase 2. Maintain the avarage price with no of Stock 3. Sell the goods then that much stock will reduce from my account. Kindly help me about the same. T

RE: $$Excel-Macros$$ Re: Unique from Multiple sheet

2012-09-11 Thread Rajan_Verma
Thanks J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 11 September 2012 8:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Unique from Multiple sheet Look

Re: $$Excel-Macros$$ Re: Unique from Multiple sheet

2012-09-11 Thread dguillett1
Looks like the best solution which also should sort Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Rajan_Verma Sent: Tuesday, September 11, 2012 9:14 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: Unique from Multiple sheet Su

Re: $$Excel-Macros$$ Re: Unique from Multiple sheet

2012-09-11 Thread dguillett1
Good thinking. My solution was simple and also took only 3-4 seconds AND it changed to numbers. Try it. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Tuesday, September 11, 2012 9:04 AM To: excel-macros@googlegroups.com Subject: Re: $$

RE: $$Excel-Macros$$ Re: Unique from Multiple sheet

2012-09-11 Thread Rajan_Verma
Sub GetUnique() Dim wksSheet As Worksheet Dim VarArr Dim lngCOunt As Long With CreateObject("Scripting.Dictionary") For Each wksSheet In ThisWorkbook.Worksheets VarArr = wksSheet.Range("A1").CurrentRegion For Each kk In VarArr .Item(kk)

Re: $$Excel-Macros$$ Re: Unique from Multiple sheet

2012-09-11 Thread Paul Schreiner
Don, "technically"... N.Sundarvelan (the originator) included a file in .xlsx format. Which implies he has either xl2007 or xl2010... But.. yes, this solution seems to have LOTS of selections. and other "jumping around" that is a lot of "wasted motion". any time the display is updated, the run ti

Re: Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-11 Thread David Grugeon
Loveufe2001 I suggest you post your question in its own thread and try to give a bit more of an explanation of what you are doing Also use a suitable heading. On 11 September 2012 18:20, loveufe2001 wrote: > > Dear friends: > My question is :when I closed Thisworkbook I Need the project's

Re: $$Excel-Macros$$ Fwd: PDF to excel table

2012-09-11 Thread David Grugeon
This is not a function of Excel AFAIK but if you Google PDF to EXCEL you will see that there are a number of options. Some of these involve software, which you are not allowed. However your company may have Adobe Acrobat X which can do this. Other sites offer, often free of charge, a service whe

RE: Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-11 Thread Rajan_Verma
Not getting anything Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of loveufe2001 Sent: 11 September 2012 1:51 To: excel-macros Subject: Re: Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful M

Re: $$Excel-Macros$$ Fwd: PDF to excel table

2012-09-11 Thread dguillett1
I suggest NOT receiving in PDF format Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SAGAR KASANGOTTUWAR Sent: Tuesday, September 11, 2012 12:38 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fwd: PDF to excel table Dear Chethan, You ca

RE: $$Excel-Macros$$ Fwd: PDF to excel table

2012-09-11 Thread Rajan_Verma
I don't think if it can be done by Excel Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B.N.Chethan Kumar Sent: 11 September 2012 12:40 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macro

RE: $$Excel-Macros$$ Teach Formula Series

2012-09-11 Thread Rajan_Verma
Nice, I will take this initiative :) Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vinod Narayanan Sent: 11 September 2012 11:39 To: Excel Group Subject: $$Excel-Macros$$ Teach Form

RE: $$Excel-Macros$$ Stock management software in excel

2012-09-11 Thread Rajan_Verma
Pleaes Explain more Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SAGAR KASANGOTTUWAR Sent: 11 September 2012 11:05 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Stock management softw

RE: $$Excel-Macros$$ Need VBA code for Formatting chart

2012-09-11 Thread Rajan_Verma
Hi Amar, I think it can be useful, if you provide the dataseries name in mapping ,it can be really helpful to color all series Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 11

Re: $$Excel-Macros$$ Re: Unique from Multiple sheet

2012-09-11 Thread dguillett1
Since op did not indicate version your solution would not work prior to xl2007 and you have unnecessary and undesirable SELECTIONS. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Vabz Sent: Tuesday, September 11, 2012 2:14 AM To: excel-macros@googlegroups.c

Re: $$Excel-Macros$$ Unique from Multiple sheet

2012-09-11 Thread Paul Schreiner
You can try: Option Explicit Sub Unique_ID()     Dim Dict_Userid     Dim sht, SummarySht     Dim R, nRows, uArray         SummarySht = "Sheet5"     Set Dict_Userid = CreateObject("Scripting.Dictionary")     Dict_Userid.RemoveAll     '-  

Re: $$Excel-Macros$$ Teach Formula Series

2012-09-11 Thread Paul Schreiner
tried Google?   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 ---

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-11 Thread dguillett1
Homework done... Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Tuesday, September 11, 2012 4:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Its really Great Help A

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

2012-09-11 Thread Mangesh Vimay
Its really Great Help Asa !!! Thanks a ton !!! On Tue, Sep 11, 2012 at 7:07 AM, Asa Rossoff wrote: > Hi Mangesh, > > I've read your other replies, and as to why you haven't received a formula > method -- most people don't want to take the trouble on a volunteer basis > to provide a more comp

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-11 Thread KAUSHIK SAVLA
Congratulations Noorain. Regards, Kaushik Savla On Sep 2, 2012 10:44 AM, wrote: > ** > Congrats Noorain.. > > Rgds > Vaibhav > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 2 Sep 2012 10:32:31 +0530 > *To: *excel-macros > *ReplyTo

Re: $$Excel-Macros$$ Fwd: PDF to excel table

2012-09-11 Thread B.N.Chethan Kumar
Due to restrict i will not able to use third party soft ware in my work place. Regards CK On Sep 11, 2012 11:08 AM, "SAGAR KASANGOTTUWAR" < sagarkasangottu...@gmail.com> wrote: > Dear Chethan, > > You can use the Able to extract software > > Best Regards, > > Sagar > On Tue, Sep 11, 2012 at

Re: $$Excel-Macros$$ detecting loggedin user

2012-09-11 Thread Midhun Thampan
Hi All; Thanks a lot. Paul Thanks for ur help to guide me through properly. I can now go forward with this one.. Thanks Again; regards Midhun On Tue, Sep 11, 2012 at 7:29 AM, Asa Rossoff wrote: > Hi Midhun, > > > > I like Paul's thorough response. > > > > I thought I'd mention that there is a s