$$Excel-Macros$$ Re: Problem with duplicating a Shape and defining OnAction property

Well, in this case, the shape object in question is not merely a shape, instead an OLE Object (Image Control) is contained in it. The OLE Object (Forms Image Control) exposes its own events. One way (weird one) is to duplicate the Image1 shape on Click and in the Click Event handler programmatica

$$Excel-Macros$$ Re: how to make unique key

Hi Andy,   Would you be able to make your file (for unique key) in .xls format? Cheers, Bakul --- On Thu, 7/23/09, Aindril De wrote: From: Aindril De Subject: $$Excel-Macros$$ Re: how to make unique key To: excel-macros@googlegroups.com Date: Thursday, July 23, 2009, 9:22 PM Dear Aamir,  

$$Excel-Macros$$ Text Import Wizard

I don't think this can be done but I'm going to ask anyway. I would like to know if there is a way to automate the Text Import Wizard. The situation I have is that I import a txt file but the data for some of the columns runs into adjacent columns. I know how to fix same with the Wizard but I'm

$$Excel-Macros$$ Re: Unique Data summary problem

Hi Vishvesh http://help.lockergnome.com/office/COUNTIFS-workaround-Excel-2003--ftopict951180.html the above link can help u in getting the countifs workaround for excel 2003 hope it helps Thanks and Regards, V

$$Excel-Macros$$ Re: how to make unique key

Hi Aamir,   Just a quick question. Do you maintain this spreadsheet for one year only & create new for next year? becasue in your second sheet i can't find date. Would you please explain me what exactly you want? what is SUFF & CURR?   Also Do you want closing balance on 30/06/XX only or monthly

$$Excel-Macros$$ A way to pick up filter condition

I need a formula that picks up what filter condition is used on a column of values. For example: Column A Column B *=filter condition (ie: John, Mary, Ben, Duke, None) People: (heading w/ filter)

$$Excel-Macros$$ Help Needed - Linking 2 workbooks

All, data on my workbook 'cricket.xlsx' is updated through a DDE link and located under g:\ drive I'm trying to link to same file from another machine so data can be updated on both the workbooks at the same time. my source file - 'G:\NT\Cricket.xlsx Target - 'G:\NT\[Cricket.xlsx]Sheet1'!B3 I

$$Excel-Macros$$ Re: how to make unique key

the attached sheet was just example, there are hundred of branches & account numbers in my data. Branch code is unique but repeat many times and same like branch account number is unique but repeat many times. But you can see that product is unique of one customer. I often use formula =A2&"-"&B2

$$Excel-Macros$$ Noob advice, Queries in Scripts

Hi, Haven't seen this in the archives so far. I have a workbook with many sheets that query an SQL database. I need to create a script to analyze the data returned by the queries. I can envision reading the data from each sheet by looking at the row content (literally in the sheet). However if I c

$$Excel-Macros$$ Re: Unique Data summary problem

Vivek, I understood the problem actually countifs is not there in excel 2003, and any function which is written in 2007 and open in 2003 if it is not there then it shown _xlfn.countifs(...). But when trying to change some it shows #NAME error On Thu, Jul 23, 2009 at 10:25 PM, Vishvesh Chauhan < v

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Thanks Vivek. I downloaded. Regards, Aamir Shahzad - Original Message - From: vivek agrawal To: excel-macros@googlegroups.com Sent: Thursday, July 23, 2009 9:02 PM Subject: $$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection Hi Aamir go to this link http:

$$Excel-Macros$$ Re: Unique Data summary problem

i think your ver of excel is 2007, could you help me writing same function using sumif(and()), cause i think _xlfn is not there in 2003 On Thu, Jul 23, 2009 at 10:19 PM, vivek agrawal wrote: > depends what formula you are putting... the referencing of cells need to be > taken care of > Thanks

$$Excel-Macros$$ Re: Saving Filename with variable

sorry ,, you are the best - it was due to path On Jul 23, 12:39 pm, vivek agrawal wrote: > Hi Aman > Can u please specify what kind of error you are facing > which point the error comes does the file get saved.. or might be > possible the file path doesnot exist. > > Thanks and Reg

