$$Excel-Macros$$ Date picker

2011-09-17 Thread Awal
In a userform I have a date picker and I would like to know if there is a way to pick only "month and year". -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit

$$Excel-Macros$$ Custom Event Handler for Refedit Control

2011-09-17 Thread daverpi...@aol.com
I am Trying to Write a custom Event Handler for Refedit Controls taht I am Dynamically adding to a user form. I have defined a new Class Module CustomRefeditEventHandler Public WithEvents oRefeditControl As RefEdit.RefEdit Private Sub oRefeditControl_MouseMove(ByVal Button As Integer, ByVal Shi

Re: $$Excel-Macros$$ Re: Converting date with time to date withOUT time

2011-09-17 Thread lifescholar
Yes, Sam, absolutely right! Sorry, everyone. On Sep 17, 2:10 pm, Sam Mathai Chacko wrote: > Steve, a modification. shouldn't it be =ROUNDDOWN(yourdate,0) > > On Sat, Sep 17, 2011 at 6:35 PM, lifescholar > wrote: > > > > > > > > > > > round(yourdate,0) > > > On Sep 15, 9:09 pm, Mich Mac wrot

Re: $$Excel-Macros$$ Power point Query

2011-09-17 Thread alisha malhotra
Dear Shrini, I am sending you one attachment. Check out if it works. Regards, Alisha On Thu, Sep 15, 2011 at 5:43 PM, Shrinivas Shevde wrote: > Dear All > I know this is not Excel related query but still can any one help me. > I want to prepare the presentation and want to show a revolving > b

Re: $$Excel-Macros$$ Excel chart challenge

2011-09-17 Thread Ayush Jain
Thanks Ashish , It does work well. However I used the rank function to sort the data in different range. Sam, All the solutions are most welcome. I am looking at the solutions where we can sort chart without using the additional range. Sometimes the complex sheets with large number of charts dont

Re: $$Excel-Macros$$ Re: Converting date with time to date withOUT time

2011-09-17 Thread Sam Mathai Chacko
Steve, a modification. shouldn't it be =ROUNDDOWN(yourdate,0) On Sat, Sep 17, 2011 at 6:35 PM, lifescholar wrote: > round(yourdate,0) > > On Sep 15, 9:09 pm, Mich Mac wrote: > > I am exporting a file from online which automatically includes dates. > > This interferes with my Pivot tables. H

$$Excel-Macros$$ Re: Converting date with time to date withOUT time

2011-09-17 Thread lifescholar
round(yourdate,0) On Sep 15, 9:09 pm, Mich Mac wrote: > I am exporting a file from online which automatically includes dates. > This interferes with my Pivot tables.  How do I convert an entire > column of dates with the time to dates without the time. -- ---

$$Excel-Macros$$ Re: Macro - Open PowerPoint and Update Links?

2011-09-17 Thread lifescholar
Why not put an AutoOpen macro in the PP file that updates the links to Excel automatically? On Sep 14, 9:29 pm, Robert Jacobs wrote: > Thanks in advance, experts!! > > I have a PowerPoint presentation that has links to Excel charts that > need to be updated each time the Excel file is changed

$$Excel-Macros$$ Re: connecting code to the report

2011-09-17 Thread lifescholar
Have you created a reference to the Crystal Report object library (Tools | References... in VBA)? On Sep 14, 3:47 pm, Shankar Bheema wrote: > I used the following code to connect the report sheet > > Dim rep As New CrystalReport > rep.ReportFileName = "f:\test" > > CRViewer1.ReportSource = rep >

$$Excel-Macros$$ Re: Excel VBA/ Access

2011-09-17 Thread lifescholar
The Access DB definitely does not need to be open. In fact, it should be possible to run your update query even if Access is not installed on the target system, as the relevant Jet engine is distributed with all versions of Office including Standard. What happens if you try to run the SQL of the q

Re: $$Excel-Macros$$ Excel chart challenge

2011-09-17 Thread Sam Mathai Chacko
Ashish, nice improvisation. Ayush, has that solution from solved your question? or are you looking for any other solution Sam On Sat, Sep 17, 2011 at 5:47 PM, ashish koul wrote: > check the attachement > > > On Sat, Sep 17, 2011 at 5:33 PM, Ayush Jain wrote: > >> Dear group, >> >> Recently in

Re: $$Excel-Macros$$ Excel chart challenge

2011-09-17 Thread ashish koul
check the attachement On Sat, Sep 17, 2011 at 5:33 PM, Ayush Jain wrote: > Dear group, > > Recently in one of the project, I encountered an issue where we need to > sort the 2-D Bar chart from high to low without sorting the data table > The data table could not be sorted because it is linked wi

$$Excel-Macros$$ Excel chart challenge

2011-09-17 Thread Ayush Jain
Dear group, Recently in one of the project, I encountered an issue where we need to sort the 2-D Bar chart from high to low without sorting the data table The data table could not be sorted because it is linked with some dynamic formulas. Enclosed is the sample data and chart for you, where I jum

Re: $$Excel-Macros$$ pls help

2011-09-17 Thread rajan verma
hi Pls clearify your issue in your query or you can google it. On 17/09/2011, Shankar Bheema wrote: > Pls do reply experts.. > > On Fri, Sep 16, 2011 at 10:16 PM, Shankar Bheema > wrote: > >> where do i get help for Crystal reports 9 problems ? >> >> -- >> >> -

Re: $$Excel-Macros$$ pls help

2011-09-17 Thread Shankar Bheema
Pls do reply experts.. On Fri, Sep 16, 2011 at 10:16 PM, Shankar Bheema wrote: > where do i get help for Crystal reports 9 problems ? > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for