Re: $$Excel-Macros$$ Filter but exlude bad results script help!

Here you go.. On Fri, Jul 11, 2014 at 10:04 PM, Matt Painter wrote: > I pull data from a site called NDRIN.com its nd's land data base that i > work off. Now i have a script that filters the results when i > searchwhich is great.. but these admins dont enter the stuff right.. > alot.. > > S

Re: $$Excel-Macros$$ Auto send Workbook through Windows Live Mail

Instead of using this try simple thing first, configure your window live with outlook then you can send it easily. On Tue, Jun 24, 2014 at 12:19 PM, Deepak Agrawal wrote: > Dear Experts, > > I want to auto send my workbook and worksheet by using windows > live mail, I have found to

Re: $$Excel-Macros$$ Re: Over 33,554 rows problem

Well, Use of variant is not required here. As Paul already suggested, use Long instead of integer. If you use variant, the working will go slow and will acquire more space. Replace *Dim i As Integer, j As Integer, k As Integer, s As String *with below one at very begining *Dim i As Long, j As Long,

Re: $$Excel-Macros$$ Over 33,554 rows problem

can you share your file? On Sat, May 31, 2014 at 2:57 AM, Bill Q wrote: > Hi, > > I am using Excel 2010. I have a macro web query that downloads various > information. It works fine. No issue there. The only issue that I have is > that it will stop if it encounters more than 33 or 34 thousand r

Re: $$Excel-Macros$$ Error occured during opening the file

Save as the file and create links again.. Make you you haven't change the MS Platform version to lower. On Fri, Apr 4, 2014 at 11:43 AM, Ashish Bhalara wrote: > > Dear expert, > > There are Error occur during opening the file of "Excel found unreadable > content in ''. Do you want to recover the

Re: $$Excel-Macros$$ extracting zip codes from addresses

Hi Joseph, Please have a look at attached one.. The formula'll work for 5 digit Zip code only. On Fri, Mar 28, 2014 at 3:17 PM, joseph liech wrote: > thanks for your attention. > please help me. > > > On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey wrote: > >> can you provide please sample fil

Re: $$Excel-Macros$$ Save only a few sheets

Share your Excel file On Fri, Mar 28, 2014 at 12:04 PM, Stefano Tagliaferri wrote: > > > Hello! Sorry for my English (Google translator)! > I would like to write an Excel macro that can save to a different folder > of the active, two or three sheets belonging to the folder where I'm > working. >

Re: $$Excel-Macros$$ Link Custom Toolbar with a file

Can you share the module or AddIn? On Fri, Mar 7, 2014 at 1:39 PM, wrote: > Thanks Clive but iy didn't help. > What I guess I'm looking for is an event that is triggered when a > programme is brought back to the full page state from the diminished state > on the Task Bar. > donwb > > > On Tuesd

Re: $$Excel-Macros$$ Attach potentially multiple embedded OLEObjects from excel into an outlook message

