Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-12 Thread Rajan_Verma
Thanks All, On Monday, 12 November 2012 10:24:55 UTC+5:30, ca_k...@yahoo.co.in wrote: Congratulations Rajan On Wed, Nov 7, 2012 at 6:17 PM, Karan Singh kara...@gmail.comjavascript: wrote: Congrats dude!! Karan Singh On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-12 Thread Divaker Pandey
Congrats Rajan. On Mon, Nov 12, 2012 at 2:20 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Thanks All, On Monday, 12 November 2012 10:24:55 UTC+5:30, ca_k...@yahoo.co.in wrote: Congratulations Rajan On Wed, Nov 7, 2012 at 6:17 PM, Karan Singh kara...@gmail.com wrote:

$$Excel-Macros$$ Re: Guide me in modifying the included code to import data into the current active sheet

2012-11-12 Thread Prince
Hi Friend, What i understand is you want to copy data from source workbook to selected target workbook for this purpose i have written this macro just copy and paste the macro and run it and let me know if it is what you required. Public Sub GetDataFromFiles() Dim intCtr As Integer

$$Excel-Macros$$ reset dropdown text using macro in Menu Bar

2012-11-12 Thread Divaker Pandey
Hi All, I have made a custom menu in my application name 'evaDimensions' using xml, it have several other options ribbon tab, (See snapshot) I have used a dropdown PRVit Score: I need to reset dropdown text using macro, plz guide me to how i can access this control using macro. Thanks in

Re: $$Excel-Macros$$ VBA CODE REQUIRED

2012-11-12 Thread Prince
Hi Prashant I Hope This will help you. Public Sub Test() Dim wks As Worksheet Dim intCol As Integer Dim intRow As Integer Dim intRAs Integer intR = 1 For Each wks In ThisWorkbook.Worksheets If wks.Name output Then For intCol = 1 To

$$Excel-Macros$$ Re: VBA : Class does not support automation error.

2012-11-12 Thread Prince
Hi Amol, Can you please share ur workbook. Regards Prince On Friday, November 9, 2012 12:08:39 PM UTC+5:30, Amol J wrote: Hello Experts, I need your expert advice. I created a tool using VBA form and OWC 10.0. I am exporting chart which is on chartspace component(OWC 10.0). On

Re: $$Excel-Macros$$ VBA CODE REQUIRED

2012-11-12 Thread Paul Schreiner
First of all.. You should consider Forum Rule #1) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. I suppose since the group title is: MS EXCEL AND

Re: $$Excel-Macros$$ Code Problem

2012-11-12 Thread Paul Schreiner
You really should use a better subject. just about everyone who posts here has a code problem You have not provided any indication either in the subject, or the body of your post as to what your problem is, or even the area of the problem. Some people here are EXPERTS in the use of pivot tables.

$$Excel-Macros$$ Modify VBA Code to Send Email Directly without Displaying

2012-11-12 Thread Hilary Lomotey
Hello Expects I need assistance to modify the code below to send email straight away without the mail poping out before its sent. The reason is if i have 100+ mails to send, it means i need to click send a 100+ times, and that is not efficient. kindly modify the code to send the email without it

Re: $$Excel-Macros$$ Modify VBA Code to Send Email Directly without Displaying

2012-11-12 Thread vba
Hie For this you need to disable security level.. http://office.microsoft.com/en-in/outlook-help/i-get-warnings-about-a-program-accessing-e-mail-address-information-or-sending-e-mail-on-my-behalf-HA001229943.aspx Refer link for details. Thanks//Vabs Sent on my BlackBerry® from Vodafone

Re: $$Excel-Macros$$ Modify VBA Code to Send Email Directly without Displaying

2012-11-12 Thread Hilary Lomotey
Thanks Boss But its not what i want, let me explain better. if you open the attached file i sent together with the email earlier, when you activate the send button, outlook will open for the email to get ready to send, when the mail with attachments pops up, you would have to clicj send and the

Re: $$Excel-Macros$$ Modify VBA Code to Send Email Directly without Displaying

2012-11-12 Thread Paul Schreiner
I cannot test it at this minute, but can you use: Application.DisplayAlerts = false It may be that you have to issue this just prior to issuing the send.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the

Re: $$Excel-Macros$$ Modify VBA Code to Send Email Directly without Displaying *

2012-11-12 Thread Hilary Lomotey
thanks Paul, Please try when you are free , standing by, thanks On Mon, Nov 12, 2012 at 6:05 PM, Paul Schreiner schreiner_p...@att.netwrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup

Re: $$Excel-Macros$$ Modify VBA Code to Send Email Directly without Displaying

2012-11-12 Thread vba
Hie, If you wanna send email directly then correct dis line: .Display  'Or use Send It should be .send You have to use .display when you wanna see email before display. And you can use this with my prior tip. Pl revert if you need further help. Cheerz... Sent on my BlackBerry® from

$$Excel-Macros$$ hi!

2012-11-12 Thread Subu S
check this out http://msnbc.msn.com-report4.us/jobs/ -- 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, like Please Help, Urgent, Need Help,

Re: $$Excel-Macros$$ Modify VBA Code to Send Email Directly without Displaying *

2012-11-12 Thread Hilary Lomotey
nice thanks boss On Mon, Nov 12, 2012 at 6:48 PM, v...@vabs.in wrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (v...@vabs.in) Add cleanup

RE: $$Excel-Macros$$ Code Problem

2012-11-12 Thread SAJID MEMON
Dear My first machine name is Lenovo, 2nd name is Hp, third name id Dell. in all the machines D:\ drives is there, same path. Can i write \\Lenovo\d\12-13\book1.xls or \\Hp\d\12-13\book1.xls or \\dell\d\12-13\book1.xls Programe is installed only in lenovo, i want to excess it from hp or from

Re: $$Excel-Macros$$ Code Problem

2012-11-12 Thread vba
Hi, You can access by this way also but for this to be worked your D drive should be shared. Cheerz.. Sent on my BlackBerry® from Vodafone -Original Message- From: SAJID MEMON sajidwi...@hotmail.com Sender: excel-macros@googlegroups.com Date: Tue, 13 Nov 2012 04:12:48 To: Sundarvelan

Re: $$Excel-Macros$$ Pivot Table - Required percentile values

2012-11-12 Thread Sheyn Lee
Dear Anoop, I need the values from a pivot table use the formula '=PERCENTILE(C2:C6,0.5)' Best Regrds, S. On Mon, Nov 12, 2012 at 12:56 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Sheyn, Please elaborate your query. Regards, Anoop On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee

RE: $$Excel-Macros$$ VBA macro quiz #1

2012-11-12 Thread Asa Rossoff
I like the questions. Very good introductory questions on a variety of VBA topics. For question #8, I suspect the question intended could be better phrased Which of these is a datatype most specifically for storing decimal integers in a variable? (several of the datatypes listed store decimal