$$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.
$$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 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 wrote: > >> >> 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
$$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 wrote: > 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
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 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$$ 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$$ Translating
Hi All, Thanks for your reply. Thanks & Regards, Kiran On Sat, Jun 16, 2012 at 3:19 AM, Asa Rossoff 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 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=B1qUrTKsnGo&feature=plcp > > > > Chilexcel > > > > 2012/6/17 Kiran Kancharla : > > > > 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
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 wrote: > 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 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=B1qUrTKsnGo&feature=plcp >> >> >> >> Chilexcel >> >> >> >> 2012/6/17 Kiran Kancharla : >> > >> > 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, > Kira
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 wrote: > 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 wrote: > >> 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 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=B1qUrTKsnGo&feature=plcp >>> >>> >>> >>> Chilexcel >>> >>> >>> >>> 2012/6/17 Kiran Kancharla : >>> > >>> > 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,
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 wrote: > > 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 wrote: > >> Hi All, >> >> Please help me on this. >> >> >> >> >> >> On Wed, Jun 20, 2012 at 10:19 AM, Kiran Kancharla wrote: >> >>> 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 >>> wrote: >>> >>>> 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 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=B1qUrTKsnGo&feature=plcp >>>>> >>>>> >>>>> >>>>> Chilexcel >>>>> >>>>> >>>>> >>>>> 2012/6/17 Kiran Kancharla : >>>>> > >>>>> > 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 q
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 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 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 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 : >> Don Guillett >> >> He , need only all pictures of this website >> >> >> >> 2012/6/20 dguillett1 : >>> 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 >>> 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. >>>> >>>> >>>> -
Re: $$Excel-Macros$$ Saving Photos from webpage
omation example using WinHttpRequest is available from >> Microsoft at >> http://msdn.microsoft.com/en-us/library/aa384072%28VS.85%29.aspx (Some >> of the instructions relate to the Visual Basic IDE, but are not critical. >> The essence of the article applies to VBA.) >> >> **f. **Automation examples using XMLHTTP as well as WinHttpRequest >> are available from >> http://www.motobit.com/tips/detpg_read-write-binary-files/ (see section >> 3). >> >> **g. **There are InternetExplorer and WebBrowser automation >> controls. >> >> **h. **There is URLMon, part of the Internet Explorer API. It has >> functions such as URLDownloadToFile (download a URL to disk) and >> URLOpenPullstream or URLOpenBlockingStream which are approriate for >> downloading files 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 >> 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
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 wrote: > Is it not possible that MS Excel control has changed. > > > On Tue, Nov 23, 2010 at 10:09 AM, Gangaram. 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 ." >> wrote: >> > Check whether your cntrl button is working. >> > >> > >> > Ms-Exl-Learner >> > >> > >> > On Mon, Nov 22, 2010 at 10:52 AM, C.G.Kumar >> > wrote: >> > >> > >> > >> > > 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=wall&ref=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=wall&ref=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=wall&ref=ts
Re: $$Excel-Macros$$ Missing Entries
Have u tried using Vlookup? On Thu, Dec 16, 2010 at 11:06 PM, vebhav jain 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=wall&ref=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=wall&ref=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 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=wall&ref=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=wall&ref=ts
Re: $$Excel-Macros$$
Simply u can use Find and replace. On Thu, Dec 23, 2010 at 3:48 PM, Rajiv Kumar 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=wall&ref=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=wall&ref=ts
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 wrote: > hi friends, > > please help on my below querry. > > Thanks > > On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra 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=wall&ref=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=wall&ref=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=wall&ref=ts
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 <><>
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 wrote: > 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$$ 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 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 > 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 . 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 >>> wrote: >>> Hi experts please solve this problem for the same file attached. Thanks Pravesh Kumar On 8/15/12, PRAVESH KUMAR 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
$$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$$ Excel macro to add VBA password
Hi, thanks a lot your quick responce.. thanks, kiran On 9/6/12, NOORAIN ANSARI 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 > wrote: > >> 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 >> wrote: >> >>> 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.com>noorainansari.com<http://www.noorainansari.com> >> http:// >> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/> >> >> >> > > > -- > With Regards, > Noorain Ansari > http:// > <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> > http:// > <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.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) 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 --
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 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 > wrote: > >> 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 >>> wrote: >>> >>>> 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 >>>>>>> >>>>>> > wrote: >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> thanks a lot your quick responce.. >>>>>>>> >>>>>>>> thanks, >>>>>>>> kiran >>>>>>>> >>>>>>>> On 9/6/12, NOORAIN ANSARI 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 >>>>>>>> > wrote: >>>>>>>> > >>>>>>>> >> 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 >>>>>>>> >> >>>>>>&g
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 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 > 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 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 >> > wrote: >> > >> >> 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 >> >>> wrote: >> >>> >> >>>> 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 >> >>>>>>> > >>>>>>> > wrote: >> >>>>>>> >> >>>>>>>> Hi, >> >>>>>>>> >> >>>>>>>> thanks a lot your quick responce.. >> >>>>>>>> >> >>>>>>>> thanks, >> >>>>>>>> kiran >> >>>>>>>> >> >>>>>>>> On 9/6/12, NOORAIN ANSARI wrote: >> >>>>>>>> > Kiran, >> >>>>>
Re: $$Excel-Macros$$ Excel macro to add VBA password
4. vba protecion password On 9/6/12, Rajan_Verma 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 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 >> wrote: >> >>> 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 >>> wrote: >>> >>>> 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.com>noorainansari.com<http://www.noorainans >>> ari.com> >>> http:// >>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www >>> .excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/> >>> >>> >>> >> >> >> -- >> With Regards, >> Noorain Ansari >> http:// >> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansa >> ri.com> >> http:// >> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.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 >> P
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 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 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 >> wrote: >> >>> Dear Kiran, >>> >>> Please try it.. >>> >>> >>&
$$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$$ 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 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