$$Excel-Macros$$ spread sheets to quicken

2009-03-12 Thread angela mecha
Hi, Please help me out, how do i import spreadsheets into quicken or quickbooks? Is there a way of importing records from quickbooks directly without using additional software? --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Compare two columns!!

2009-03-12 Thread vijender kumar
Hi On reply of your first query please use the below formula for column C for finding if A and B column are equal or not. =IF(A1=B1,"0","1") On reply of your second query you simply use the Minus function. =A1-B1 If you have any query then pls let me know Regards On 3/10/09, Skanda wrote:

$$Excel-Macros$$ COLOR CELLS BY % PERCENTAGE 33% Color one cell 33% , another cell 33%, another cell 34%

2009-03-12 Thread ExcelUser777
HI basically i'd like to only show coloring in part of a cell so for example cell A1 is grey only 33% of the cell is grey I'd like to color one cell grey 33% I have several cells to color, different percentages... once i see one macro i can create the other percentages... Is that possible w

$$Excel-Macros$$ Regarding VBA Tutorial

2009-03-12 Thread Abdul Hakim
Can i get VBA tutorial and how to write program in excel . Regards, Hakim --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

Fw: $$Excel-Macros$$ Re: Compare two columns!!

2009-03-12 Thread vijay kumar
you can also try   a1=b1   true and false condition. --- On Thu, 3/12/09, vijender kumar wrote: From: vijender kumar Subject: $$Excel-Macros$$ Re: Compare two columns!! To: excel-macros@googlegroups.com Date: Thursday, March 12, 2009, 2:38 AM Hi   On reply of your first query please use the

$$Excel-Macros$$ Re: 2nd Anniversary - Surprise Gift for Top Posters on Mar16

2009-03-12 Thread Harmeet Singh
Congrats to all the winners, Watch out for me as my name is going to be there in place of Dave next time. :) On Wed, Mar 11, 2009 at 5:23 AM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Community Members, > > Congratulations and Thanks to all of our members for being part of > this communi

$$Excel-Macros$$ Re: VBA Form Auto Sizing

2009-03-12 Thread kanwal_no1
Hi Ashish, A little help and I would be done.. Regards Kanwaljit --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ Re: COLOR CELLS BY % PERCENTAGE 33% Color one cell 33% , another cell 33%, another cell 34%

2009-03-12 Thread Dave Bonallack
Hi EU777, As far as I know, this sort of formatting is only available in XL2007. Regards - Dave > Date: Thu, 12 Mar 2009 04:51:00 -0700 > Subject: $$Excel-Macros$$ COLOR CELLS BY % PERCENTAGE 33% Color one cell 33% > , another cell 33%, another cell 34% > From: lax_...@comcast.net > To: excel

$$Excel-Macros$$ Automatically paste contents of active cell into Webpage Search box

2009-03-12 Thread Mike C
Someone gave the the below macro (using Microsoft Internet Controls via Code Editor > Tools > References) for taking the active cell in Excel and then automatically placing it in a search box in a new Explorer Webpage, and then in effect, hitting ENTER. It works with the website provided, www.eba

$$Excel-Macros$$ Re: 2nd Anniversary - Surprise Gift for Top Posters on Mar16

2009-03-12 Thread Ashish Jain
Hi Harmeet, We really appreciate your spirit and are watching you from previous month. We must say for you, Excellent Posts - Consistent Performance - Helping Attitude. So much Thanks from all community members to you. and We hope other community members to show this spirit in similar manner. Pos

$$Excel-Macros$$ Re: Automatically paste contents of active cell into Webpage Search box

2009-03-12 Thread Ashish Jain
Hi Mike Here is your Solution: Sub Login_Website() 'Requires Reference to "Microsoft Internet Controls" 'Declare Reference to InternetExplorer Object Dim MyBrowser As SHDocVw.InternetExplorer 'Set Reference to InternetExplorer Object Set MyBrowser = New SHDocVw.InternetExplorer

$$Excel-Macros$$ Re: Regarding VBA Tutorial

2009-03-12 Thread Ashish Jain
Hi Abdul, Keep Watching - http://www.excelitems.com or Go to Files Section of this Group. For more tips, tricks, downloads and problem solutions: visit --> http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Aust

$$Excel-Macros$$ Re: spread sheets to quicken

2009-03-12 Thread Ashish Jain
Hi, What is Quicken? If tool/Software,Is it free ? For more tips, tricks, downloads and problem solutions: visit --> http://www.excelitems.com Regards *Ashish **Jain* Analyst, CSC Australia Microsoft Certified Application (

$$Excel-Macros$$ Re: COLOR CELLS BY % PERCENTAGE 33% Color one cell 33% , another cell 33%, another cell 34%

2009-03-12 Thread Sathish Jalendran
Hi, This is possible thru conditional formatting Regards Sathish Jalendran -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ExcelUser777 Sent: 12 March 2009 05:21 pm To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ COLOR C

$$Excel-Macros$$ Re: Automatically paste contents of active cell into Webpage Search box

2009-03-12 Thread Mike C
Thanks so much! On Mar 12, 7:50 pm, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Mike > > Here is your Solution: > > Sub Login_Website() > 'Requires Reference to "Microsoft Internet Controls" >     'Declare Reference to InternetExplorer Object >     Dim MyBrowser As SHDocVw.InternetExplorer >  

$$Excel-Macros$$ Urgent Help-Create charts from excel to ppt's template

2009-03-12 Thread Nassa
Hi all, I have a macro that create charts from from excel to ppt but now I want it to create those charts in one of the templates of ppt(power point). I am really appreciate if you can help me Thanks, Nassa --~--~-~--~~~---~--~~ --