$$Excel-Macros$$ Enter value in Chrome
Hi All, Good Day. Please help me with a macro, which can enter value in Chrome or Firefox. I have a code to do the same in IE but the site response is very slow.. By using below code I am able to open the page.. Please help to get a code for entering the value in text box.. Sub Open_Chrome() Dim chromePath As String chromePath = C:\Users\User1\AppData\Local\Google\Chrome\Application\chrome.exe Shell (C:\Users\User1\AppData\Local\Google\Chrome\Application\chrome.exe -url http:google.ca) End Sub Thanks, Kiran -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Excel macro to add VBA password
Hi, thanks a lot your quick responce.. thanks, kiran On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Kiran, Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime under VBE editor. On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kiran, Please try it.. Sub ProtectFiles() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(YourFolderPath) For Each MyFile In MyFolder.Files MyFile.Password=abc Next End Sub On Thu, Sep 6, 2012 at 10:47 AM, Kiran Kancharla srkira...@gmail.comwrote: Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks Regards, Kiran 9920456606 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Excel macro to add VBA password
Hi, with the above macro I am able to add pasword to open the file. In my case i need a maco to add pssword for VBA, not for opening the file. plase help... On 9/6/12, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: *Thanks a lot Noorain Bhai* ** Have you any programme for protecting the same files in that folder...? Thanks Regards, SAGAR On Thu, Sep 6, 2012 at 2:41 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sagar, Please use it. Change Folder path as per your need. Sub Protect_filesofFolder() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(D:\VBA_Class\Extra\) For Each MyFile In MyFolder.Files Workbooks.Open MyFile ActiveWorkbook.Password = abc ActiveWorkbook.Save ActiveWorkbook.Close Next End Sub On Thu, Sep 6, 2012 at 1:59 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Noorain, Please find attached herewith screen shot. On Thu, Sep 6, 2012 at 1:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Wht error is showing, Please send screenshot. On Thu, Sep 6, 2012 at 1:49 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Noorain, I have the same but it is not working. Thanks Regards, KSAGAR On Thu, Sep 6, 2012 at 1:33 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sagar, First of all you have add library in VBE Area Step:- Tools-Reference-Microsoft Scrinpting Runtime. Brother check once again, if does',t work revert me. On Thu, Sep 6, 2012 at 1:22 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Noorain, I am not able to run the programme and showing compile error (Method or data not found) after running. Thanks Regards, KSAGAR On Thu, Sep 6, 2012 at 12:07 PM, Kiran Kancharla srkira...@gmail.com wrote: Hi, thanks a lot your quick responce.. thanks, kiran On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Kiran, Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime under VBE editor. On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kiran, Please try it.. Sub ProtectFiles() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(YourFolderPath) For Each MyFile In MyFolder.Files MyFile.Password=abc Next End Sub On Thu, Sep 6, 2012 at 10:47 AM, Kiran Kancharla srkira...@gmail.comwrote: Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.com http://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.com http://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.com http://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.com http://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ Excel macro to add VBA password
hi noorain, yes i want to protect VBA Thanks, kiran On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Means, You want to protect VBA Coding instead of Opening File. Kindly confirm. On Thu, Sep 6, 2012 at 6:32 PM, Kiran Kancharla srkira...@gmail.com wrote: Hi, with the above macro I am able to add pasword to open the file. In my case i need a maco to add pssword for VBA, not for opening the file. plase help... On 9/6/12, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: *Thanks a lot Noorain Bhai* ** Have you any programme for protecting the same files in that folder...? Thanks Regards, SAGAR On Thu, Sep 6, 2012 at 2:41 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sagar, Please use it. Change Folder path as per your need. Sub Protect_filesofFolder() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(D:\VBA_Class\Extra\) For Each MyFile In MyFolder.Files Workbooks.Open MyFile ActiveWorkbook.Password = abc ActiveWorkbook.Save ActiveWorkbook.Close Next End Sub On Thu, Sep 6, 2012 at 1:59 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Noorain, Please find attached herewith screen shot. On Thu, Sep 6, 2012 at 1:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Wht error is showing, Please send screenshot. On Thu, Sep 6, 2012 at 1:49 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Noorain, I have the same but it is not working. Thanks Regards, KSAGAR On Thu, Sep 6, 2012 at 1:33 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sagar, First of all you have add library in VBE Area Step:- Tools-Reference-Microsoft Scrinpting Runtime. Brother check once again, if does',t work revert me. On Thu, Sep 6, 2012 at 1:22 PM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Dear Noorain, I am not able to run the programme and showing compile error (Method or data not found) after running. Thanks Regards, KSAGAR On Thu, Sep 6, 2012 at 12:07 PM, Kiran Kancharla srkira...@gmail.com wrote: Hi, thanks a lot your quick responce.. thanks, kiran On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Kiran, Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime under VBE editor. On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kiran, Please try it.. Sub ProtectFiles() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(YourFolderPath) For Each MyFile In MyFolder.Files MyFile.Password=abc Next End Sub On Thu, Sep 6, 2012 at 10:47 AM, Kiran Kancharla srkira...@gmail.comwrote: Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.com http://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.com http://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.com http://www.noorainansari.com
Re: $$Excel-Macros$$ Excel macro to add VBA password
4. vba protecion password On 9/6/12, Rajan_Verma rajanverma1...@gmail.com wrote: Where you want to apply Password. 1) File Open ? 2) Worksheet Password ? 3) Workbook Password ? 4) VBA project Password ? Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancharla Sent: 06 September 2012 12:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel macro to add VBA password Hi, thanks a lot your quick responce.. thanks,u kiran On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Kiran, Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime under VBE editor. On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kiran, Please try it.. Sub ProtectFiles() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(YourFolderPath) For Each MyFile In MyFolder.Files MyFile.Password=abc Next End Sub On Thu, Sep 6, 2012 at 10:47 AM, Kiran Kancharla srkira...@gmail.comwrote: Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainans ari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www .excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansa ri.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www. excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks Regards, Kiran 9920456606 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7
Re: $$Excel-Macros$$ Excel macro to add VBA password
Hi Don, Thanks for your macro. In my case I need a macro to add Password, Not remove password. Thanks, Krian On Thu, Sep 6, 2012 at 11:50 PM, dguillett1 dguille...@gmail.com wrote: Put in a workbook module to find another file to unlock vba Option Explicit 'Your password goes here Const gszProjPassword As String = hello Public Sub UnlockMe() Dim wbName As Variant Dim wbBook As Workbook Dim vbaProj As Object Dim oWin As Object Dim X As Integer On Error GoTo ErrorHandler 'Select the workbook with the project to unlock wbName = Application.GetOpenFilename(Excel Files (*.xls),*.xls) 'Open it, assign an object ref to it's vba project Set wbBook = Workbooks.Open(wbName) Set vbaProj = wbBook.VBProject 'Close any open code windows For Each oWin In vbaProj.VBE.Windows If InStr(oWin.Caption, () 0 Then oWin.Close Next oWin Application.VBE.MainWindow.Visible = False 'Check to see if the VBA project is already unlocked If vbaProj.Protection 1 Then MsgBox The VBA Project for the file you selected is already unlocked., 0 Exit Sub 'We found the project to be locked ElseIf vbaProj.Protection = 1 Then On Error Resume Next Do While X 4 If vbaProj.Protection 1 Then MsgBox The VBA project for wbName was unprotected successfully, 64 Exit Do End If UnprotectVBProject wbBook, gszProjPassword X = X + 1 Loop On Error GoTo 0 End If ErrorExit: Set wbBook = Nothing Set vbaProj = Nothing Exit Sub ErrorHandler: Select Case Err.Number Case 1004 wbBook.Close False MsgBox You will need to set the _ { TRUST ACCESS TO VISUAL BASIC PROJECT } setting vbNewLine _ When the dialog appears, go to the Trusted Sources tab, _ check the setting, click OK, and rerun this code again, 64 SendKeys %T, True SendKeys M, True SendKeys S, True Case Else MsgBox Err.Description End Select Resume ErrorExit End Sub Public Sub UnprotectVBProject(wb As Workbook, ByVal Password As String) Dim vbProj As Object On Error GoTo ErrorHandler Application.ScreenUpdating = False Set vbProj = wb.VBProject 'Check to see if VBA project is already unlocked If vbProj.Protection 1 Then Exit Sub 'Activate chosen VBA Project Set Application.VBE.ActiveVBProject = vbProj 'SendKeys is the only way If Password = ^^ Or Password = ++ Then Password = Exit Sub ElseIf Right(Password, 2) = ^^ Or Right(Password, 2) = ++ Then Password = Exit Sub Else SendKeys Password ~~ {ESC} Application.VBE.CommandBars(1).FindControl(ID:=2578, recursive:=True).Execute End If 'Not the right password If vbProj.Protection = 1 Then SendKeys %{F11}, True End If 'Reset Password Password = Application.ScreenUpdating = True Set vbProj = Nothing Exit Sub ErrorHandler: MsgBox Err.Description, 64 End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com -Original Message- From: Rajan_Verma Sent: Thursday, September 06, 2012 9:01 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro to add VBA password Where you want to apply Password. 1) File Open ? 2) Worksheet Password ? 3) Workbook Password ? 4) VBA project Password ? Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancharla Sent: 06 September 2012 12:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel macro to add VBA password Hi, thanks a lot your quick responce.. thanks,u kiran On 9/6/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Kiran, Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime under VBE editor. On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kiran, Please try it.. Sub ProtectFiles() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(YourFolderPath) For Each MyFile In MyFolder.Files MyFile.Password=abc Next End Sub On Thu, Sep 6, 2012 at 10:47 AM, Kiran Kancharla srkira...@gmail.comwrote: Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
$$Excel-Macros$$ Excel macro to add VBA password
Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: plz solve problem
Please have a look on the file. I am sure sure abt AHT as u have not provided the remaining details for AHT calculation.. On Fri, Aug 24, 2012 at 12:29 AM, PRAVESH KUMAR praveshkash...@gmail.com wrote: Hi Excel Experts! Could you please solved this question though vb coding. if I select start date and end date then pick-up date from selected date.. it's urgent please Thanks Pravesh Kumar -- Forwarded message -- From: PRAVESH KUMAR praveshkash...@gmail.com Date: Sat, 18 Aug 2012 15:16:40 +0530 Subject: Re: $$Excel-Macros$$ Re: plz solve problem To: excel-macros@googlegroups.com, ms.exl.lear...@gmail.com Hi experts, thank you so much for help and it's working fine. could we pickup data on the date and all program base if we change date and program the pick data selected date with select program plz reply Thanks Pravesh Kumar On 8/18/12, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi Pravesh, Copy and paste the below formula in C15 cell =VLOOKUP($D$2,INDIRECT('$D$3'!$A$1:$E$7),MATCH(C$14,INDIRECT('$D$3'!$A$1:$E$1),0),0) Drag the C15 cell formula to Right upto F15 cell. Hope that helps! --- Ms.Exl.Learner --- On Sat, Aug 18, 2012 at 1:01 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote: Hi experts please solve this problem for the same file attached. Thanks Pravesh Kumar On 8/15/12, PRAVESH KUMAR praveshkash...@gmail.com wrote: Hi All, please find attached file and solve my problem urgent. Thanks Pravesh -- *Thanks Regards* *Pravesh Kumar* -- Thanks Regards Pravesh Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks Regards Pravesh Kumar -- Thanks Regards Pravesh Kumar -- Thanks Regards Pravesh Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and
Re: $$Excel-Macros$$ Saving Photos from webpage
Hi All, Please help me on this. On Wed, Jun 20, 2012 at 10:19 AM, Kiran Kancharla srkira...@gmail.comwrote: Hi Chilexcel, Apologies for delay in response. As suggested by you, I have tried the steps. It require manual interaction of click and download the photos. Experts @ Please create something to make this activity automatic as I have a huge data to download. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 11:29 PM, Kiran Kancharla srkira...@gmail.comwrote: Hi *Chilexcel*, Thanks for your reply. I will check and let you know at the earliest. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 10:35 PM, ChilExcel chilexcel...@gmail.comwrote: Please see attached Used DownThemAll , add on firefox (To use DownThemAll, simply open a Web page in Firefox, click Tools from the toolbar,) and then use Excel Insert Images (Chilexcel) Direct and from Hyperlink http://www.youtube.com/watch?v=B1qUrTKsnGofeature=plcp Chilexcel 2012/6/17 Kiran Kancharla srkira...@gmail.com: Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Kiran 9920456606 -- Thanks Regards, Kiran 9920456606 -- Thanks Regards, Kiran 9920456606 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Saving Photos from webpage
Hi Kuldeep, Thanks for your reply. This macro is not meeting my need. Thanks Regards, Kiran On Wed, Jun 20, 2012 at 5:29 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Sub Test() Dim Sh As Worksheet Dim Rng As Range Dim Cell As Range Set Sh = Worksheets(Sheet1) With Sh Set Rng = .Range(A1:A .Cells(.Rows.Count, A).End(xlUp).Row) End With For Each Cell In Rng ThisWorkbook.FollowHyperlink Cell.Value Next Cell End Sub Regards, Kuldeep Singh Back Office Executive Info Edge India Limited (naukri.com) Phone.: +91-9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Wed, Jun 20, 2012 at 4:56 PM, Kiran Kancharla srkira...@gmail.comwrote: Hi All, Please help me on this. On Wed, Jun 20, 2012 at 10:19 AM, Kiran Kancharla srkira...@gmail.comwrote: Hi Chilexcel, Apologies for delay in response. As suggested by you, I have tried the steps. It require manual interaction of click and download the photos. Experts @ Please create something to make this activity automatic as I have a huge data to download. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 11:29 PM, Kiran Kancharla srkira...@gmail.comwrote: Hi *Chilexcel*, Thanks for your reply. I will check and let you know at the earliest. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 10:35 PM, ChilExcel chilexcel...@gmail.comwrote: Please see attached Used DownThemAll , add on firefox (To use DownThemAll, simply open a Web page in Firefox, click Tools from the toolbar,) and then use Excel Insert Images (Chilexcel) Direct and from Hyperlink http://www.youtube.com/watch?v=B1qUrTKsnGofeature=plcp Chilexcel 2012/6/17 Kiran Kancharla srkira...@gmail.com: Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Kiran 9920456606 -- Thanks Regards, Kiran 9920456606 -- Thanks Regards, Kiran 9920456606 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please
Re: $$Excel-Macros$$ Saving Photos from webpage
Hi All, Is any one interested, if I am *ready to pay * for this task. Please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... If any one interested, please revert back to me.. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 2:55 PM, Kiran Kancharla srkira...@gmail.comwrote: Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Kiran 9920456606 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Saving Photos from webpage
Hi All, thank you very much for your help... please give me some hours time to check and revert back to you.. once agai thanks and god bless you all... regards, kiran On 6/21/12, ChilExcel chilexcel...@gmail.com wrote: Kiran Other solution : use Extreme Picture Finder for extract all image please see attached time used 00:05:05 website www.jabong.com 2\ Chilexcel 2012/6/20 ChilExcel chilexcel...@gmail.com: Don Guillett He , need only all pictures of this website 2012/6/20 dguillett1 dguille...@gmail.com: Application.Workbooks.Open (http://www.jabong.com;) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Kiran Kancharla Sent: Wednesday, June 20, 2012 1:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Saving Photos from webpage Hi All, Is any one interested, if I am ready to pay for this task. Please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... If any one interested, please revert back to me.. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 2:55 PM, Kiran Kancharla srkira...@gmail.com wrote: Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to mailto:excel-macros%2bunsubscr...@googlegroups.com -- Thanks Regards, Kiran 9920456606 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ Saving Photos from webpage
and returning the data direcly to your VBA code to parse or handle as it desires without having to save it to disk first. *All these methods would probably require:* ** i. **Download the HTML page with the search results. **ii. **Parse the HTML file and find the URLs for all the images. ** iii. **Download the images and save to disk. ** ** If you want to hire me, send me an email off list. If you want to try it on your own, see if these tips help you. Come back with any questions that come up, and the group will try to help. ** ** Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kiran Kancharla *Sent:* Wednesday, June 20, 2012 11:06 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Saving Photos from webpage ** ** ** ** Hi All, ** ** Is any one interested, if I am *ready to pay * for this task. ** ** Please help to create a Macro to save images folder. ** ** Below are the requirement: ** ** Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require ** ** I have created macro to navigate the web page and I need help to save the all photos in folder. ** ** Please help me as i have a huge data to download. ** ** I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. ** ** I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose.** ** ** ** Thanks in advance... ** ** If any one interested, please revert back to me.. ** ** Thanks Regards, Kiran ** ** ** ** On Sun, Jun 17, 2012 at 2:55 PM, Kiran Kancharla srkira...@gmail.com wrote: ** ** Hi All, ** ** Request you to please help to create a Macro to save images folder. ** ** Below are the requirement: ** ** Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require ** ** I have created macro to navigate the web page and I need help to save the all photos in folder. ** ** Please help me as i have a huge data to download. ** ** I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. ** ** I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose.** ** ** ** Thanks in advance... -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com ** ** -- Thanks Regards, Kiran 9920456606 ** ** -- 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
Re: $$Excel-Macros$$ Saving Photos from webpage
Hi Chilexcel, Apologies for delay in response. As suggested by you, I have tried the steps. It require manual interaction of click and download the photos. Experts @ Please create something to make this activity automatic as I have a huge data to download. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 11:29 PM, Kiran Kancharla srkira...@gmail.comwrote: Hi *Chilexcel*, Thanks for your reply. I will check and let you know at the earliest. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 10:35 PM, ChilExcel chilexcel...@gmail.comwrote: Please see attached Used DownThemAll , add on firefox (To use DownThemAll, simply open a Web page in Firefox, click Tools from the toolbar,) and then use Excel Insert Images (Chilexcel) Direct and from Hyperlink http://www.youtube.com/watch?v=B1qUrTKsnGofeature=plcp Chilexcel 2012/6/17 Kiran Kancharla srkira...@gmail.com: Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Kiran 9920456606 -- Thanks Regards, Kiran 9920456606 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Translating
Hi All, Thanks for your reply. Thanks Regards, Kiran On Sat, Jun 16, 2012 at 3:19 AM, Asa Rossoff a...@lovetour.info wrote: Good day Kiran, ** ** *To manually translate,* you can go to the Research task pane select Translation select language pair search for a word or phrase. **·**A quick way to get there is to *ALT-Click a cell with text you want to translate* to bring up the Research pane with that text pre-entered in the search box. ** ** *To actually answer your question* re. using a formula or macro -- I have not the experience! **·**BUT, it looks like you can use the RESEARCH object in Excel 2007+ VBA (check the Help, Google, or perhaps someone else here can give you an example) **·**AND, here is a link to some code from Patrick O'Beirne, on his blog, for utilizing the MicrosoftTranslator.com API for free from VBA: https://sysmod.wordpress.com/2012/01/09/microsoft-translator-vba-code-sample/ ** ** Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kiran Kancharla *Sent:* Friday, June 15, 2012 11:44 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Translating ** ** ** ** Hi All, ** ** Request you to please let me know, is there any Inbuilt formula or a Macro to translate words in Excel. ** ** -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Kiran 9920456606 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Saving Photos from webpage
Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Saving Photos from webpage
Hi Chilexcel, Thanks for your reply. I will check and let you know at the earliest. Thanks Regards, Kiran On Sun, Jun 17, 2012 at 10:35 PM, ChilExcel chilexcel...@gmail.com wrote: Please see attached Used DownThemAll , add on firefox (To use DownThemAll, simply open a Web page in Firefox, click Tools from the toolbar,) and then use Excel Insert Images (Chilexcel) Direct and from Hyperlink http://www.youtube.com/watch?v=B1qUrTKsnGofeature=plcp Chilexcel 2012/6/17 Kiran Kancharla srkira...@gmail.com: Hi All, Request you to please help to create a Macro to save images folder. Below are the requirement: Step 1: Navigating the website : http://www.jabong.com/ - Macro Done Step 2 : Search for product : WR138MA56HVN - Macro Done Step 3 : Select Photos and download the photos in the specified location. - Macro Require I have created macro to navigate the web page and I need help to save the all photos in folder. Please help me as i have a huge data to download. I have tried in google, unfortunately I am getting all the macro's to download only 1 photo, in my current need I have to download all the photos. I can use any type of explorer ie, chrome, firefox or any. Note : The website (http://www.jabong.com/)is only for example purpose. Thanks in advance... -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Kiran 9920456606 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Translating
Hi All, Request you to please let me know, is there any Inbuilt formula or a Macro to translate words in Excel. -- Thanks Regards, Kiran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.
Hi Ayush, Agree with your New rule. As a second thougt, is this ok if people send information about relevant postings? I mean about MIS, WFM, VBA development jobs... these are very help for those, who are sarchig jobs and searching for candidates... Please consider this as a suggistion On 5/20/12, Ayush Jain jainayus...@gmail.com wrote: Hello everyone, There is sudden increase in job posts and more than half of all job posts are irrelevent not related to excel. I have decided not to allow any jobs whether related to excel or not. *This is not employment forum and intended to help on excel queries only.* Anyone found posting jobs will be banned without any warning. Let me know if you have any questions. Regards Ayush Jain Group Manager and Microsoft MVP -- 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 -- Sent from my mobile device Thanks Regards, Kiran 9920456606 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Formula for Unique Values with Condition
Hi All, In the attached file I have names of the people who left the company. I need a formula to Extract the names of the Team Leader's and Team Manager's, where in Column C have Agent. I mean, I want to get only those Names, where they have attrition for Agent Request you to please help me with a Formula not a Macro.. -- Thanks Regards, Kiran -- 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 Unique.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: Formula for Unique Values with Condition
* * * * Hi Noorain/Haseeb, Perfect answers. This is what I was looking for... Thanks... Kiran On Thu, Mar 29, 2012 at 9:06 AM, Haseeb A haseeb.avarak...@gmail.comwrote: Hello Kiran, In G4 with CTRL+SHIFT+ENTER, rather than just ENTER =IFERROR(INDEX(D$2:D$498,MATCH(1,IF(ISNA(MATCH(D$2:D$498,G$3:G3,0)),IF($C$2:$C$498=Agent,1)),0)),) Then copy across down. if you have huge list, this will slow down the sheet performance. ___ HTH, Haseeb -- 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, Kiran 9920456606 -- 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$$ Pivot uncheck All
Hi All, Below is the Macro I have recorded for unchecking the Pivot Table. ActiveSheet.PivotTables(PivotTable2).PivotFields(Month).CurrentPage = (All) With ActiveSheet.PivotTables(PivotTable2).PivotFields(Month) .PivotItems(Jan).Visible = False .PivotItems(Feb).Visible = True End With In the real case I have More than the 500 points to uncheck. I need macro to uncheck all selected in Pivot table and select only 1. I have a separate macro to Select the required point. Please help. I cannot attach the sheet as it has client information. -- Thanks Regards, Kiran -- 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$$ Pivot uncheck All
Thanks a lot. Will update you tomorrow on this.. Thanks, Kiran On Sun, Feb 26, 2012 at 11:57 PM, xlstime xlst...@gmail.com wrote: you can use ActiveSheet.PivotTables(PivotTable1).ClearAllFilters At the top of the window, on the Ribbon, click the *Options* tab under *PivotTable Tools*. In the *Actions* group, click *Clear*, and then click *Clear Filters*. Be sure you really want to do this before you undo all your selections. On Sun, Feb 26, 2012 at 11:45 PM, Kiran Kancharla srkira...@gmail.comwrote: Hi All, Below is the Macro I have recorded for unchecking the Pivot Table. ActiveSheet.PivotTables(PivotTable2).PivotFields(Month).CurrentPage = (All) With ActiveSheet.PivotTables(PivotTable2).PivotFields(Month) .PivotItems(Jan).Visible = False .PivotItems(Feb).Visible = True End With In the real case I have More than the 500 points to uncheck. I need macro to uncheck all selected in Pivot table and select only 1. I have a separate macro to Select the required point. Please help. I cannot attach the sheet as it has client information. -- Thanks Regards, Kiran -- 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 -- Thanks Regards, Kiran 9920456606 -- 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$$ Excel Macro to navigate IE
Hi Asa, I agree with you. Excel can extract Web query. In my current requirement i don't have a constant URL to download the data. Like www.Google.com - Calender - (My case URL is only one) These kind of URLS I have. The Macro need to open IE click on Specified links and copy the data to Excel. Thanks Regards, Kiran On Thu, Feb 2, 2012 at 6:25 AM, Asa Rossoff a...@lovetour.info wrote: Hello Kiran, Have you considered the approach of using web queries? Excel can automatically retrieve data from URLs that contain tables or XML/RSS and put it in a worksheet. Excel can also automatically refresh the data from the web on a set schedule if desired. The feature works in all version of Excel since Excel 97 (with some limitations to support in Excel 2008 on the Mac). *Here are some links with more information:* **·**http://www.mrexcel.com/tip103.shtml **·**http://www.exceluser.com/explore/webqueries_1.htm **·**http://www.vertex42.com/News/excel-web-query.html http://dancingpenguinsoflight.com/2010/07/excel-web-query-urls-with-dynamic-parameters/ **·** http://blogs.office.com/b/microsoft-excel/archive/2009/07/31/using-parameters-with-web-queries.aspx ** ** Asa ** ** -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancherla Sent: Wednesday, February 01, 2012 8:58 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel Macro to navigate IE ** ** ** ** Hi All, ** ** If any of have Macro ''click'' or ''navigate'' internet explorer... ** ** My requirement is to click 3 hyper links and copy the data to Excel*** * ** ** I have tried googling it.. But no luck.. ** ** Sent on my BlackBerry® from Vodafone Thanks Regards. Kiran ** ** -- 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 -- Thanks Regards, Kiran 9920456606 -- 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$$ Attendance Tracker
Hi All, Request you to please share, If you have any tool or tracker for Maintain the attendance for a Team of 15 People Thanks in advance -- Thanks Regards, Kiran -- FORUM RULES (934+ 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$$ Like pivot table function
Any special reason for not using Sumif/ like : =SUMIF(A:B,H2,B:B) On Thu, Aug 11, 2011 at 7:34 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Can you please explain it more, Do you want to Extract three Record which total is ? -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of naresh v Sent: Thursday, August 11, 2011 7:28 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Like pivot table function Hi friends, I have attached one excel, can you please help me .. Regards, Naresh V -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, Kiran 9920456606 -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive
Hi Anil, Follow the below steps. Open the file click the below following steps File Properties - Summary - and Uncheck the Save Preview Picture Regards, Kiran On Fri, Jun 3, 2011 at 3:18 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi members, My excel file icon got changed and shows the internal data instead of standard excel image I wanted the standard excel image as my file view and not the internal data image… please help Thanks Regards, Anil Bhange IP - 512320 -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, Kiran 9920456606 -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel image001.jpgimage002.jpg
Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
Hi Raj, the option is avaliable in all the versions of 2003 and later. which one you are using??? Thanks Regards, Kiran On 1/3/11, Raj Mahapatra rajafs...@gmail.com wrote: hi friends, please help on my below querry. Thanks On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Sent from my mobile device -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$
Simply u can use Find and replace. On Thu, Dec 23, 2010 at 3:48 PM, Rajiv Kumar xlraja...@gmail.com wrote: Dear sir how can sum with rupees simbol. It yes then please give me tips. Awating your positive replay… Raj -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Missing Entries
Have u tried using Vlookup? On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain vebhav.j...@gmail.com wrote: Hi All, Please help me in finding the missing entries from the below data. ListA ListB 1 1 2 3 3 5 4 5 Regards Vebhav Jain -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Problem regarding sum
In th cells do u have formatting or value like Rs. 5.00 If it is the Formatting then u can do directly or if it is the value u need use Find formula On Thu, Dec 16, 2010 at 11:06 PM, santanu_ca santanu...@gmail.com wrote: I want to Add two digit or multiply as this way. Column A Column B Rs. 5.00 Rs. 10.00 = Can I sum two cells by formula ? Rs. 5.00 Rs. 10.00 = Can I multiply Two Cells by formula ? -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Zooming of Excel Sheet.
U need to change the options. Tool --- Options -- General Zoom on roll with Intellimouse This has to Uncheck. please try and let me know. On Tue, Nov 23, 2010 at 10:42 AM, C.G.Kumar kumar.bemlmum...@gmail.com wrote: Is it not possible that MS Excel control has changed. On Tue, Nov 23, 2010 at 10:09 AM, Gangaram. sgang...@gmail.com wrote: possibility is Your keyboard control button might be malfunctioning or Accidently CTRL key got struck and kept pressed. Check it out. On Nov 22, 11:14 pm, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Check whether your cntrl button is working. Ms-Exl-Learner On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote: Dear All, When i am using scroll wheel of mouse my excel sheet gets Zoom In (Moving Forward) Zoom out ( (Moving Backward). Earlier this function worked when i press ctrl+scroll of mouse. I prefer earlier control and intend to scroll with my mouse the excel sheet instead of ZOOM option. Can any body tell me how to rectify. Regards, C.G.Kumar -- -- 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. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- --- Ms.Exl.Learner --- -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- Regards, C.G.Kumar -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts