Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

2012-02-18 Thread renuka chari
hi it was not work actually in my excel backend some code is there once can you check tahat and give me solution for that thanks for ur valueble replay On Feb 17, 4:48 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Renu, Please see attached Screen shot, it might be helpful On Fri,

$$Excel-Macros$$ Re: Macro to import email information to excel

2012-02-18 Thread renuka chari
hi Option Explicit Sub ExportToExcel() On Error GoTo ErrHandler Dim appExcel As Excel.Application Dim wkb As Excel.Workbook Dim wks As Excel.Worksheet Dim rng As Excel.Range Dim strSheet As String Dim strPath As String Dim intRowCounter As Integer Dim intColumnCounter As Integer Dim msg

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

2012-02-18 Thread Vijayendra Rao
Hi Noorain, It will work only one cell at a time, is it possible to put subject to multiple cellls at a time. Regards, Vijayendra 2012/2/17 NOORAIN ANSARI noorain.ans...@gmail.com Hi Renu, Please see attached Screen shot, it might be helpful On Fri, Feb 17, 2012 at 1:17 PM, Renukachari

Re: $$Excel-Macros$$ Conditional formatting

2012-02-18 Thread Lakshman Prasad
Plz see the attached        From: PRAVESH KUMAR praveshkash...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, 18 February 2012 12:38 PM Subject: $$Excel-Macros$$ Conditional formatting HI, Please help...for conditional formatting

Re: $$Excel-Macros$$ Inputbox to locate and highlight cell

2012-02-18 Thread dguillett1
Simply record a macro while doing a manual editfindthen add your input box and clean it up. If you need further help, post back and/or send a file Don Guillett SalesAid Software dguille...@gmail.com From: David Grugeon Sent: Friday, February 17, 2012 11:25 PM To: excel-macros@googlegroups.com

$$Excel-Macros$$ how to find a text in a folder

2012-02-18 Thread raghu gr
hi all, how to find a text in folder. Example - suppose in 1 folder there are 40 excel files, if i want find a text apple is in which file (as it becomes tedious to open each and every file and use ctrl +F option). with regards raghu -- FORUM RULES (986+ members already BANNED for violation)

Re: $$Excel-Macros$$ how to find a text in a folder

2012-02-18 Thread NOORAIN ANSARI
Dear Raghu, Plwase try it.. Dim j As Long Dim fldpath Dim fld, fil, subfld As Object Sub search_workbooks() Application.DisplayAlerts = False Application.ScreenUpdating = False '* to get file names in folder Application.FileDialog(msoFileDialogFolderPicker).Title = Choose

Re: $$Excel-Macros$$ Needle Gauge Chart Calculation

2012-02-18 Thread hilary lomotey
Wow Dave,and wow again, this is a gret solution, never mind replying late, this is so incredible. after a while i thought it was not possible, great mind you got over there, thumbs up seven times, but sorry man you need to expalin the relevance of using the offset function there and the

Re: $$Excel-Macros$$ I Macros tutorial software need

2012-02-18 Thread vijayajith VA
Hi, Is thr good future in learning Imacros? Thanks On Fri, Feb 17, 2012 at 11:12 PM, xlstime xlst...@gmail.com wrote: Hi Amit, iMacros is the *only* software that can *automate both Internet Explorer and Firefox.* You can control both web browsers directly from Excel.*iMacros works with

Re: $$Excel-Macros$$ Needle Gauge Chart Calculation

2012-02-18 Thread David Grugeon
OK. first I find the number in the dial which is the greatest number less than or equal to the required value. I use match to find how far down it is from J2. This number goes in P7. Then I find out the chart value and corresponding angle for that lower amount and these go int P8 and Q8 Next I

RE: $$Excel-Macros$$ Mr.Noorain there plz send attachment its not there!

2012-02-18 Thread Mohammed Muneer
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Saturday, February 18, 2012 6:25 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Mr.Noorain there is again some problem in u r

$$Excel-Macros$$ RE: Mr. Don I am really really really thankful to u for help!

2012-02-18 Thread Mohammed Muneer
Excellent, u r so nice. Really I was struggling with this bloody problem.. Good bye to the problemblemblemblemblemblem... Thanks Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]