$$Excel-Macros$$ extract distribution list members to excel

Hi, I found this VBA script out on the internet; There were two scripts. One which extracts names from local contacts (which works) and this one which should extract names from a list on the Global Address List (GAL). My problem is that it errors on this line: Dim olApp As Outlook.Application

$$Excel-Macros$$ Excel Macro to populate a text field in an internet explorer window

Experts,   I am just wondering if there is way to do following with excel VBA:   >Copy a cell from excel >Activate an already opend Internet Explorer window >Populate a text field with copied text >Hit enter >Wait for the next page to load (in the same page) >Click on a link on the page >Wait f

$$Excel-Macros$$ Re: Unique Data summary problem

depends what formula you are putting... the referencing of cells need to be taken care of Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 10:16 PM, Vishvesh Chauhan < vishvesh.chau...@gmail.com> wrote: >

$$Excel-Macros$$ Re: Unique Data summary problem

Vivek, When i'm changing formula, its not again coming and showing an error of #NAME. I have Excel 2003 On Thu, Jul 23, 2009 at 10:07 PM, Vishvesh Chauhan < vishvesh.chau...@gmail.com> wrote: > Hey Vivek, > > I'm really thankful to you for your kind help. May god bless you. > > Regards > > > On

$$Excel-Macros$$ Re: Unique Data summary problem

Hey Vivek, I'm really thankful to you for your kind help. May god bless you. Regards On Thu, Jul 23, 2009 at 10:03 PM, vivek agrawal wrote: > Hi Vishesh > > find the attached file...hope this is what you want > > Thanks and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > Googl

$$Excel-Macros$$ Re: Saving Filename with variable

Hi Aman Can u please specify what kind of error you are facing which point the error comes does the file get saved.. or might be possible the file path doesnot exist. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Th

$$Excel-Macros$$ Re: Pasting as "Link" or "Embedding" from Excel 2007 to Powerpoint 2007

That is the basic problem. I dont want to resize the excel object (whether pasted as an object or as a link) once I paste it back into Powerpoint. If I resize it, the fonts will look stretched and be all over the place. How I can paste as it appears in Excel? I can easily adjust the view in Excel

$$Excel-Macros$$ Re: how to make unique key

after examining your sheet i find that there are four rows which have the same combination of "branch and account" (you say they are unique) with different values of closing balance so how do i differentiate among them. how do i find unique "branch and account".. Thanks and Regards, Viv

$$Excel-Macros$$ Re: UserForms and Workbooks

I think I found what I needed to do. I had to add the "False" attribute after the command that will show the intermediary form. I.E. Userform.Show False On Jul 22, 5:09 pm, turtle wrote: > Hello, > > I am in the process of creating some data entry forms in Excel through > visual basic.  Basic

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Hi Aamir go to this link http://groups.google.com/group/excel-macros/files?&sort=date right click on the first file and save it directly... it gets saved... i've checked it just now.. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth

$$Excel-Macros$$ Re: Help regarding graph in excel

Hi Daniel, Thanks for resolving the problem, I have tested the worksheet it is working fine. Regards, Kunal Rout On Jul 21, 5:09 pm, "Daniel" wrote: > See the attached file. Need to be thoroughly tested. > > Daniel > > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]

$$Excel-Macros$$ Re: Help me Plz

