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

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 decima

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

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 wrote: > Sheyn, Please elaborate your query. > > Regards, > Anoop > > > On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee wrote: > >> Dear MS Excel

Re: $$Excel-Macros$$ Code Problem

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 Sender: excel-macros@googlegroups.com Date: Tue, 13 Nov 2012 04:12:48 To: Sundarvelan Natarajan Reply-To: ex

RE: $$Excel-Macros$$ Code Problem

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 d

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

nice thanks boss On Mon, Nov 12, 2012 at 6:48 PM, wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (v...@vabs.in) Add cleanup > rule

$$Excel-Macros$$ hi!

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, F

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

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 Vodafone

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

thanks Paul, Please try when you are free , standing by, thanks On Mon, Nov 12, 2012 at 6:05 PM, Paul Schreiner wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup > rule

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

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 plac

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

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 em

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

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

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

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$$ Code Problem

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.

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

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

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

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

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

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 T

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

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 adavance.

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

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

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

Congrats Rajan. On Mon, Nov 12, 2012 at 2:20 PM, Rajan_Verma wrote: > 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 wrote: >> >>> Congrats dude!! >>> >>> >>>

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

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 > > wrote: > >> Congrats dude!! >> >> >> >> Karan Singh >> >> >> >> >> On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan >> >> > wr