Re: $$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

2014-06-12 Thread Vaibhav Joshi
Hi How do you want to trigger email creation?? From where to pick email id? On Mon, Jun 9, 2014 at 9:41 PM, khagesh khera wrote: > Dear Team, > > Thanks for helping me but we are not getting any great help from the > above. Please find enclosed the email copy which we need to send to as > m

Re: $$Excel-Macros$$ Need quick help with excel - election results

2014-06-12 Thread Djordje Padejski
thanks, I really appreciate -- Best, Djordje Padejski investigative journalist & entrepreneur cell: + 1 650 888 3846 email: dpadej...@cironline.org, padej...@stanford.edu skype: djordje.padejski www.padejski.net FOIAMachine.org founder - hosted by Center for Investigative Reporting, Berkeley www

Re: $$Excel-Macros$$ Need quick help with excel - election results

2014-06-12 Thread Victor Momoh
Attached is the workbook with formulas that can help you achieve this On Fri, Jun 13, 2014 at 1:06 AM, Djordje Padejski < djordje.padej...@gmail.com> wrote: > hello everyone, > > This should be easy, but I'm stuck with Excel. > > Have election results in 4 columns. A Candidate name, B Location

$$Excel-Macros$$ Need quick help with excel - election results

2014-06-12 Thread Djordje Padejski
hello everyone, This should be easy, but I'm stuck with Excel. Have election results in 4 columns. A Candidate name, B Location, C #votes and D %. I need a function/formula that will return name of the winning candidate per each location, with number of votes and percentage. Simple table is at

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Sukanta Datta
The .csv file is created by an Internet application which I call from macro. It is working correctly and generating the file as I wanted. I post the part of the code which is not working when I run it on regular mode but it works when it is in break mode and I execute it line by line. This code

Re: $$Excel-Macros$$ Macro Data entry by row and column search

2014-06-12 Thread Michael Kohl
Paul, Thank you so much for this. This is exactly along the lines I am looking for. I love the error protection you built into the sheet. I know little about excel Macros however i do have some coding experience and can pick up on what you are doing. I will mess around with it some more tonig

$$Excel-Macros$$ Urgent required Oracle Identity Manager Developer / Lead - Chicago, IL

