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

2012-09-27 Thread Vabz
Hi Please refer link http://www.vbaexpress.com/kb/getarticle.php?kb_id=436: 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 Then

Re: $$Excel-Macros$$ Presentation Vba Code

2012-09-27 Thread Manoj Kumar
anybody please help me. On Thu, Sep 27, 2012 at 11:58 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, i am making Power point presentation i have a macro to do same size of all pitcher. but all pitcher showing in different aria. i want to do all picture in center of

Re: $$Excel-Macros$$ Presentation Vba Code

2012-09-27 Thread David Grugeon
Same question, Same answer I don't know exactly because I do not program powerpoint. This is an Excel Macros group, after all. However it would be something like Picture.left = (slide.width - picture.width)/2 picture.top = (slide.height - picture.height)/2 It may need ActiveWindow.width

$$Excel-Macros$$ Basic Macro

2012-09-27 Thread Manjunath Narayanappa
Dear Experts, I keen to learn basic Macro, please send me training guide or manual Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit

Re: $$Excel-Macros$$ Basic Macro

2012-09-27 Thread ashish koul
buy book excel power programming by *John Walkenbach's* * * On Thu, Sep 27, 2012 at 8:57 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Experts, I keen to learn basic Macro, please send me training guide or manual Thanks Manjunath

$$Excel-Macros$$ Basic Macro

2012-09-27 Thread Manjunath Narayanappa
Dear Experts, I'm keen to learn basic Macro, please send me training guide or manual Thanks Manjunath PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon's standard conditions associated with this e-mail please visit

$$Excel-Macros$$ Re: Basic Macro

2012-09-27 Thread Vabz
Hi, You can learn online from may websites: *http://home.pacbell.net/beban* *http://excel.tips.net* *http://www.andrewsexceltips.net/* *http://www.andypope.info/* *http://akoul.blogspot.com* *http://www.ashishmathur.com* *http://www.discussexcel.com* *http://members.aol.com/Machero*

Re: $$Excel-Macros$$ VSTO *

2012-09-27 Thread joseph . camill
Thanks Noorain Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 27 Sep 2012 12:21:17 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re:

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

2012-09-27 Thread Rajan_Verma
I am working on this . will get back to you shortly 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: 27 September 2012 1:58 To: excel-macros@googlegroups.com

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

2012-09-27 Thread Haseeb A
Hello Matty, FYI; The above formula required Product entered in Sheet2, must be grouped in Sheet1. Otherwise wouldn't give accurate answers. Here is a Non-Volatile Non-Array formula, In B6, =SUMPRODUCT((TEXT(Sheet1!$A$3:$A$122,mmm;;)=TEXT($A61,mmm;;))*(LEFT(

$$Excel-Macros$$ Modify code below to also insert the file creation date

2012-09-27 Thread Best Of Luck
Hello Group: *I am using the code below to read a directory and create hyperlinks from the files but now I need to insert the file creation date also .How can modify this code to do this.* *Here is the code*: *Private Sub FolderRead(ByRef myFolder) Dim countf As String countf = 0 For Each

$$Excel-Macros$$ Re: Introduce Yourself !!

2012-09-27 Thread reshma shri
Hi I am Reshma, new to this group. i was looking to find a macro or a tool to list wav file name and duration in a excel, thats when i found about this group and instantly joined. I would like to know if that's possible at all. if u have a tool for that, kindly lemme know. that would be of

$$Excel-Macros$$ Re: Modify code below to also insert the file creation date

2012-09-27 Thread Prince Dubey
Hi Friend, I hope this will help you. Private Sub FolderRead(ByRef myFolder) Dim countf As String countf = 0 For Each f In myFolder.Files Var = f.Path If Right(f.Name, 4) = .pdf Or Right(f.Name, 4) = .tif Then i = i + 1 ActiveSheet.Hyperlinks.Add Anchor:=Range(A i),

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

2012-09-27 Thread Vabz
Hi Bhasker Reshma PFA excel file with macro.. This macro extracts wav file properties, you can keep the data you want discard unwanted.. Cheers.. Rgds//Vabs On Thursday, September 27, 2012 10:47:25 AM UTC+5:30, reshma shri wrote: Hi Bhasker I too am a medical transcriptionist and