very nice Andy Regards, Aamir Shahzad - Original Message - From: Aindril De To: excel-macros@googlegroups.com Sent: Wednesday, July 22, 2009 4:27 PM Subject: $$Excel-Macros$$ Re: Help me Plz Hi Anil, Please use the following formula =IF(COUNTIF($A$2:A2,A2)=1,"Uniqu

$$Excel-Macros$$ Duplicate colmuns

hi Plz find attached the possible solution based on my understanding of the problem. The solution uses the following logic: =SUMPRODUCT(($C$2:$C$15=$B2)*1)>0 conditional formatting in B2 to B15 =SUMPRODUCT(($B$2:$B$15=$C2)*1)>0 conditional formatting in c2 to c15 Let me know if this was f

$$Excel-Macros$$ Re: Microsoft Office 2007 ebooks collection

Your links return error "Bad Request Error 400" Regards, Aamir Shahzad - Original Message - From: "Vivek Agrawal" To: "MS EXCEL AND VBA MACROS" Sent: Wednesday, July 22, 2009 10:18 AM Subject: $$Excel-Macros$$ Microsoft Office 2007 ebooks collection Hello Excel Experts and Learner

$$Excel-Macros$$ Re: Point of Sales or Billing Software

Hi Hitesh, I also keen to teach VB (in excel). If you get appropriate sites or information, don't forget to remind / send me. Thanks in Advance. Regards, Dhananjay On 7/21/09, Hitesh Taunk wrote: > > Hello Everyone, > I have newly joined this group about a day before.

$$Excel-Macros$$ Re:

To copy & paste cell content to thousands of cells: 1. Select and copy cell A1. 2. Type a cell address in the Name box, for this example, type A5000. 3. Press Shift+Enter to select the cells from A1:A5000. 4. To paste, press Enter. --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ help required

hello frds i am stuck in this problem. I made one distance matrix table sheet. i attached in this mail i am not able to make a VBA code for following problem 1. 4 -5 cities i write in column 1 will automatically comes in horizontal line of sheet 1, The cities which i write in column 1,that cit

$$Excel-Macros$$ Re: Duplicate colmuns

Thanx a ton man *Simple gr8* On Thu, Jul 23, 2009 at 3:45 PM, vivek agrawal wrote: > hi mahesh... > though i have already sent a code... you can use the code below... it would > serve the purpose in a better way.. > > > Sub highlight_duplicate()

$$Excel-Macros$$ Re: Duplicate colmuns

hi mahesh... though i have already sent a code... you can use the code below... it would serve the purpose in a better way.. Sub highlight_duplicate() Dim vClmn(1 To 2) As Range Dim vCnctnt_Values() As String Dim vCells As Range Dim vRows_Count As Inte

$$Excel-Macros$$ Re: Duplicate colmuns

hi Mahesh below is the code which u can copy and use === Sub highlight_duplicate() Dim vClmn(1 To 2) As Range Dim vCnctnt_Values() As String Dim vCells As Range Dim vRows_Count As Integer Dim vColor() As Integer Set vClmn(1) = Range([b2], [b2].End(xlD

$$Excel-Macros$$ Re: Duplicate colmuns

ok ok now i got the query,.., will try to get a solution soon... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 12:51 PM, Mahesh wrote: > Hi vivek, > > I want that if both columns are same then it will be

$$Excel-Macros$$ Re: Duplicate colmuns

Hi, Please check the attached excel Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mahesh Sent: 23 July 2009 PM 12:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Duplicate colmuns Hi vivek, I

$$Excel-Macros$$ Re: Problem with duplicating a Shape and defining OnAction property

By VBS, i believe you are asking for Visual basic in excel (and not vbscript) I have listed couple of links below. I hope this helps http://www.your-save-time-and-improve-quality-technologies-online-resource.com/free-vba-tutorials.html http://www.businessbookmall.com/Microsoft_Excel_Directio

$$Excel-Macros$$ Re: Duplicate colmuns

Hi vivek, I want that if both columns are same then it will be highlighted else not. Example:- A B 1 12N0044 076E5920 2 12N0648 076E5920 3 12N0650 076E4039 4 12N0650 076E4039 As u see in above example B1 & B2 are same but they not highlited, but A3 & B3:

$$Excel-Macros$$ Re: Fwd: Please help me to solve the problm

dear plz find attahced may this can suit your requriements. Reagrds.Toqeer On Sat, Jul 18, 2009 at 4:24 PM, shijomon joseph wrote: > Dear Friends, > Please help me to solve the problm.., I am attaching the sample sheet > also, > > Thanks in advance > > Best regards > > shijo > > --