$$Excel-Macros$$ Re: Help for VBA code (Excel Table copy to word)

2012-09-26 Thread Vabz
Hi Please refer link : Rgds//Vabs On Thursday, September 27, 2012 11:09:18 AM UTC+5:30, amar takale wrote: > > Hi All Experts > I need VBA code for Excel table paste in word on one click.If I Select > Table or range for one or more table

Re: $$Excel-Macros$$ VBA Macro

2012-09-26 Thread Swapnil Palande
Hi Shrinivas, Can u provide code. Regards, Swapnil. On Thu, Sep 27, 2012 at 9:14 AM, Shrinivas Shevde wrote: > Dear All > Some days back I was trying to write macro and I could write small macro. > While practising many times I found Error messagr > Like "Run Time Error 402 " > But I cant undr

$$Excel-Macros$$ Help for VBA code (Excel Table copy to word)

2012-09-26 Thread amar takale
Hi All Experts I need VBA code for Excel table paste in word on one click.If I Select Table or range for one or more table Then click Button then automatically Table paste in word with format which format in excel. Regards Amar -- Join official facebook page of this forum @ https://www.facebook

$$Excel-Macros$$ Re: WAV FILES DURATION FINDER

2012-09-26 Thread reshma shri
Hi Bhasker I too am a medical transcriptionist and if its not too much for me to ask can u give the tool u use to find wav file length in XL and explain how to use it. Regards Reshma On Friday, July 9, 2010 6:26:11 PM UTC+5:30, Bhasker wrote: > > Hi >> >> I am a medical transcriptionist

$$Excel-Macros$$ VSTO

2012-09-26 Thread joseph . camill
Hi, Does anyone have any VSTO tutorial. Thanks, Joseph Sent on my BlackBerry® from Vodafone -- 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 thread titles

Re: $$Excel-Macros$$ Hiiiiiiiiiii

2012-09-26 Thread VBA VABZ
hi Really nice.. Rgds On Tue, Sep 25, 2012 at 10:41 AM, Amit Desai (MERU) wrote: > To all my dear friends, > > ** ** > > Nice Excel filewith ABCD on Friendship... > > Please see the attachment and click on flowers. > > Best Regards, > > Amit > > ---

Re: $$Excel-Macros$$ Re: need guidance in learning macros and VBA

2012-09-26 Thread vba
Hi Prince, Itz really great source of info. Thanks for sharing.. Cheerz Rgds//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Prince Dubey Sender: excel-macros@googlegroups.com Date: Sun, 23 Sep 2012 06:13:37 To: Reply-To: excel-macros@googlegroups.com Subject: $

Re: $$Excel-Macros$$ Magicc!! juz for fun..

2012-09-26 Thread VBA VABZ
Hi.. I mean u can do this on any excel file.. Rgds On Sat, Sep 22, 2012 at 2:55 PM, Rajan_Verma wrote: > *File??* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behal

Re: $$Excel-Macros$$ read sap ECC6 table content to excel using VBA

2012-09-26 Thread Paul
Hi Don, Is there an address that contains your solution as it does not display in either of the below URLs: http://x61.ch/ee9a3f (google home page) *http://tinyurl.com/85lubjc* (google search using original post title) Thanks. Paul On Saturday, 31 March 2012 13:55:49 UTC+11, George cui wrote

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-26 Thread Indrajit $nai
*@ Krishna, Sir I'm waiting for your reply. :)* On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai wrote: > *@ Krishna, thanks for the reply, It working now, but some issue;* > * > * > *1. Through this Master file I'm able to create the slave files, but it's > not opening, showing an error "inv

Re: $$Excel-Macros$$ circular x axis in excel graph

2012-09-26 Thread David Grugeon
I think you can make a list of all 360 points and leave those without data blank Regards David Grugeon On 27 September 2012 03:03, Christi Jacob wrote: > Hello Rajan, > the result is close to the requirement although it looks like the radar has > been rotated by some angle. > thanks > > can the

$$Excel-Macros$$ Urgent required MS Access Developer - METRO AREA,DC