2014-06-12 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com Position: OIM Developer / Lead Location: Chicago, IL Job Type: Long Term* Joining: Immediate (Experience: 5 + years) Please check the following while sharing a profile: 1.We are looking for specifically Oracle Identity Manager expertise (OIM11g and

$$Excel-Macros$$ Urgent required OIM Developer / Lead - Chicago, IL

2014-06-12 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com Position: OIM Developer / Lead Location: Chicago, ILJob Type: Long Term* Joining: Immediate (Experience: 5 + years) Please check the following while sharing a profile: 1.We are looking for specifically Oracle Identity Manager expertise (OIM11g and O

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Paul Schreiner
File Generation stops until the timer is over...   Is this application generating the file? or is it being created from another  process?    The code is a little cumbersome (to me).   Here's what I observe:   -This code is contained in a workbook (name not specified)   -Windows.Application.Workbook

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Sukanta Datta
I did not mean to say Application.Wait does not work. It works but it does not work for my code at that point because I have noticed that file generation stops until the timer is over. The problem I am having that when I run without the break mode the line where I assign wb4 never set and it go

$$Excel-Macros$$ Urgent required Java Front End/UI Developer - Santa Clara, CA

2014-06-12 Thread Gary .
Please respond to gurjant.si...@damcosoft.com *Position: Java Front End/UI Developer/ LeadLocation: Santa Clara, CADuration: 6-12 Months, Long term* Primary Skills: Front End / JavaScript / HTML / CSS / AngularJS Description: Lead front end Developer to deliver high level and cutting edge web

Re: $$Excel-Macros$$ Re: How to pause the Excel VBA macro at certain point and then start again

2014-06-12 Thread Paul Schreiner
Did you TRY what I described? or even Ravinder's suggestion of Browser.busy or Browser.ReadyState?   There are two things: You SAID that Application.Wait does not work. When used properly, Application.Wait DOES work, it just might not help in your case.   The second thing is the infinite loop. Th

Re: $$Excel-Macros$$ help: someone help me crack the password for these 2 macro files?

2014-06-12 Thread Paul Schreiner
You really shouldn't expect much help from this group in this case, since it violates Forum Rule #3:   There are LOTS of places on Google that you can find people who willingly allow someone to steal someone else's work.   (5,340,000 hits on "Break Excel password")    I know, you aren't trying to

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2014-06-12 Thread Abhishek Jain
Its a name range. See the range under "Name Manager" in the "Formulas" tab (Excel 2007). HTH/Abhishek On Thu, Jun 12, 2014 at 6:29 PM, Waqar Ahmed wrote: > Hello everybody, > > I have a problem that I can't increase the list range , I can't find value > (Range name "List") Please help. > > Reg

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2014-06-12 Thread Waqar Ahmed
Hello everybody, I have a problem that I can't increase the list range , I can't find value (Range name "List") Please help. Regards On Thursday, April 25, 2013 12:54:17 PM UTC+5:30, Abhi wrote: > Please see the attached. > > First sheet (List) has the list of items wherein the VBA would searc

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
its already set on both side printing by default but when i am taking print through that its coming on one side printing On Thu, Jun 12, 2014 at 5:24 PM, Vaibhav Joshi wrote: > You need to set duplex printing option as default before printing.. > > > On Thu, Jun 12, 2014 at 5:10 PM, Rohan Young

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Vaibhav Joshi
You need to set duplex printing option as default before printing.. On Thu, Jun 12, 2014 at 5:10 PM, Rohan Young wrote: > one more thing if you can add on this that is both side printing coz our > organization preferred that or excel could take own-self the setting of > both side printing as de

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
one more thing if you can add on this that is both side printing coz our organization preferred that or excel could take own-self the setting of both side printing as default thanks On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young wrote: > please also solve my query of folders of mails logbook > >

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Vaibhav Joshi
Hi simply delete that line.. On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young wrote: > please also solve my query of folders of mails logbook > > regds > > > On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young wrote: > >> thanks a lot bro >> >> >> >> >> On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi wro

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
please also solve my query of folders of mails logbook regds On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young wrote: > thanks a lot bro > > > > > On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi wrote: > >> PFA >> >> Cheers!! >> .*show(Time)* >> >> >> On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young >

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
thanks a lot bro On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi wrote: > PFA > > Cheers!! > .*show(Time)* > > > On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young wrote: > >> no bro, >> >> i want Repeat Top row should come in print on every individual sheet's >> first 6 pages. from page 7 i dont n

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Vaibhav Joshi
PFA Cheers!! .*show(Time)* On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young wrote: > no bro, > > i want Repeat Top row should come in print on every individual sheet's > first 6 pages. from page 7 i dont need Repeat Top Row in prints it should > come in print without Repeat Top Rows in remaining p

Re: $$Excel-Macros$$ Date Format Query

2014-06-12 Thread Pramod Singh
Hi Pravin Gunjal, PFA Hope This will fine for you.. Warm Regards Pramod VBA Developer On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal wrote: > Hi, > > I wanted to convert the dates in this format *DD.MM.* > > Now it is not in system's date format ( MM/DD/ ) and it is displaye

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
no bro, i want Repeat Top row should come in print on every individual sheet's first 6 pages. from page 7 i dont need Repeat Top Row in prints it should come in print without Repeat Top Rows in remaining pages. Same is for rest of the sheets. Thanks On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Josh

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Vaibhav Joshi
If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on all pages of sheet 1,2,3 etc.. it it correct?? On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young wrote: > hi, > > i am talking about the "Repeat Top Rows" not header or footer > > thanks > > > On Wed, Jun 11, 2014 at 10:42 PM, Va

$$Excel-Macros$$ Date Format Query

2014-06-12 Thread Pravin Gunjal
Hi, I wanted to convert the dates in this format *DD.MM.* Now it is not in system's date format ( MM/DD/ ) and it is displayed as DD/MM/ or as D/M/. Kindly help. Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:I

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-12 Thread Rohan Young
hi, i am talking about the "Repeat Top Rows" not header or footer thanks On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi wrote: > Check this link.: > > > http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html > > Cheers > On Jun 11, 20

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

2014-06-12 Thread Vaibhav Joshi
I m still not clear, can you explain 1st line of Input and how you derived result. On Thu, Jun 12, 2014 at 1:34 AM, Will Sob wrote: > Hi Joshi, > > this is my data > 7 9 18 24 39 40 4 18 26 32 36 40 45 21 10 31 35 40 41 44 46 2 5 9 28 > 29 48 36 10 19 20 33 45 46 25 15 26 29 35 36 41 19