Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail
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, Feb 17, 2012 at 1:17 PM, Renukachari Kasee jva.ch...@gmail.comwrote: *hi* *all* *can you help me, actually this is older post only* * * *thanks * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------ To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ Screen_Shot(Email).doc 239KViewDownload- Hide quoted text - - Show quoted text - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Macro to import email information to excel
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 As Outlook.MailItem Dim nms As Outlook.NameSpace Dim fld As Outlook.MAPIFolder Dim itm As Object strSheet = OutlookItems.xls strPath = C:\Examples\ strSheet = strPath strSheet Debug.Print strSheet 'Select export folder Set nms = Application.GetNamespace(MAPI) Set fld = nms.PickFolder 'Handle potential errors with Select Folder dialog box. If fld Is Nothing Then MsgBox There are no mail messages to export, vbOKOnly, _ Error Exit Sub ElseIf fld.DefaultItemType olMailItem Then MsgBox There are no mail messages to export, vbOKOnly, _ Error Exit Sub ElseIf fld.Items.Count = 0 Then MsgBox There are no mail messages to export, vbOKOnly, _ Error Exit Sub End If 'Open and activate Excel workbook. Set appExcel = CreateObject(Excel.Application) appExcel.Workbooks.Open (strSheet) Set wkb = appExcel.ActiveWorkbook Set wks = wkb.Sheets(1) wks.Activate appExcel.Application.Visible = True 'Copy field items in mail folder. For Each itm In fld.Items intColumnCounter = 1 Set msg = itm intRowCounter = intRowCounter + 1 Set rng = wks.Cells(intRowCounter, intColumnCounter) rng.Value = msg.To intColumnCounter = intColumnCounter + 1 Set rng = wks.Cells(intRowCounter, intColumnCounter) rng.Value = msg.SenderEmailAddress intColumnCounter = intColumnCounter + 1 Set rng = wks.Cells(intRowCounter, intColumnCounter) rng.Value = msg.Subject intColumnCounter = intColumnCounter + 1 Set rng = wks.Cells(intRowCounter, intColumnCounter) rng.Value = msg.SentOn intColumnCounter = intColumnCounter + 1 'Set rng = wks.Cells(intRowCounter, intColumnCounter) 'rng.Value = msg.ReceivedTime 'Set rng = wks.Cells(intRowCounter, intColumnCounter) ' 'rng.Value = msg.Body ' 'intColumnCounter = intColumnCounter + 1 Next itm Set appExcel = Nothing Set wkb = Nothing Set wks = Nothing Set rng = Nothing Set msg = Nothing Set nms = Nothing Set fld = Nothing Set itm = Nothing Exit Sub ErrHandler: If Err.Number = 1004 Then MsgBox strSheet doesn't exist, vbOKOnly, _ Error Else MsgBox Err.Number ; Description: , vbOKOnly, _ Error End If 'ErrHandler: Set appExcel = Nothing Set wkb = Nothing Set wks = Nothing Set rng = Nothing Set msg = Nothing Set nms = Nothing Set fld = Nothing Set itm = Nothing End Sub Try this Copy Above Code As it is and goto outlook -- Press Alt+F11 --insert New module and Past it and goto tools on Vb editor --- goto Reference --- and mark on microsoftexcel 12.0Object library Save that and restart the ms outlook and press Alt+f8 --run that before that create a new folder in c: drive on that folder keep excel file inthe nae of Examples this path was reflected on below path allready this is part of above code this is only for ur reference purpose Dim itm As Object strSheet = OutlookItems.xls strPath = C:\Examples\ Regards On Feb 16, 8:24 pm, B.N.Chethan Kumar chetankumar1...@gmail.com wrote: Dear friends, Need a help. I need to import email information into excel need following information from Outlook express. email received: - Sender Name or Email ID Sender time: Subject: Email responded: Responded name or email id Responded time Subject: -- B.N Chetan kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail
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 Kasee jva.ch...@gmail.comwrote: *hi* *all* *can you help me, actually this is older post only* * * *thanks * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Conditional formatting
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 PFA attached file Thanks Pravesh Kashyap -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Question(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Inputbox to locate and highlight cell
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 Subject: Re: $$Excel-Macros$$ Inputbox to locate and highlight cell You would need to use Match to find the locationof thecell. Than you would use Cell(?,?).format.interior.color= to highlight the cell. Lastly use ScrollIntoView (I think it is called that) to make the cell sit in the visible area. On 18 February 2012 11:29, Bob bobandrich...@comcast.net wrote: I'm trying to create an inventory tracking system to pinpoint a specific location(a simple one) which, when the part number is entered into the Inputbox, Excel will go to, select and highlight that cell where the part number is located. I'm familiar with VBA just don't know the code, also using excel 2010. Thanks in Advance!!! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ how to find a text in a folder
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) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how to find a text in a folder
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 Folder Application.FileDialog(msoFileDialogFolderPicker).Show fldpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpath) getnames fld Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub Sub getnames(ByRef prntfld) For Each fil In prntfld.Files j = Sheets(1).Range(A65356).End(xlUp).Row + 1 ' WILL SEARCH only excel files If UCase(Right(fil.Path, 4)) = UCase(.xls) Or UCase(Right(fil.Path, 5)) = UCase(.xlsx) Then Set swa = Application.Workbooks.Open(fil.Path) Windows(fil.Name).Visible = False For Each wk In swa.Worksheets Set a = Nothing Set a = wk.Cells.Find(What:=* ThisWorkbook.Sheets(File Names).Range(c2).Value *, After:=wk.Cells(1, 1), _ LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) If Not a Is Nothing Then r = ThisWorkbook.Sheets(File Names).Range(a65356).End(xlUp).Row + 1 ThisWorkbook.Sheets(File Names).Cells(r, 1).Value = fil.Path ThisWorkbook.Sheets(File Names).Cells(r, 2).Value = Right(fil.Name, Len(fil.Name) - InStrRev(fil.Name, .) + 1) ThisWorkbook.Sheets(File Names).Cells(r, 3).Value = Left(fil.Name, InStrRev(fil.Name, .) - 1) Exit For End If Next wk Windows(fil.Name).Visible = True swa.Close End If Next fil For Each subfld In prntfld.SubFolders getnames subfld Next subfld End Sub On Sat, Feb 18, 2012 at 11:20 PM, raghu gr balaji.bra...@gmail.com wrote: 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) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Needle Gauge Chart Calculation
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 formula for getting the angle required. i was just browsing through what you did and cant see how the whole stuff you done applies to the chart. or i guess the angle required is connected to the price, could you kindly explain to me the logic behind this. On 2/18/12, David Grugeon da...@grugeon.com.au wrote: Forgot the attachment On 16 February 2012 18:44, hilary lomotey resp...@gmail.com wrote: Thanks Dave, thanks a lot for responding, i have attached the file to demonstrate what i want to achieve, basically what i want is when a stock is selected i want the needle to move to price of the stock, the stock prices are within the range specified in the file attached headed prices. On Thu, Feb 16, 2012 at 12:00 AM, David Grugeon grug...@gmail.com wrote: Because the graduations on the dial are non linear (and not even logarithmic) you cannot automatically calculate the values. You have to do it by trial and error. I have made a new column with my suggestions. You could fine tune this if you wanted to by using more fractional numbers but for practical purposes my suggestions will probably be adequate. I do not understand exactly what you are trying to do so if this is not OK try giving more of an explanation. On 16 February 2012 00:51, hilary lomotey resp...@gmail.com wrote: Dear Experts, i have created a speedometer chart, however i am trying to calculate the needle or indicator using the parameters as attached but having difficulty in doing so, i would be grateful if i get some suggestions.thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or
Re: $$Excel-Macros$$ I Macros tutorial software need
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 every website *and can automate even the most complicated websites that use dialog boxes, frames, Javascript and AJAX can be automated. *Where other software fails, iMacros can automate it.* On Fri, Feb 17, 2012 at 5:46 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear All, ** ** Please explain what do you mean by imacros.. ** ** Best Regards, Amit ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* 17 February 2012 15:04 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ I Macros tutorial software need ** ** Dear Veeru, Please find attached manual of Imacros. On Fri, Feb 17, 2012 at 1:15 PM, Veeru TOC veerub...@gmail.com wrote:** ** -- Dear group , Anybody have mererial for imacros . *ThanksRegards* * * * **Veerendra.Vanam* *TOC TEAM* * * *Bhagyanagar Electrical Contractors** ****H.No-5-9-286/65,Plot No-65 Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally, Hyderabad-500072,-Andhra Pradesh * * *Error! Filename not specified.*91-9177-444-840**,* ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in
Re: $$Excel-Macros$$ Needle Gauge Chart Calculation
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 find the next value (which will be the chart indication above the lowest amount greater than the price). This goes in P9 and Q9 Now we can interpolate the actual price by calculating the excess of the price over the lower price as a proportion of the gap between the prices. This is used to calculate the angle required (or more precisely the scale value required for the needle). All this is done in the formula in Q11. The formula in Q11 could be expressed the angle for the lower threshold +(the price less the lower threshold)divided by the difference between the upper and lower thresholds multiplied by the difference between the lower and upper angles. Let me know if this is not clear. Best regards David Grugeon On 19 February 2012 04:52, hilary lomotey resp...@gmail.com wrote: 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 formula for getting the angle required. i was just browsing through what you did and cant see how the whole stuff you done applies to the chart. or i guess the angle required is connected to the price, could you kindly explain to me the logic behind this. On 2/18/12, David Grugeon da...@grugeon.com.au wrote: Forgot the attachment On 16 February 2012 18:44, hilary lomotey resp...@gmail.com wrote: Thanks Dave, thanks a lot for responding, i have attached the file to demonstrate what i want to achieve, basically what i want is when a stock is selected i want the needle to move to price of the stock, the stock prices are within the range specified in the file attached headed prices. On Thu, Feb 16, 2012 at 12:00 AM, David Grugeon grug...@gmail.com wrote: Because the graduations on the dial are non linear (and not even logarithmic) you cannot automatically calculate the values. You have to do it by trial and error. I have made a new column with my suggestions. You could fine tune this if you wanted to by using more fractional numbers but for practical purposes my suggestions will probably be adequate. I do not understand exactly what you are trying to do so if this is not OK try giving more of an explanation. On 16 February 2012 00:51, hilary lomotey resp...@gmail.com wrote: Dear Experts, i have created a speedometer chart, however i am trying to calculate the needle or indicator using the parameters as attached but having difficulty in doing so, i would be grateful if i get some suggestions.thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- David Grugeon -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
RE: $$Excel-Macros$$ Mr.Noorain there plz send attachment its not there!
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 solved book - plz check. Dear Muneer, Please find attached sheet. It's working fine as per your requirement. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorainansari.com/ http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ On Sat, Feb 18, 2012 at 10:08 AM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Noorain can u plz check again there is a some problem confronting to execute properly. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ RE: Mr. Don I am really really really thankful to u for help!
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] On Behalf Of dguillett1 Sent: Saturday, February 18, 2012 5:35 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Mr.Noorain there is again some problem in u r solved book - plz check. See attached for this AUTOMATIC macro that does not need formulas. Just change a1 Private Sub Worksheet_change(ByVal Target As Range) If Target.Address Range(a1).Address Then Exit Sub Dim lr As Long Rows(8).Resize(Cells(Rows.Count, 1).End(xlUp).Row).Delete lr = Sheets(Data!).Cells(1, 1).End(xlDown).Row With Sheets(Data!).Range(a2:p lr) .AutoFilter Field:=1, Criteria1:=Target .SpecialCells(xlCellTypeVisible).Copy Range(A8) .AutoFilter End With End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Mohammed Muneer mailto:mmun...@ccc.com.qa Sent: Friday, February 17, 2012 10:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Mr.Noorain there is again some problem in u r solved book - plz check. Dear Noorain can u plz check again there is a some problem confronting to execute properly. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com