2012-09-26 Thread Gurjan Singh
One of our client is looking for a MS Access Developer The description is: Build an Access DB that will collect and report Mortgage Servicing information. Skill level: Senior (7+ yrs) Skills: - Experience Connecting with external Sybase/Oracle databases - EXTENSIVE MS Access Development - Web-

Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
Genius! Thank you so much! On Wednesday, September 26, 2012 12:31:04 PM UTC-4, Rajan_Verma wrote: > *Hi* > > *Use this* > > *See the attached* > > * * > > * > =SUMPRODUCT(N(MONTH(Sheet1!$A$3:$A$122)=MONTH(Sheet2!$A6&1))*OFFSET(INDEX(Sheet1!$B$2:$R$121,,MATCH(1,N((LEFT(Sheet1!$B$2:$Q$2,LEN(S

$$Excel-Macros$$ Re: Urgent required L2 Support Network Engineer - Redmond, WA

2012-09-26 Thread Vabz
Job posting is prohibited, can we ban him.. On Wednesday, September 26, 2012 9:51:29 PM UTC+5:30, Gurjan Singh wrote: > > > -- Forwarded message -- > From: Gurjan Singh > > Date: Wed, Sep 26, 2012 at 9:49 PM > Subject: Urgent required L2 Support Network Engineer - Redmond, WA >

$$Excel-Macros$$ Re: Urgent required IBM Websphere MQ Consultant - NewYork city

2012-09-26 Thread Vabz
Job posting is prohibited, can we ban him.. On Wednesday, September 26, 2012 9:15:46 PM UTC+5:30, Gurjan Singh wrote: > *Position:*IBM Websphere MQ Consultant > *Location: *New York city > *Duration:*Long term > > > *Responsibilities * > > > 1. IBM Websphere MQ Series administration and system

Re: $$Excel-Macros$$ circular x axis in excel graph

2012-09-26 Thread Christi Jacob
Hello Rajan, the result is close to the requirement although it looks like the radar has been rotated by some angle. thanks can the graph be modified for angles which are not evenly spaced (ie in the example the angles are spaced 45deg apart. in actual case the first angle might be 25deg followed

$$Excel-Macros$$ Re: If data validation removed! possible.

2012-09-26 Thread Vabz
Hi, Yes you can do that.. Rgds//Vabs On Wednesday, September 26, 2012 5:27:23 PM UTC+5:30, Mohammed Muneer wrote: > Dear Ashish, > > > > > > Can we run the same formula without validation by manual entry into the > cells, F5-G5-H5. > > > > > > Please help needed again w

RE: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Rajan_Verma
Hi Use this See the attached =SUMPRODUCT(N(MONTH(Sheet1!$A$3:$A$122)=MONTH(Sheet2!$A6&1))*OFFSET(INDEX(Sh eet1!$B$2:$R$121,,MATCH(1,N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4), 0)),1,,,SUM(N((LEFT(Sheet1!$B$2:$Q$2,LEN(Sheet2!B$4))*1)=B$4 Regards Rajan verma +91 7838100659 [

$$Excel-Macros$$ Urgent required L2 Support Network Engineer - Redmond, WA

2012-09-26 Thread Gurjan Singh
-- Forwarded message -- From: Gurjan Singh Date: Wed, Sep 26, 2012 at 9:49 PM Subject: Urgent required L2 Support Network Engineer - Redmond, WA To: g...@hmgamerica.com, Gurjan Singh *Position: *L2 Support Network Engineer * Location: *Redmond, WA, ** *Duration: *6 months, CTH

$$Excel-Macros$$ Urgent required IBM Websphere MQ Consultant - NewYork city

2012-09-26 Thread Gurjan Singh
*Position:*IBM Websphere MQ Consultant *Location: *New York city *Duration:*Long term *Responsibilities * 1. IBM Websphere MQ Series administration and system experience is a must 2. Wide hands-on project experience with MQ Series and Message Broker administration and system on Windows 2003 ser

Re: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
Here it is. I hope this helps. Using Sheet 2 for the source data to display on Sheet 1. I believe I got as far as I could with the function but also believe it will show you what I am trying to do. I tried using the LEFT function but can't figure out a way to make it work. I am trying to s

Re: $$Excel-Macros$$ Re: Calculated Field not Working

2012-09-26 Thread SG
any update plz... plz help me to understand this. On Monday, September 24, 2012 9:06:59 PM UTC+5:30, SG wrote: > hi Vabz, > > Still i'm not able to find the difference.Though i have also used the same > formula in calculated field in my sheet. > Plz let me know...so that i would be able to help

RE: $$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Rajan_Verma
Would be good if you provide a sample file Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Matty Sent: 26 September 2012 8:07 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sumif Based

$$Excel-Macros$$ Sumif Based on First Number of a Date Range Help Needed

2012-09-26 Thread Matty
I need to sum up a range of data based on multiple criteria using only the first number in a date string. For example I have a range of data I have to sum attached to specific dates. I need to sum the total product for the month and I am trying to base that criteria on the first number in the

RE: $$Excel-Macros$$ Hiiiiiiiiiii

2012-09-26 Thread Rajan_Verma
You can visit here http://excelpoweruser.wordpress.com/2011/07/20/embaded-flash-object-in-excel / Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 26 September 2012 11:15

RE: $$Excel-Macros$$ circular x axis in excel graph

2012-09-26 Thread Rajan_Verma
Nice Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of David Grugeon Sent: 26 September 2012 6:04 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in exce

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-26 Thread Vabz
HI Inn short 5 & 10 is row no. in which Sam & Ram is written. Rgds//Vabs On Wednesday, September 26, 2012 1:31:47 PM UTC+5:30, amar takale wrote: > > Hello Vabz > Thanks for Logic based on your criterion formula But Can you explain > it.What is minus Row 5 & Row 10 logic.I cant Understand it.

RE: $$Excel-Macros$$ Macro running time

2012-09-26 Thread Krishnaraddi V. Madolli
Thanks, I got it. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mad

Re: $$Excel-Macros$$ Macro running time

2012-09-26 Thread Vabz
Hi Please refer following link for more details: http://www.mrexcel.com/archive/VBA/20164.html Rgds//Vabs On Wednesday, September 26, 2012 3:40:17 PM UTC+5:30, Krishnaraddi V. Madolli wrote: > > Hi Experts, > > > > Can anyone let me know how populate running time of macro. > > Ex: If I run

Re: $$Excel-Macros$$ Run-Time Error 3170

2012-09-26 Thread Swapnil Palande
try below code: Between cdate('01/08/2012') And cdate('31/08/2012')" regards, swapnil. On Wed, Sep 26, 2012 at 2:03 PM, wirelesscellularguy < wirelesscellular...@gmail.com> wrote: > Hi Swapnil, > > With slight modification of the code, i could now pass the Start Date and > the End Date > >

$$Excel-Macros$$ Macro running time

2012-09-26 Thread Krishnaraddi V. Madolli
Hi Experts, Can anyone let me know how populate running time of macro. Ex: If I run any macro, At the end of macro I should get how much time it took to complete macro. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EP

Re: $$Excel-Macros$$ Run-Time Error 3170

2012-09-26 Thread wirelesscellularguy
Hi Swapnil, With slight modification of the code, i could now pass the Start Date and the End Date Regards, Wireless On Friday, September 14, 2012 1:45:41 PM UTC+5:30, Swapnil Palande wrote: > > Hi, > > I don't know exact reason for above error, because when I try to execute > code it is giv

Re: $$Excel-Macros$$ Run-Time Error 3170

2012-09-26 Thread wirelesscellularguy
Hi Swapnil, Thanks for the corrections. I implemented them. I again need your help to pass the Start Date and End Date from the excel to Access Query(as we did for Enter Date & Enter Cell, before). In the Criteria, I entered "Between [Start Date] And [End Date]" but couldn't figure out what th

Re: $$Excel-Macros$$ Help Need for Vlookup Solution

2012-09-26 Thread amar takale
Hello Vabz Thanks for Logic based on your criterion formula But Can you explain it.What is minus Row 5 & Row 10 logic.I cant Understand it.In my data there are 9 column & 13 Row but it is different for different name as per. I will use it but not work I use it & minus Row 8 in formula But formula