Please share you Excel file On Tue, Mar 4, 2014 at 3:54 AM, Chip Hansel wrote: > I am working on sending an email based on inputs from one of several > sheets. > > In addition to the specific cells i am using as body, a various sheet may > have an embedded file (word, pdf, another excel spreads

Re: $$Excel-Macros$$ recordset vs collections

or use this one. http://msdn.microsoft.com/en-us/library/office/aa141422%28v=office.10%29.aspx On Thu, Feb 13, 2014 at 6:00 PM, Anoop K Sharma wrote: > There is a recordset property which lock the data while reading it through > query. > > > On Thu, Feb 13, 2014 at 5:41 PM, Kei

Re: $$Excel-Macros$$ recordset vs collections

There is a recordset property which lock the data while reading it through query. On Thu, Feb 13, 2014 at 5:41 PM, Keith Willis wrote: > Hi all > > I'm developing a project thats going to be a excel front end to a SQL db. > One part of the required functionality is that you performa a search on

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

Welcome to the Group!!! On Wed, Feb 5, 2014 at 3:09 PM, Raj Mahapatra wrote: > Hi all, > > I m rajesh mahapatra from mumbai...i have learnt many macro trics from > this group and hoping to see many morethanks > On 4 Feb 2014 11:54, "Nitin Mittal" wrote: > >> Hi All, I am Nitin Mittal, worki

Re: $$Excel-Macros$$ looking for help on skipping highlighted cells with VBA macro

Can you please share your file? On Thu, Jan 30, 2014 at 5:13 AM, Scott Little wrote: > Hello, > I have been working on a VBA macro that is taking data entered from one > sheet and matching to a column on another sheet used as a database. The > matching process works fine, I can get the data ente

Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

hen I opened the file I got run time error '57121' >>> "Application-defined or object-defined error" >>> And when I clicked Debug it took me to the Sub Workbook Open() and >>> highlighted the line Sheets.("List").select >>> Any ideas

Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

Hi Rob, Please have look at attached one... On Thu, Jan 23, 2014 at 6:48 AM, Rob Flott wrote: > > > On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote: >> >> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of >> names. This range will vary, and I have a Na

Re: $$Excel-Macros$$ Class Module for Checkboxes

Use loop... like for each chkBox in thisworkbook.worksheet 'your code next chkbox.. you need to declare chkbox as an object. Please do share your workbook.. On Thu, Jan 16, 2014 at 3:52 AM, wrote: > > Hello All: > > To created a class module for the execution of a macro by any userform > c

Re: $$Excel-Macros$$ Privacy Warning for macro enabled excel

You can follow the following steps to avoid the privacy warning. 1 Menu Button "on the top left of the excel window" 2 Excel Option 3 Trust Center 4 Trust Center setting 5 Privacy Options 6 un-check the "Remove personal information from file properties on save" On Thu, Jan 16, 2014 at 12:50 PM, D

Re: $$Excel-Macros$$ Importing Excel Files

just use below line Application.GetOpenFilename ("All Excel File (*.xls*),*.xls*") On Sun, Dec 29, 2013 at 8:49 PM, Linda C wrote: > Hi Ashish, > > Is it possible to actually show all the excel files (both .xls and .xlsx > version) after clicking Browse button so I can directly click the file

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

Well, No one will get the result by studying this formula. There will definitely be number of methods to meet your requirement but for that we need your master file along with supporting files. Please do share these with elaborating your requirement. On Tue, Dec 24, 2013 at 3:38 PM, Brett Manning

Re: $$Excel-Macros$$ Write a macro 2 get the user input and based on that filter the rows and put into the another sheet

Use below lines.. but you need to change these lines as per your code. Userform1.Hide 'To hide the userform if it is with name "Userform1" myCriteria1 = Userform1.textBox1.value myCriteria2 = Userform1.textBox2.value Sheet1.Range("A1").autofilter 2, Criteria:= "=" & myCriteria1, xlOr, Criteria:=

Re: $$Excel-Macros$$ Re: New to Macros - In search of a solution

You need to share your file to understand your project On Wed, Dec 4, 2013 at 4:27 AM, Matt Watson wrote: > Just a self update. I played with the Macro Recorder and managed to build > a macro (with some tweaking) to filter by the HTML I pasted in, > text-to-column til I got my number, and pasted

Re: $$Excel-Macros$$ Link workbook based on a decision from a lookup

This is basically triggered bases development. Are you using outlook to notify requester of their leave status? What version of Office are you using? On Wed, Nov 27, 2013 at 5:37 PM, Edward Mcallister wrote: > Hi, > > I'm fairly new to Excel as my specialty is JavaScript. I have designed an > A

Re: $$Excel-Macros$$ Re: Sort TCP/IP Address in Excel

great On Mon, Dec 2, 2013 at 6:47 PM, André Roberge wrote: > An easy way to convert IPs to decimal so they can be sorted is to use an > Excel function to do it. See > herefor more > details. > > On Friday, June 24, 2011 5:59:16 AM UT

Re: $$Excel-Macros$$ Create a macro based on a range of cells in excel and send via Lotus Notes with attachment

Hi Kim, can you please share your excel file? On Wed, Nov 20, 2013 at 1:05 AM, Kim McLaughlin wrote: > > > I have a spreadsheet with columns A through AD and have about 1000 rows > on my report. I need to run the report every month and send an email to > anyone that has a greater than or equal

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

Sure On Wed, Nov 13, 2013 at 11:06 AM, Bill Q wrote: > > On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin wrote: > >> My Pleasure.. You have given me new title. >> >> >> On Fri, Dec 14, 2012 at 12:57 AM, Bill Q wrote: >> >>> Just what the doctor ordered. Thank you very m

Re: $$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

Your code is working fine. What error code you are getting there? On Wed, Oct 30, 2013 at 6:32 PM, TAWHID wrote: > Dear Rupesh , > Thanks for your quick reply. > > Please have look the attachemnt. > > If I press the "count" batton, the form appears. I am putting > (copy/paste) item code in t

Re: $$Excel-Macros$$ Pivot Table queries

Sum column / count column with in pivot table, Is it possible? > Thanks & Regards, > Sandeep Kumar Chhajer > Mumbai > India > > Sent on my BlackBerry® from Vodafone > -- > *From: * Anoop K Sharma > *Sender: * excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel Macro to print, slecting range, printer and orientation etc

What Error are you getting? Can you share your file in which you use your recorded macro. On Sun, Oct 27, 2013 at 9:48 AM, ashish koul wrote: > try this way > http://mariaevert.dk/vba/?p=6 > > > > > On Sun, Oct 27, 2013 at 8:26 AM, Howard Rambin wrote: > >> I am new to macros in Excel (wiz at l

Re: $$Excel-Macros$$ Pivot Table queries

Sandeep please insert required formula using pivot table formula. for this go to Options>formula>Calculated Field. Options Ribbon will populate once you select the pivot field and Calculated field will enable when you select any column field in pivot. On Wed, Oct 30, 2013 at 8:07 AM, Sandee

Re: $$Excel-Macros$$ Excel Macrosbased file not working on windows 7 64 bit operating system

What Error you are getting? On Fri, Oct 25, 2013 at 12:42 PM, Jocky Beta wrote: > Hi VBA Experts, > > Please find the above attached file it's not working on windows 7 64 bit > operating system. Request you to kindly suggest or edit the file for the > working on the same. > > > Regards > > -- >

Re: $$Excel-Macros$$ Continuation of VBA for Excel to Word

pls share your file... On Mon, Oct 21, 2013 at 8:51 PM, Justin Pulley wrote: > I don't know how to mark something uncompleted. > > The code works every other time. > > > > Sub CreateReportPDF() > Dim wdapp As Word.Application > Dim wddoc As Word.Document > > Run CopyData > > Set wdapp = Word.Ap

Re: $$Excel-Macros$$ Formula Required

PFA updated with little change as described above. On Tue, Oct 22, 2013 at 4:18 PM, Anoop K Sharma wrote: > As Requested, PFB the solved one. > > Regards, > Anoop > Sr. Developer > > > On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote: >

Re: $$Excel-Macros$$ Formula Required

As Requested, PFB the solved one. Regards, Anoop Sr. Developer On Tue, Oct 22, 2013 at 3:36 PM, xlstime wrote: > please share the example > > . > > Enjoy > Team XLS > > > > On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur < > prabhakarthak...@gmail.com> wrote: > >> D

Re: $$Excel-Macros$$ Helpd needed

Hi Ravi, Please check attached one.. just change weightage or your values against pin code to get answer On Mon, Sep 30, 2013 at 7:10 PM, Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi Ashish, > > In a file we have Pin Code and weight, it will be check in a Rate Mater > where the Ra

Re: $$Excel-Macros$$ Auto run multiple macros with data change

Hi, What code you have written behind "Rate_KaPs_11". If possible please share your file. On Sun, Sep 29, 2013 at 1:28 PM, Warwick Trueman wrote: > > > Hi all, > my first post - I started teaching myself VBA two days ago, with > predictable results! > > I want to run different macros on a sing

Re: $$Excel-Macros$$ Index match help

Hi Jeremy, Please find attached file.. The range here I declared is something different because I think San Diego ($85,394.40) is having amount greater than 80,000 and less than 90,000 so its percentage should be 5.0% not 4.7% (as said by you). Please let me know the limits so that the formula ca

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

Use below one there is no field named as country.. if it doesn't work then let me knw. SELECT TOP 20 MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11

Re: $$Excel-Macros$$ External Query not brining in all data

allowed by SQL. > Rich > On Sep 19, 2013 10:21 PM, "Anoop K Sharma" wrote: > >> Hi Richard, >> >> Your query is not clear enough. Varchar is a reserved word for sql. are >> you using max function for getting maximum value of a column? >> >>

Re: $$Excel-Macros$$ External Query not brining in all data

Hi Richard, Your query is not clear enough. Varchar is a reserved word for sql. are you using max function for getting maximum value of a column? If possible, please share your file.. Regards, Anoop Sr. Developer On Thu, Sep 19, 2013 at 9:42 PM, Richard wrote: > I have created an MS Query u

Re: $$Excel-Macros$$ Pivot Table - Cumlative Totals

Please do share your file. On Fri, Sep 20, 2013 at 1:34 AM, Brett Manning wrote: > Hello, > > Hope everyone is well. I think I have a really simple question but I am > struggling! I am looking for a cumlative total across columns, please see > example data below: > Basically I want the first co

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

can you share your access database? On Thu, Sep 19, 2013 at 10:40 PM, Michael Pablo wrote: > Hi Enrique, > > I've attempted this Query but I didn't get results. They return this > advertence, saying that I need to use the clausule EXISTS. > > SELECT TOP 1 * FROM MIDASQ12013 > WHERE MIDASQ12013.P

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

I hope the below one works good to you... pls check SELECT TOP 1 * FROM MIDASQ12013 WHERE MIDASQ12013.COUNTRY IN (SELECT TOP 20 MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.

Re: $$Excel-Macros$$ Formula: Count

Check the Attachment... On Tue, Sep 17, 2013 at 8:45 PM, ashish koul wrote: > xy1? what does this mean do you want to count RS with point 1 and so on > > Regards > Ashish > > > On Tue, Sep 17, 2013 at 5:59 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hello, >> >> I need for

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

Make a query as "Select Top 20 From " in case you need a 20th record without changing your records order. but if you want the 20th record after sorting your data in ascending order then make following query "Select Top 20 From order by " In case you need the 20th record after sorting data in des

Re: $$Excel-Macros$$ Beta.dist in Excel

Please check the below link. http://www.techonthenet.com/excel/formulas/betadist.php On Wed, Sep 11, 2013 at 7:24 PM, Sudeshna Sen wrote: > Hi, > > I've been trying to understand how the Beta.dist function works in MS > Excel. The MS Office help says that Beta.dist returns the beta cumulative

Re: $$Excel-Macros$$ Opening only file in folder

Replace your code with below one openFile = Application.GetOpenFilename Workbooks.Open (openFile) On Wed, Sep 4, 2013 at 9:39 PM, ashish koul wrote: > are thr multiple files in the folder > > > On Wed, Sep 4, 2013 at 1:39 PM, Jorge Marques wrote: > >> Hi guys, >> >> I have this macro to open a

Re: $$Excel-Macros$$ MS Access Group

Join such groups on FB On 8/10/13, Kaushal Kumar wrote: > Hi All, > > Is there any such group for MS Access and SAS as well ? > Rgds, Kaushal > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > ht

Re: $$Excel-Macros$$ Macro that will leave data and new data from query when ran

> > On Thursday, 8 August 2013 21:59:19 UTC+5:30, christy palmer wrote: >> >> the same thing happens. the data is over written. using your code i do not >> >> get an overflow error :-) but i still can't get the data to add rather >> than >> replace :-(

Re: $$Excel-Macros$$ Macro that will leave data and new data from query when ran

Replace your code with below one... This will be great if you could provide your original file. Dim state As String Dim startdate As String Dim enddate As String, Erow as long Sub btn1_click() state = Me.Cells(3, 3) startdate = Me.Cells(4, 3) enddate = Me.Cells(5, 3) MsgBox

Re: $$Excel-Macros$$ charting without data?

Yes, You can make a chart by using a sample of data but the reading of chart is of no use as it won't show the right picture. On Sun, Aug 4, 2013 at 7:14 AM, olivia destandau wrote: > Hi all, > I have had a request that I don't know if I can fulfill... I have been > given pictures of graphs of v

Re: $$Excel-Macros$$ Maintaining format when pasting data into a template

You can change your code line where there is copy criteria as given below Make sure to change sheet and range references accordingly Sheet2.Range("C24").Copy Sheet2.Range("C25").PasteSpecial xlPasteValues, xlPasteSpecialOperationNone On Fri, Aug 2, 2013 at 6:01 AM, Steve Weaver wrote: > > > I u

Re: $$Excel-Macros$$ Modify VBA code that finds and copies all rows containing criteria.

Hi Tom, please change the line If c.Value = sAsset Then to If c.Value = sAsset and c.Offset(0,1).Value = ws2.Range("E5") And c.Offset(0,2).Value=ws2.Range("G5") Then If it doesn't work then share your file... On Thu, Aug 1, 2013 at 4:36 AM, Tom Board wrote: > I have a range of data that has 5

Re: $$Excel-Macros$$ Macro to remove a timestamp in a date

Please share your file mentioning all your requirements..I'll try.. On 7/8/13, srsev6 wrote: > Thank you Enrique. How do I set this up in a code to be able to use in a > command button? > > I am familiar with codes in visual basic but not an expert by any means in > writing them. > > > > > On We

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

is located but it can't be seen as you >> will hide it. >> >> >> On Thu, Jul 4, 2013 at 10:21 AM, Pravin Gunjal wrote: >> >>> Hi Anoop >>> >>> I do not want to restrict my folder from unnecessary access instead I >>> want it to b

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

o not want to restrict my folder from unnecessary access instead I want > it to be used by others. > > Regards > Pravin Gunjal. > > -- Forwarded message -- > From: Anoop K Sharma > Date: Thu, Jul 4, 2013 at 5:36 AM > Subject: Re: $$Excel-Macros$$ Files / F

Re: $$Excel-Macros$$ Macro to remove a timestamp in a date

you can use = text(cell,"dd mmm "), this will give time in text format. On Thu, Jul 4, 2013 at 3:17 AM, srsev6 wrote: > Hi all, > > I have already posted this once but can not locate it so I apologize for > the duplicate post. > > > I hope someone can answer my question. I run dates out of

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

If you right click on any folder and check its properties, there you can see a security tab. If you are an administrator or have administrator's right then you can restrict your folder from unnecessary access. This can be done on the folder in shared shared drive. On Wed, Jul 3, 2013 at 5:27 PM,

Re: $$Excel-Macros$$ Need a Fastest way

I haven't studied above macro provided by De Premor, Nice work!. You can make it better by collecting all the highlighted cells address in different worksheet Or you can also use application.Goto "Reference". On Thu, Jun 20, 2013 at 1:07 PM, De Premor wrote: > How about this macro, is this stil

Re: $$Excel-Macros$$ Need help

use conditional formatting. On Thu, Jun 20, 2013 at 2:02 PM, thameem wrote: > Dear Members, > > plz help me to get formuale for high-lighting selected cells > automatically, when value of one cell get 0 or 1 etc > > > regards > Thameem.M > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ writing of excel macro

Approach Noorain Ansari On Mon, May 27, 2013 at 12:42 PM, Rajesh Agarwal wrote: > Hello everyone > I am from Delhi NCR area and want to learn macro excel. Is there any body > in the region who can give me a hour or two hours time to understand it > properly. > Thanks in advance. > Rgds > > -- >

Re: $$Excel-Macros$$ VBA for Dynamic Range

It's working fine at my end, yet you can change the line from "RefersToR1C1" to "RefersTo" as below ActiveWorkbook.Names.Add Name:=sName, RefersTo:= _ "=OFFSET(" & Sht & "!R2C" & Col & ",0,0,COUNTA(" & Sht & "!C" & Col & ")-1," & ColCount & ")" On Fri, May 17, 2013 at 7:50 AM, Cab Boose

Re: $$Excel-Macros$$ push value from Access

Try this Sub proc_FindDate() Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65000").End(xlUp).Row) myVal = "N/A" With rng Set fndVal = .Find(myVal, LookIn:=xlValues) 'myVal is the date to be found If Not fndVal Is Nothing Then frstAdd = fndVal.Address Do

Re: $$Excel-Macros$$ Folder Restriction

Can you see check boxes below "Deny" Title on above screenshot provided by Abhishek. Select a user from above list (here - Administrator, Guests etc) in "Group or Username" category and check the boxes against the controls mentioned in "Permissions for Administrators" Category. You can't restrict a

Re: $$Excel-Macros$$ Folder Restriction

You can restrict the first hand user (except administrator) by restricting him instead of giving full control. On Fri, May 3, 2013 at 12:27 PM, Pravin Gunjal wrote: > User Id will be the same... > > On Fri, May 3, 2013 at 11:45 AM, Anoop K Sharma wrote: > >> If you trying to

Re: $$Excel-Macros$$ Re: Hi Anoop

12:47 PM, Mathan wrote: > >> Hi Anoop, >> >> It's working fine. Thanks a lot ! :-) >> >> Your dedication is much appreciated ! >> >> Regards, >> Mathan >> >> >> On Thu, May 2, 2013 at 8:58 AM, Anoop K Sharma wrote: >>

Re: $$Excel-Macros$$ Folder Restriction

If you trying to restrict a folder by supplying a password that can only be possible with any foreign application. But if you trying to restrict a folder to a person logged on using different user id on same or another machine connected to each other that can be done by changing properties of a fol

Re: $$Excel-Macros$$ Excel Behavior Question

check if it is protected? On Sat, Apr 27, 2013 at 12:17 AM, Chris wrote: > Happy Friday Everybody, > > hope it is allowed to throw in a question here regarding a certain > behavior in Excel that I've just never seen fixed/improved. Ayush, maybe > you or anybody else here know. Just some trivia

Re: $$Excel-Macros$$ data range failed to refresh from local html file

Can you share the file? On Fri, Apr 19, 2013 at 4:03 AM, John Rodgers wrote: > > > hello > I have an excel 2007 workbook, which contains a number of external data > ranges. The query definition for these external data ranges is the local > path to an html file (eg, file:///D:/localfiles/filenam

Re: $$Excel-Macros$$ Macro for filter data & send it to respective user through mail

Refer to link http://lotusnoteconnection.blogspot.in/ for lotus note script On Wed, Apr 10, 2013 at 2:04 PM, अनिल नारायण गवली wrote: > Yes, U can do it by notes.notessession. > > Warm Regards, > Gawli Anil > > On Wed, Apr 10, 2013 at 1:42 PM, C.G.Kumar wrote: > >> Can we do the same thing using

Re: $$Excel-Macros$$ COMPLIE ERROE HIDDEN MODULE MESSAGE IN EXCEL 2007

Probably, one of the library is missing or not selected in excel installed in your PC or laptop. Add all the libraries. You can check the libraries by checking the box in VBA editor.. below is the screen shot to help you. On Wed, Apr 10, 2013 at 2:29 PM, Hari Nair wrote: > I AM USING EXCE

Re: $$Excel-Macros$$ Need formula for sum

Use attached one. This'll take care of text values also. On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote: > But if some in some place text exists then what to do > > Regards, > Deepak > > > On Wed, Feb 27, 2013 at 8:47 PM, Maries wrote: > >> Hi, >> >> Try it, >> >> =SUMIF($D$2:$AB$2,AC2,D$

Re: $$Excel-Macros$$ Is it possible to Create a macro that gives URL as output after giving the advertiser name as Input

No Noorain, this is not what Abhishek looking for. As I can understand he wants a "text box" or "input box" on excel in which he can give his input and find related urls in excel from google. Time investment is required for this to extract urls from IE or Mozila. On Wed, Feb 27, 2013 at 6:05 PM,

Re: $$Excel-Macros$$ Is it possible to Create a macro that gives URL as output after giving the advertiser name as Input

Yes, it is. But before doing it, you need to give reference of database where the word (input) matches itself and provided you available URLs. On Tue, Feb 26, 2013 at 7:45 PM, Abhishek Singh wrote: > > > Example : Input = Maruti > > > Output = http://www.marutisuzuki.com/ > > >

Re: $$Excel-Macros$$ Re: Find negative and terminate

Hi Richard, Please find attached the requested one. Once you are done with first negative value the macro will jump to another one. The process goes one until it finds all. Click Command button on first sheet. Regards, Anoop Sr. Developer On Thu, Feb 21, 2013 at 6:07 AM, Richard Bridges wrote

Re: $$Excel-Macros$$ Index and Match help needed

I can see that you can't share file. Can't you even share sample of fake data? This can help us a lot to understand your query. On Wed, Feb 20, 2013 at 9:20 PM, solsbee wrote: > I have a spreadsheet that the data is keyed in one cell, then multiple > other cells are populated by the index and m

Re: $$Excel-Macros$$ Expire date

Sub ExpDate() Tdate = DateSerial(2013, 1, 24) If Tdate >= Format(Now(), "dd/mm/") Then RunMacro Else MsgBox "Program Expired", vbCritical, "Program Status" ThisWorkbook.Save ThisWorkbook.Close End If End Sub On Tue, Feb 12, 2013 at 7:20 AM, NRao Myn

Re: $$Excel-Macros$$ Need formula

Use the updated file. You can move pivot anywhere in the workbook. There is no change in your table formatting. On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat wrote: > Dear Anoop, > > I need as i given table. > > regards, > Deepak rawat > > > On Thu, Jan 17, 2013

Re: $$Excel-Macros$$ Help in extracting data

egards, >> Chaya >> >> >> On Thu, Jan 17, 2013 at 11:26 AM, chaya moni wrote: >> >>> Dear Anoop, >>> >>> Awesome and unbelievable, it was more then expected. any way i >>> did not check those value. once i check, i revert you

Re: $$Excel-Macros$$ Help in extracting data

he data is missing. > > regards, > Chaya > > > On Thu, Jan 17, 2013 at 11:26 AM, chaya moni wrote: > >> Dear Anoop, >> >> Awesome and unbelievable, it was more then expected. any way i >> did not check those value. once i check, i revert you ba

Re: $$Excel-Macros$$ Need formula

Hi Deepak, PFA. You need to refresh the pivot on first sheet. Regards, Anoop Sr. Developer On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote: > HI, > > Could u suggest any formula to get summary from the data attached in > summary sheet. > > -- > Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Allocation problem between Requirement and Stock.

Hi Eugene, PFA file which can help you in allocation of task. Regards, Anoop On Wed, Jan 16, 2013 at 10:22 AM, अनिल नारायण गवली wrote: > Pls find attached , > > Is it ok???/ > > Thanks & Reagards, > Gawli Anil > > On Tue, Jan 15, 2013 at 4:37 PM, Eugene Bernard > wrote: > >> Dear all, >> >> P

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

ch data the field which i have clicked . I want > all the data. > > Warm Regards, > Gawli Anil > > On Mon, Jan 14, 2013 at 12:19 PM, Anoop K Sharma > wrote: > >> If you have pivot table existed there then double click on the grand >> total value. You can extract

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

If you have pivot table existed there then double click on the grand total value. You can extract the pivot cache data from there. Regards, Anoop On Mon, Jan 14, 2013 at 12:05 PM, अनिल नारायण गवली wrote: > Dear All, > > actually my bro has deleted the source data. befor he has deleted i had > m

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

Congrats Prince On Fri, Jan 11, 2013 at 9:19 AM, wrote: > ** > Many congratulations to u Prince... > Sent from my BlackBerry® smartphone from !DEA > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Thu, 10 Jan 2013 22:19:58 +

Re: $$Excel-Macros$$ Pivot table

Hope the attached file can help you better. Regards, Anoop Sr. Developer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Pro

Re: $$Excel-Macros$$ Fw: significance of using classes in VBA

Paul described wonderfully. Class Module are very Important part of VBA. By using this you can create your own event or event driven procedure. This comes in Advance programming. You can run a program by clicking a command button or by changing the worksheets or there are number of events which you

Re: $$Excel-Macros$$ Re: dbf conversions

http://en.kioskea.net/download/download-5751-xls-excel-to-dbf-converter On Tue, Jan 8, 2013 at 12:49 PM, Asa Rossoff wrote: > Excel 2007+ can import DBF files, but not save to them. Excel 2003 and > prior allow saving as Dbase (DBF) files. > > ** ** > > A few alternsatives for saving/expor

Re: $$Excel-Macros$$ Need Help for formula

Hi Jocky, Made changes in sheet removing validation to show up the values there. Find attached the updated one. On Fri, Jan 4, 2013 at 8:38 PM, Anoop K Sharma wrote: > Hi Jocky, > > Formula's been written in validation rule which will restrict any entry > other entry excep

Re: $$Excel-Macros$$ Need Help for formula

agnihotri < ashwani.agniho...@gmail.com> wrote: > please see if this helps... > > > On Fri, Jan 4, 2013 at 6:43 PM, jocky Beta wrote: > >> Hi Anoop, >> >> There is No formula in the attached sheet, :( >> >> On Fri, Jan 4, 2013 at 5:27 PM, Anoop K Sharma wrote

Re: $$Excel-Macros$$ Re: Remove Duplicate Email ID

You're great dude. On Fri, Jan 4, 2013 at 5:31 PM, Prince wrote: > most welcome dear. > > regards > prince > > > On Friday, January 4, 2013 5:08:01 PM UTC+5:30, amar takale wrote: > >> >> Thank Very much...Prince >> >> >> On Fri, Jan 4, 2013 at 4:37 PM, Prince wrote: >> >>> Public

Re: $$Excel-Macros$$ Need Help for formula

Hi Jocky, Please find attached with solution. Regards, Anoop Sr. Developer On Fri, Jan 4, 2013 at 4:59 PM, jocky Beta wrote: > Hi Team, > > I have attached one excel sheet in wich i need to set the formula for the > person for the entire week.i.e is if one person is working form Mon to Fri >

Re: $$Excel-Macros$$ How to find special characters in a cell

can you share workbook? On Wed, Jan 2, 2013 at 8:34 PM, wrote: > In excel 2012 I'm using the name typed in a cell as a part of the filename > when saved via a macro. > Because the following characters /\*?"<>| are not allowed in a filename I > want to do a check in the cell. > The idea is to pu

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Hi Priyanka, You can refer some good e-books. Why don't you try this on bookboon.com. As a beginner you should go with "Excel Bible", this will teach you not only excel basics but also VBA at initial stage. Regards, Anoop Sr. Developer On Wed, Jan 2, 2013 at 2:18 PM, Manoj Kumar wrote: > Wow!

Re: $$Excel-Macros$$ Re: Happy b'day Noorain Ansari

Happy B'day Noorain... On Wed, Jan 2, 2013 at 10:50 AM, Rajan_Verma wrote: > HI Noorain . > wish you a great New year and Happy b day, > have a great year ahead > > Regards > Rajan verma > > On Wednesday, 2 January 2013 00:13:59 UTC+5:30, ashish wrote: >> >> Happy b'day Noorain Ansari >>

Re: $$Excel-Macros$$ Please unsuscribe

Send mail to below link excel-macros+unsubscr...@googlegroups.com. On Wed, Jan 2, 2013 at 10:25 AM, Praveen Golash wrote: > Please do the needful. > > -- > Regards, > > Praveen Golash > > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES

Re: $$Excel-Macros$$ VBA to show Eastern Time zone less 5 minutes

Hi Sabosis, Please replace your formula with below one. ActiveCell.Formula = Time + TimeSerial(2, 55, 0) Regards, Anoop Sr. Developer -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Fwd: Select Unique values

Hi Rajesh, PFA, Regards, Anoop On Tue, Jan 1, 2013 at 6:30 PM, Rajesh thrissur wrote: > > > > > Hi Experts, > > Please refer the attached file & tell me > How to select employee names from the column "B" and display in Column "D" > after removing the duplicate. > > Regards > Rajesh > > -- > J

Re: $$Excel-Macros$$ How to extract sheet from many excel sheets

Better to make another copy of workbook bcoz somehow you are asking the same thing. On Mon, Dec 31, 2012 at 1:01 PM, maulik desai wrote: > Hi team, > I am having 1excel workbook which contains 250 excel sheets and now I want > to extract those sheets into separate workbook for each sheets. Means

Re: $$Excel-Macros$$ query for getting external data from a website

Hi Kenil, Make changes to below code as per your requirement. If you get stuck then let me know. *What you need to do:* ->change cURL as per your required time period. ->change the range and sheet. ->change the query table. Public Const cURL = "http://www.forexpros.com/indices/us-spx-500-compone

Re: $$Excel-Macros$$ Re: VBA to Destination of Value only

Please try the below one. Sub PasteValueOnly() Dim rng As Range Set rng = Sheets("DailyList").Range("ItemsList") rng.Copy Sheets("ItemsListArchives").Range("D1").PasteSpecial xlPasteValues End Sub On Mon, Dec 31, 2012 at 12:01 PM, Lalit Mohan Pandey < mohan.pande...@gmail.com> w

  1   2   >