RE: $$Excel-Macros$$ Reverse of rounding

Hi, 10 things you should know about binary . . . (Welcome to the world of base 2) Regards - Dave. > Date: Tue, 20 Jul 2010 05:26:21 -0700 > Subject: $$Excel-Macros$$ Reverse of rounding > From: laurence.tha...@navy.mil > To: excel-macros@googlegroups.com > > I have a macro where I copy

$$Excel-Macros$$ Re: Need SUMIF with 3 criteria

Hi, =SUM(IF(A47:A64=A64,IF(B47:B64=B64,IF(D47:D64=D64,E47:E64,0),0))) This is entered as an array formula. Hope it helps. Thanks, David On Jul 19, 4:43 pm, Nadine S wrote: > I need to sum a column if three other columns in one sheet match the three in > another.  Can this be done?  Thanks. >

Re: $$Excel-Macros$$ Show a Form in VSTO Excel

Hi Gaurav, maybe you can help again. Leveraging your knowledge. In my project, described before, in the form there will be a button. I want when I click this button excel import an text file in another workbook. I would like to know how can I instantiate this workbook to get data from it to put in

Re: $$Excel-Macros$$ XML files to Excel

http://www.youtube.com/watch?v=r0S2CQd46C4 On Tue, Jul 20, 2010 at 9:33 PM, Aindril De wrote: > Try this > > http://www.forgram.com/ > > Regards, > Andy > > > On Tue, Jul 20, 2010 at 12:59 AM, Al wrote: > >> >> Dear All : >> >> I have bunch of xml files, i would like to

Re: $$Excel-Macros$$ XML files to Excel

Try this http://www.forgram.com/ Regards, Andy On Tue, Jul 20, 2010 at 12:59 AM, Al wrote: > > Dear All : > > I have bunch of xml files, i would like to convert them in to an > excel sheet .. > how can this be done ? > > Thanks in advance > Al > > -- > > -

Re: $$Excel-Macros$$ Need SUMIF with 3 criteria

You can simply use SUMIFS if you are using excel 2007 On Tue, Jul 20, 2010 at 11:49 AM, saggi wrote: > =SUM(IF(($A$1:$A$15=A2)*($D$2:$D$50=D8)*($C$3:$C$30=C5),1,0)) > > This way you can use Sum IF formula for 3 Condition > > -- > >

$$Excel-Macros$$ Re: Reverse of rounding

On 20 Jul., 14:26, larry wrote: > I have a macro where I copy data into an array from one sheet and then > post it in another sheet and there is something odd. .8 becomes , > 79, .15 becomes .1501. The other way around this would be > rounding. It only changes the values in the first column

Re: $$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

Hi is it posible, to export data excel to access using vba code vilas chavan On 7/19/10, Kishan Reddy, K wrote: > Hello, > > Very simple. > > Select the macros tab. > > click on the new button. Macro window will appear. > > In actions column select 'TRANSFERSPREADSHEET'. > > In action arguments

$$Excel-Macros$$ Reverse of rounding

I have a macro where I copy data into an array from one sheet and then post it in another sheet and there is something odd. .8 becomes , 79, .15 becomes .1501. The other way around this would be rounding. It only changes the values in the first column. Any ideas on what is going on? -- --

$$Excel-Macros$$ Re: automation error

On 19 Jul., mohd ateeq wrote: > HI all, > Can anyone help me out with the following error: > Run-time error ‘-2147417848 (80010108)’: > Automation error > The object invoked has disconnected from its clients > It occurs when I create around 30-40 new excel files based on some criteria > and updat

Re: $$Excel-Macros$$ date format

Tnanx!! for ur kind resoponse. Regards, Deepak On Tue, Jul 20, 2010 at 12:21 PM, Prashant Jadhav < prashantjadhav...@gmail.com> wrote: > Dear Deepak, > > 1st thing is you have to replace (//) with single (/) and have to insert > date with dd/mm/ format and not mm/dd/ > > Your prob will g

$$Excel-Macros$$ Re: save excel into a directory with file name equal to a cell value

Hi You can use the below code: ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\Rajendra Soni_2\Desktop\" & Range("a1") & ".xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False Regards Rajender Soni On Jul 20, 1:32 pm, Oliver

Re: $$Excel-Macros$$ date format

Hi Simply replace "//" by "/" and do the formatting, I don't think anything else needs to be done for this. Regards Rajender Soni On Jul 20, 1:33 pm, Dave Bonallack wrote: > Hi Deepak, > > Not quite sure what's wrong, but some of the data in Col C has a double // > between the year and month.

Re: $$Excel-Macros$$ Re: [Fwd: Help for format converson required]

Hi, A good solution Dilip Ji. Please see the attached file with just a little modification. Thanks & Regards Sandeep On Tue, Jul 20, 2010 at 4:00 PM, Dilip Pandey wrote: > Hi Pradeep, > > Look out for green shaded cell in the attached spreadsheet, in which I have > done something for you. > >

$$Excel-Macros$$ Re: [Fwd: Help for format converson required]

Hi Pradeep, Look out for green shaded cell in the attached spreadsheet, in which I have done something for you. Let me know if it works. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 13 Messages in 9 Topics

There is nothing special to do... Just use Text to Column option and use Delimited and then put - in others. click on next next and your data will be separated... REgards Amit Jindal On Tue, Jul 20, 2010 at 8:07 AM, Ashish kaushik wrote: > can we separate the numbers n alphabates from a cell. >

$$Excel-Macros$$ save excel into a directory with file name equal to a cell value

Hi, All I want to save an excel spreadsheet into a defined directory and the file name should be equal to a cell value on one tab; anyone has a handy vba code to solve this problem: e.g location = my document\my folder file name = cell c37 on tab "my sheet" -- -

$$Excel-Macros$$ Hi

Thanks! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Exce

RE: $$Excel-Macros$$ date format

Hi Deepak, Not quite sure what's wrong, but some of the data in Col C has a double // between the year and month. Also, it's coming up on my system as Month, Day, Year, which means XL doesn't recognise it as a Date. (If it did, it would display it according my local settings, Day, Month, Year)

RE: $$Excel-Macros$$ Prepare break database(HTML)

Hi, You need someone to design your system from the bottom up. But this group is really just about discussing and solving specific issues within an already established system. Your request involves many hours of work, and you will probably need to employ someone with the relevant skills. Rega

Re: $$Excel-Macros$$ date format

Dear Deepak, 1st thing is you have to replace (//) with single (/) and have to insert date with dd/mm/ format and not mm/dd/ Your prob will get resolved -- Regards, Prashant On Tue, Jul 20, 2010 at 11:46 AM, Deepak Rawat wrote: > Hi all > > My problem is, there is a field *Date*