Re: $$Excel-Macros$$ NEED MACRO FOR CITRIX
Any macro man in this group know how to write code to access the application inside citrix. On 12-Feb-2018 7:58 PM, "suresh k" wrote: > Hi All, > > Anyone knows how to write macro to activate applications inside citric. > > Let me know if any useful links on same. > > Regards > Suresh > > -- > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ NEED MACRO FOR CITRIX
Hi All, Anyone knows how to write macro to activate applications inside citric. Let me know if any useful links on same. Regards Suresh -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: Macros for screenshot
Experts any inputs for the below requirement? On 23-Mar-2017 1:43 pm, "suresh k" wrote: > Hi All, > > I have 10 files in my c drive. I have to capture other applications > screenshot and paste in all 10 files. > > I am able to capture screenshot, but not able to paste in 10 excel file. > > Please suggest macro to paste screenshot in all files > > Regards, > Suresh > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Macros for screenshot
Hi All, I have 10 files in my c drive. I have to capture other applications screenshot and paste in all 10 files. I am able to capture screenshot, but not able to paste in 10 excel file. Please suggest macro to paste screenshot in all files Regards, Suresh -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Study material for LOOPS
Dear Experts, Anyone having study material for learning all kinds of LOOPS. Please do forward. Many thanks. /Suresh -- 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Access other applications using macro's
Hi Ravinder, Any update on the error. On Tue, Feb 4, 2014 at 11:25 PM, suresh k wrote: > I tried, same keys in sap also. > > In my case(macro) i have to navigate couple of times within sap and excel. > But using this macro, once the cursor moves to excel, again it is not > coming back to sap to perform pending steps. > > Is there any variable that i can declare to activate sap and excel. > > > On Tue, Feb 4, 2014 at 11:55 AM, Ravinder wrote: > >> Pls use this as referencethis will open word application and paste >> value from excel to word using send key. You can use send key as per your >> requirement (put send key for all key which u use manually.) >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *suresh k >> *Sent:* Tuesday, February 04, 2014 11:29 AM >> >> *To:* Excel group >> *Subject:* Re: $$Excel-Macros$$ Access other applications using macro's >> >> >> >> Hi, >> >> I need macro for the following cases. >> >> >> >> Case 1: I have the list of document numbers in excel where I will paste >> those in SAP application. Now I am picking this data manually everyday. If >> I enter one document number in SAP I am getting the data for it, in same >> way I have to download data for atleast 100 documents numbers. >> >> Since I have list of documents already listed in excel, thinking to >> automate. So that I can get the relevant data for 100 documents in one shot. >> >> >> >> Case2: I have to download data from one website everyday. It's the same >> as above. In this scenario I will paste the document number one by one in a >> website instead of SAP. >> >> >> >> >> >> On Tue, Feb 4, 2014 at 11:13 AM, Ravinder >> wrote: >> >> Please advise what u want exactly >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *suresh k >> *Sent:* Tuesday, February 04, 2014 11:10 AM >> *To:* Excel group >> *Subject:* Re: $$Excel-Macros$$ Access other applications using macro's >> >> >> >> Hi, >> >> >> >> Waw.. Its working.. but its only opening, not able to click on "File", >> "Edit" etc.., >> >> >> >> >> >> >> >> On Tue, Feb 4, 2014 at 11:02 AM, Ravinder >> wrote: >> >> You can use shell command in vba >> >> >> >> Sub openotherapp() >> >> >> >> Shell *"C:\Program Files\Internet Explorer\iexplore.exe"*, >> vbNormalFocus 'path of exe file of IE, u can use same for SAP (put exe >> filepath) >> >> End Sub >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *suresh k >> *Sent:* Tuesday, February 04, 2014 10:56 AM >> *To:* Excel group >> *Subject:* $$Excel-Macros$$ Access other applications using macro's >> >> >> >> Dear Experts, >> >> >> >> Can anyone help on my query. >> >> >> >> I have to activate and other applications like Internet explorer, SAP >> etc.., through writing macro. >> >> >> >> Is this possible? >> >> >> >> /Suresh >> >> >> >> -- >> 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
Re: $$Excel-Macros$$ Access other applications using macro's
I tried, same keys in sap also. In my case(macro) i have to navigate couple of times within sap and excel. But using this macro, once the cursor moves to excel, again it is not coming back to sap to perform pending steps. Is there any variable that i can declare to activate sap and excel. On Tue, Feb 4, 2014 at 11:55 AM, Ravinder wrote: > Pls use this as referencethis will open word application and paste value > from excel to word using send key. You can use send key as per your > requirement (put send key for all key which u use manually.) > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesday, February 04, 2014 11:29 AM > > *To:* Excel group > *Subject:* Re: $$Excel-Macros$$ Access other applications using macro's > > > > Hi, > > I need macro for the following cases. > > > > Case 1: I have the list of document numbers in excel where I will paste > those in SAP application. Now I am picking this data manually everyday. If > I enter one document number in SAP I am getting the data for it, in same > way I have to download data for atleast 100 documents numbers. > > Since I have list of documents already listed in excel, thinking to > automate. So that I can get the relevant data for 100 documents in one shot. > > > > Case2: I have to download data from one website everyday. It's the same as > above. In this scenario I will paste the document number one by one in a > website instead of SAP. > > > > > > On Tue, Feb 4, 2014 at 11:13 AM, Ravinder > wrote: > > Please advise what u want exactly > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesday, February 04, 2014 11:10 AM > *To:* Excel group > *Subject:* Re: $$Excel-Macros$$ Access other applications using macro's > > > > Hi, > > > > Waw.. Its working.. but its only opening, not able to click on "File", > "Edit" etc.., > > > > > > > > On Tue, Feb 4, 2014 at 11:02 AM, Ravinder > wrote: > > You can use shell command in vba > > > > Sub openotherapp() > > > > Shell *"C:\Program Files\Internet Explorer\iexplore.exe"*, > vbNormalFocus 'path of exe file of IE, u can use same for SAP (put exe > filepath) > > End Sub > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesday, February 04, 2014 10:56 AM > *To:* Excel group > *Subject:* $$Excel-Macros$$ Access other applications using macro's > > > > Dear Experts, > > > > Can anyone help on my query. > > > > I have to activate and other applications like Internet explorer, SAP > etc.., through writing macro. > > > > Is this possible? > > > > /Suresh > > > > -- > 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. > For more options, visit https://groups.google.com/groups/opt_out. > > -- > 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 que
Re: $$Excel-Macros$$ Access other applications using macro's
Hi, I need macro for the following cases. Case 1: I have the list of document numbers in excel where I will paste those in SAP application. Now I am picking this data manually everyday. If I enter one document number in SAP I am getting the data for it, in same way I have to download data for atleast 100 documents numbers. Since I have list of documents already listed in excel, thinking to automate. So that I can get the relevant data for 100 documents in one shot. Case2: I have to download data from one website everyday. It's the same as above. In this scenario I will paste the document number one by one in a website instead of SAP. On Tue, Feb 4, 2014 at 11:13 AM, Ravinder wrote: > Please advise what u want exactly > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesday, February 04, 2014 11:10 AM > *To:* Excel group > *Subject:* Re: $$Excel-Macros$$ Access other applications using macro's > > > > Hi, > > > > Waw.. Its working.. but its only opening, not able to click on "File", > "Edit" etc.., > > > > > > > > On Tue, Feb 4, 2014 at 11:02 AM, Ravinder > wrote: > > You can use shell command in vba > > > > Sub openotherapp() > > > > Shell *"C:\Program Files\Internet Explorer\iexplore.exe"*, > vbNormalFocus 'path of exe file of IE, u can use same for SAP (put exe > filepath) > > End Sub > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesday, February 04, 2014 10:56 AM > *To:* Excel group > *Subject:* $$Excel-Macros$$ Access other applications using macro's > > > > Dear Experts, > > > > Can anyone help on my query. > > > > I have to activate and other applications like Internet explorer, SAP > etc.., through writing macro. > > > > Is this possible? > > > > /Suresh > > > > -- > 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. > For more options, visit https://groups.google.com/groups/opt_out. > > -- > 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. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Re: $$Excel-Macros$$ Access other applications using macro's
Hi, Waw.. Its working.. but its only opening, not able to click on "File", "Edit" etc.., On Tue, Feb 4, 2014 at 11:02 AM, Ravinder wrote: > You can use shell command in vba > > > > Sub openotherapp() > > > > Shell *"C:\Program Files\Internet Explorer\iexplore.exe"*, > vbNormalFocus 'path of exe file of IE, u can use same for SAP (put exe > filepath) > > End Sub > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *suresh k > *Sent:* Tuesday, February 04, 2014 10:56 AM > *To:* Excel group > *Subject:* $$Excel-Macros$$ Access other applications using macro's > > > > Dear Experts, > > > > Can anyone help on my query. > > > > I have to activate and other applications like Internet explorer, SAP > etc.., through writing macro. > > > > Is this possible? > > > > /Suresh > > > > -- > 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. > For more options, visit https://groups.google.com/groups/opt_out. > > -- > 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. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Access other applications using macro's
Dear Experts, Can anyone help on my query. I have to activate and other applications like Internet explorer, SAP etc.., through writing macro. Is this possible? /Suresh -- 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. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Sum query
Hi All, I have attached my query regarding sum function query I know this can be solved through pivot table, but I want the result in formulaes. Pls let me know if anyone can solve this? /Suresh -- 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. For more options, visit https://groups.google.com/groups/opt_out. Sum function query.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Save excel with date
Hi, I am trying to save excel file using macro.. The file name should be my name followed by today's date. Is there any macro for this? /Suresh -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Very tuff macro
Hi Mahesh,
Thanks for your reply.
I have added extra numbers below that. And this macro is not accepting.
And also is it possible to make the matching cells as one color instead of
moving to next column.
/Suresh
On Thu, Sep 29, 2011 at 1:19 AM, Mahesh parab wrote:
> Hi Suresh
>
> find attach
>
> Try :
> Sub Mtest()
> Dim Rng1 As Range, cell As Range, cell2 As Range
> Dim Temp As Variant
> Dim Sum As String
> Dim i As Integer
> Set Rng1 = Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row)
> For Each Temp In Range("B1:B" & Cells(Rows.Count, 2).End(xlUp).Row)
> On Error Resume Next
> For Each cell In Rng1
> For i = 1 To Rng1.Cells.Count
> Set cell2 = Rng1.Cells(i)
> Sum = (cell.Value + cell2.Value)
> If Sum = Temp Then
> If cell.Address <> cell2.Address Then
> cell.Copy Destination:=Sheets("Sheet2").Range("F" &
> Rows.Count).End(xlUp).Offset(1)
> cell.ClearContents
> cell2.Copy Destination:=Sheets("Sheet2").Range("F" &
> Rows.Count).End(xlUp).Offset(1)
> cell2.ClearContents
> 'cell.Cut Destination:=Sheets("Sheet2").Range("F" &
> Rows.Count).End(xlUp).Offset(1)
> 'cell2.Cut Destination:=Sheets("Sheet2").Range("G" &
> Rows.Count).End(xlUp).Offset(1)
> Temp.Cut Destination:=Sheets("Sheet2").Range("E" &
> Rows.Count).End(xlUp).Offset(1)
> End If
> End If
> Next i
> Columns("A").SpecialCells(xlCellTypeBlanks).Delete shift:=xlShiftUp
> Next cell
> Next Temp
> End Sub
>
>
> HTH
> Mahesh
>
> On Wed, Sep 28, 2011 at 9:01 PM, suresh k wrote:
>
>> Hi All,
>>
>> Any macro man can help me on this.
>>
>> I have attached the excel with my query.
>>
>> /Suresh
>>
>> --
>>
>> --
>> 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
Re: $$Excel-Macros$$ Very tuff macro
Hi Sam, Thanks for your reply. Once the cells in Column A match towards Column B should not consider for second time. For eg: 3 & 5 is already matched with 8 in column B. so these cells should not come for next calculation. /Suresh On Wed, Sep 28, 2011 at 9:04 PM, Sam Mathai Chacko wrote: > what about 6 and 3 as a match for 9 > > > On Wed, Sep 28, 2011 at 9:01 PM, suresh k wrote: > >> Hi All, >> >> Any macro man can help me on this. >> >> I have attached the excel with my query. >> >> /Suresh >> >> -- >> >> -- >> 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 >> > > > > -- > Sam Mathai Chacko > > -- > > -- > 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
$$Excel-Macros$$ Very tuff macro
Hi All, Any macro man can help me on this. I have attached the excel with my query. /Suresh -- -- 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 Reconciliation Query.xls Description: MS-Excel spreadsheet
Fwd: $$Excel-Macros$$ Re: Marquee in Excel
Hi All, Anyone is there to provide solution for this query.. Is it possible to work on other worksheet while markquee is there in sheet1. /suresh -- Forwarded message -- From: suresh k Date: Wed, Sep 7, 2011 at 10:39 PM Subject: Re: $$Excel-Macros$$ Re: Marquee in Excel To: rajanverma1...@gmail.com Hi Rajan, This is really good.. Is it possible to do some other work while the text is moving?? /Suresh On Sat, Apr 2, 2011 at 10:27 AM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Thanks Rajan, > > ** ** > > But is it possible.. while the text is moving can we able to work on that > work book… > > ** ** > > Actually I want to use this in my Dashboard where I can show the highlights > of the month as moving text… > > ** ** > > Something similar to BSE / NSE website. > > ** ** > > Regards,Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *rajan verma > *Sent:* Friday, April 01, 2011 7:32 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Re: Marquee in Excel > > ** ** > > Hi , > > Try this code in attached File > > ** ** > > On Fri, Apr 1, 2011 at 2:18 PM, vijayKumar wrote: > > > Hi.. > > > >Please guide how to use this file.. i'm getting a error when i open the > file.. > > Screenshoot of error attached,, > > > > > > On Fri, Apr 1, 2011 at 2:03 PM, ashish koul wrote: > > > try this its code is written by "*Andy Pope" - MVP Excel* > > > > ** ** > > On Fri, Apr 1, 2011 at 1:03 PM, Anil Bhange < > anil.bha...@tatacommunications.com> wrote: > > Hi Ashish, > > > > You have any worksheet where we get moving text (marquee kind of stuffs).. > > > > > If you has please share the excel file please. > > > > Thanks & Regards, > > > > Anil Bhange > > IP - 512320 > > > > > > > -- > > *Regards* > > * * > > *Ashish Koul* > > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > > *akoul*.wordpress.com <http://akoul.wordpress.com/> > > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>*** > * > > > > P Before printing, think about the environment. > > > > ** ** > > -- > > -- > 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 > > > > > > -- > Vijay > > ** ** > > -- > > -- > 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 > > > > > -- > Regards > Rajan verma > +91 9158998701 > > -- > > -- > 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 &g
Re: $$Excel-Macros$$ Formula required
Hi All, Thanks for all your inputs. Now I am able to consolidate my data very easily Regards, Suresh On Sat, Feb 6, 2010 at 3:45 PM, Dilip Pandey wrote: > Dear Suresh, > > Attached is the solved file as per your requirements. > Let me know if this solves your purpose. > > Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B Com(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > On 2/5/10, suresh k wrote: >> >> Hi Sanjay, >> >> Pls find sample file and let me know if you could help me on this. >> >> >> >> On Fri, Feb 5, 2010 at 4:09 PM, Sanjoy Nath wrote: >> >>> Please give the file attached >>> I will make it for you. >>> >>> >>> >>> On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote: >>> >>>> Hi, >>>> >>>> I have the very large data to consolidate. To consolidate I need a >>>> formula. >>>> >>>> Below is the example. >>>> >>>> My Input data will be >>>> >>>> *Input* >>>> Hari >>>> Yes >>>> Hari >>>> No >>>> Hari >>>> Yes >>>> Hari >>>> No >>>> Hari >>>> No >>>> Girish >>>> Yes >>>> Girish >>>> No >>>> Girish >>>> Yes >>>> Girish >>>> Yes >>>> Girish >>>> Yes >>>> Girish >>>> No >>>> Girish >>>> No >>>> >>>> >>>> And output data should be >>>> >>>>*Output* Yes No Hari 2 3 Girish 4 3 >>>> >>>> If anyone know this, pls let me know >>>> >>>> >>>> >>>> -- >>>> >>>> -- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>> http://www.excelitems.com >>>> 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 >>>> If you find any spam message in the group, please send an email to: >>>> Ayush Jain @ jainayus...@gmail.com >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> HELP US GROW !! >>>> >>>> We reach over 6,700 subscribers worldwide and receive many nice notes >>>> about the learning and support from the group.Let friends and co-workers >>>> know they can subscribe to group at >>>> http://groups.google.com/group/excel-macros/subscribe >>>> >>> >>> >>> >>> >>> -- >>> Your Sincerely >>> Sanjoy Nath >>> Engineer >>> EOL Gurgaon >>> EOL/M/NZ/Engg.Dept.(Haryana Division) >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 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 >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,700 subscribers worldwide and receive many nice notes >>> about the learning an
Re: $$Excel-Macros$$ Formula required
Hi Sanjay, Pls find sample file and let me know if you could help me on this. On Fri, Feb 5, 2010 at 4:09 PM, Sanjoy Nath wrote: > Please give the file attached > I will make it for you. > > > > On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote: > >> Hi, >> >> I have the very large data to consolidate. To consolidate I need a >> formula. >> >> Below is the example. >> >> My Input data will be >> >> *Input* >> Hari >> Yes >> Hari >> No >> Hari >> Yes >> Hari >> No >> Hari >> No >> Girish >> Yes >> Girish >> No >> Girish >> Yes >> Girish >> Yes >> Girish >> Yes >> Girish >> No >> Girish >> No >> >> >> And output data should be >> >>*Output* Yes No Hari 2 3 Girish 4 3 >> >> If anyone know this, pls let me know >> >> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 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 >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > > -- > Your Sincerely > Sanjoy Nath > Engineer > EOL Gurgaon > EOL/M/NZ/Engg.Dept.(Haryana Division) > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe test data.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Formula required
Hi, I have the very large data to consolidate. To consolidate I need a formula. Below is the example. My Input data will be *Input* Hari Yes Hari No Hari Yes Hari No Hari No Girish Yes Girish No Girish Yes Girish Yes Girish Yes Girish No Girish No And output data should be *Output* Yes No Hari 2 3 Girish 4 3 If anyone know this, pls let me know -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Hide and unhide option
Dear Excel masters, Anyone know this solution or not? On Tue, Dec 1, 2009 at 1:12 PM, suresh k wrote: > Hi Excel masters, > > I have created a macro for maintaining attendance. > > In sheet 1 i have created a box, If i select Jan. It should go to 2nd sheet > and should show only those columns and rows. > And remaining all lines should be hided. But it is not working. > > Any suggestions,,, > > Many thanks > > Regards, > Suresh > > -- > > -- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Hide and unhide option
Hi Excel masters, I have created a macro for maintaining attendance. In sheet 1 i have created a box, If i select Jan. It should go to 2nd sheet and should show only those columns and rows. And remaining all lines should be hided. But it is not working. Any suggestions,,, Many thanks Regards, Suresh -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Hide and unhide.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Userform for 10 secs
Hi Harmeet,
thank you. Now its working.
I was using useform activate function. Thats y it was not working.
Anyways thank you so much for your help.
On Mon, Sep 14, 2009 at 9:17 AM, Harmeet Singh wrote:
> *Created a file for ur ease**see attached file..*
>
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
> On Mon, Sep 14, 2009 at 8:12 AM, suresh k wrote:
>
>> Hi Harmeet,
>>
>> Thanks for your reply.
>>
>> In this case, after running the userform. I need to click on that. And the
>> time will count from that time.
>> So If I dont click anywhere, it will not close.
>>
>> Any suggestions..
>>
>> Regards,
>> Suresh
>>
>>
>> On Sat, Sep 12, 2009 at 2:42 AM, Harmeet Singh
>> wrote:
>>
>>> Below code may help u
>>>
>>> *Sub um()*
>>> *If Application.Wait(Now + TimeValue("0:00:10")) Then*
>>> *MsgBox "Time expired" ' or write "Unload Me" here*
>>> *End If*
>>> *End Sub*
>>>
>>>
>>> Thanks & Regards,
>>>
>>> Harmeet Singh
>>>
>>> Sent via BlackBerry Wireless
>>>
>>>
>>> On Fri, Sep 11, 2009 at 10:23 AM, suresh k wrote:
>>>
>>>> Hi,
>>>>
>>>> I have created Userform which will open when the excel sheet opens, but
>>>> how to keep it only for 10 secs.
>>>> After 10 seconds it should close automatically.
>>>>
>>>> Any macro code for that??
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>>
>
> >
>
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Userform for 10 secs
Hi Harmeet,
Thanks for your reply.
In this case, after running the userform. I need to click on that. And the
time will count from that time.
So If I dont click anywhere, it will not close.
Any suggestions..
Regards,
Suresh
On Sat, Sep 12, 2009 at 2:42 AM, Harmeet Singh wrote:
> Below code may help u
>
> *Sub um()*
> *If Application.Wait(Now + TimeValue("0:00:10")) Then*
> *MsgBox "Time expired" ' or write "Unload Me" here*
> *End If*
> *End Sub*
>
>
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
> On Fri, Sep 11, 2009 at 10:23 AM, suresh k wrote:
>
>> Hi,
>>
>> I have created Userform which will open when the excel sheet opens, but
>> how to keep it only for 10 secs.
>> After 10 seconds it should close automatically.
>>
>> Any macro code for that??
>>
>>
>>
>>
>
> >
>
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Userform for 10 secs
Hi, I have created Userform which will open when the excel sheet opens, but how to keep it only for 10 secs. After 10 seconds it should close automatically. Any macro code for that?? --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Count if i appreciate if do this ASAP
Hi Amresh, You can use CONCATENATE function for your query. Attached is the solution. On Thu, Sep 3, 2009 at 2:30 PM, amresh kumar wrote: > Hi My All Friends, > > Please find the attached file i want count working days absent date and > half day of employee > > Please let me know if any doubts. > > Special request to Dilip > > Regard > Amresh > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Copy of Sheet - By Brave suresh.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Macro for copying all data
Hi, Is there any macro for copying all the data from 20 different excel file to a single master file. Plz let me know. Thanks & Regards, Suresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Advanced conditional formatting
Hi Dilip, Can you check this attachment. Its having three options "TRUE", "FALSE" and "Not available. In this case is it possible to highlight entire rows in different color based on the result. On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey wrote: > Hi Suresh. > > Attached file has the scenario and the explanation for your query. Thanks > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On Thu, Aug 27, 2009 at 4:51 PM, suresh k wrote: > >> Hi Guyz, >> >> Whenever we use conditional formatting it will be applied for current cell >> only. >> >> Is there anyway that if the condition is true the entire row should be >> colored??? >> >> Regards, >> Suresh >> >> > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Advanced conditional formatting
Hi Guyz, Whenever we use conditional formatting it will be applied for current cell only. Is there anyway that if the condition is true the entire row should be colored??? Regards, Suresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ IF condition formula
Can anyone provide me the formula for below query. Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03 7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05 Answer should be 26.91. Excluding the value less than 8.00 hrs and it should calculate only for one day(7/2/2009). I have tried if condition, and not able to give both the conditions. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ NAMED Range
Hi All, I have selected A1 to A5 and given some name(In Named Range). Now I want to remove it. Anyone know how to do it??? Regards, Suresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ MS Access
Hi All, Please let me know if anyone know about MS Access or provide me any link, where i can find help. Regards, Suresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: VLookup formula
Hi All, This formula is working fine, But when i apply this formula to a very large data. It is not showing accurately. And this formula tells that it will look into only a particular cell. But i need some formula where it should search for all cells in a particular column. On Thu, Jul 16, 2009 at 6:41 PM, Daniel wrote: > Hi. > > Have a look at the attached file. > > Regards. > > Daniel > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *suresh k > *Sent:* jeudi 16 juillet 2009 09:58 > *To:* Excel group > *Subject:* $$Excel-Macros$$ VLookup formula > > > > Hi > > I have one query. > I have data in two different sheets. Below are example for you. > > > *Data in sheet 1:* > Name Data Date No. > Su 12 1/1/99 123 > gu 22 2/2/99 124 > gg 33 3/3/00125 > > > *Data in shee 2:* > Name Data Date No. > Su 12 1/1/99 123 > ff 22 2/2/99 124 > gg 33 3/3/00125 > > > Now I need formula where i need to compare only first 2 columns (Name & > Data) and i need to findout how many line items are same. > Please let me know if any one can help me on this. > > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ VLookup formula
Hi I have one query. I have data in two different sheets. Below are example for you. *Data in sheet 1:* Name Data Date No. Su 12 1/1/99 123 gu 22 2/2/99 124 gg 33 3/3/00125 *Data in shee 2:* Name Data Date No. Su 12 1/1/99 123 ff 22 2/2/99 124 gg 33 3/3/00125 Now I need formula where i need to compare only first 2 columns (Name & Data) and i need to findout how many line items are same. Please let me know if any one can help me on this. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ EXCEL TIP FOR THE WEEK
Hi All, To copy paste for all the cells. Lets say you have the data in A3 and you want to copy to C3:C4 cells.Using mouse to select all the cells is little bit difficult. Now you can do the same with below easy steps. 1. Select B3. 2. Then *Ctrl+C* to copy the data 3. Click once in the Name box, above column A. (Before you click, the Name box contains "B3," which is the cell you just copied.) 4. Type C3:C9 or, if you prefer, C3:C55000 and press *Enter*. The range is selected. 5. Press *Ctrl+V*. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Protect and unprotect all sheets
Hi All, Can anyone provide the vba code to protect and unprotect all sheets in excel. Thanks & regards, Suresh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Error - "End If without block if"
Thanks Ajay, This code is working fine. But when I enter some text in this field Iam getting error. Please provide me the solution. On 3/26/09, Ajay Varshney wrote: > > Use this code: > > Private Sub CommandButton1_Click() > Dim A As Integer > Dim Shts As Worksheet > A = TextBox1.Value > If A = 123 Then > For Each Shts In ThisWorkbook.Worksheets > Shts.Unprotect Password:=123 > Next > UserForm1.Hide > Else > For Each Shts In ThisWorkbook.Worksheets > Shts.Protect Password:=123 > Next > UserForm1.Hide > End If > End Sub > > > On Wed, Mar 25, 2009 at 9:01 PM, suresh k wrote: > >> Hi All, >> >> Can anyone help on this error. Below is the code. >> >> Private Sub ok_Click() >> Dim a As Integer >> a = Val(text1.Text) >> >> If a = bp Then >> For Each shts In ThisWorkbook.Worksheets >> shts.Unprotect >> ActiveWorkbook.Unprotect >> UserForm1.Hide >> End If >> >> If Not a Then >> >> ActiveWorkbook.Protect >> For Each shts In ThisWorkbook.Worksheets >> shts.Protect >> Next >> End If >> >> End Sub >> >> >> >> > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Error - "End If without block if"
Hi All, Can anyone help on this error. Below is the code. Private Sub ok_Click() Dim a As Integer a = Val(text1.Text) If a = bp Then For Each shts In ThisWorkbook.Worksheets shts.Unprotect ActiveWorkbook.Unprotect UserForm1.Hide End If If Not a Then ActiveWorkbook.Protect For Each shts In ThisWorkbook.Worksheets shts.Protect Next End If End Sub --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: "Next" error
Hi Ashish, Thanks for your reply, This code is working fine, but if I enter value apart from "bp" all the sheets should be protected. Please let me know the code for this. On Tue, Mar 24, 2009 at 9:42 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Suresh, > > Remove the 8th line from your macro .i.e. "Next". It's not required. > Here is modified code which is shorter and more readable than before. > > Tip: Always indent your program, it increase readability and hence > error evaluations. > > Private Sub ok_Click() >Dim a As Integer >a = Val(text1.Text) > >If a = bp Then >Application.ActiveSheet.Unprotect >ActiveWorkbook.Unprotect >UserForm1.Hide >End If > >If a >= 2 Then >'Protects ALL worksheets >ActiveWorkbook.Protect >For Each shts In ThisWorkbook.Worksheets > shts.Protect >Next >End If > End Sub > > . > . > . > . > . > For more tips, tricks, downloads and problem solutions: visit --> > http://www.excelitems.com > > Regards > *Ashish **Jain* > Analyst, CSC Australia > Microsoft Certified Application (Excel) Specialist > Technical Trainer - Excel and VBA > Author -> www.excelitems.com > +91--40-48-43 > > ----- > > - > > On Mar 24, 8:34 pm, suresh k wrote: > > Hi All, > > > > Can anyone check whether below codes are correct or not. > > I am getting error message while i run this code. > > > > Private Sub ok_Click() > > Dim a As Integer > > a = Val(text1.Text) > > > > If a = bp Then > > Application.ActiveSheet.Unprotect > > ActiveWorkbook.Unprotect > > UserForm1.Hide > > Next > > End If > > > > If a > 2 Then > > 'Protects ALL worksheets > > ActiveWorkbook.Protect > > For Each shts In ThisWorkbook.Worksheets > > shts.Protect > > Next > > End If > > > > If a = 0 Then > > ActiveWorkbook.Protect > > For Each shts In ThisWorkbook.Worksheets > > shts.Protect > > Next > > End If > > > > End Sub > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ "Next" error
Hi All, Can anyone check whether below codes are correct or not. I am getting error message while i run this code. Private Sub ok_Click() Dim a As Integer a = Val(text1.Text) If a = bp Then Application.ActiveSheet.Unprotect ActiveWorkbook.Unprotect UserForm1.Hide Next End If If a > 2 Then 'Protects ALL worksheets ActiveWorkbook.Protect For Each shts In ThisWorkbook.Worksheets shts.Protect Next End If If a = 0 Then ActiveWorkbook.Protect For Each shts In ThisWorkbook.Worksheets shts.Protect Next End If End Sub --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel File & VBA Password Remover Tool Required
Hope ayush Jain can help in this query. On Mon, Nov 24, 2008 at 11:32 AM, kamlesh jain <[EMAIL PROTECTED]> wrote: > Dear All, > > Can any body send me Tool / Software for Removing Password from Excel > & VBA. > It will be great help for me. > > Thanks in advance. > > -- > Regards, > Kamlesh Jain > > > > --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: How can i print a range of worksheets from workbooks in a directory
Hi
Please remove me from this google groups.
thnx
On 11/12/08, Tom Jeffries <[EMAIL PROTECTED]> wrote:
> I've attached a workbook containing two macros PrintWorkbooks and
> Traversethat together do what you are describing. Invoke
> PrintWorkBooks and provide the full starting path (e.g. C:\TEST). Starting
> at this point all subdirectories are traversed and each workbook found is
> opened and sheets meeting your criterion are printed. Note, that you need
> to uncomment the lines in Traverse that actually do the printing to insert
> the appropriate criteria. If you have any questions let me know.
> Tom
>
> On Mon, Nov 10, 2008 at 6:55 PM, Howy <[EMAIL PROTECTED]> wrote:
>
>>
>> Thanks, I've got that working nicely thanks. I just need it to drill
>> through subdirectories now.
>>
>> On Nov 7, 3:10 pm, "Akhilesh Karna" <[EMAIL PROTECTED]> wrote:
>> > Hi,
>> >
>> > Your purpose can be achieved by minor improvement in your code. You can
>> > replace the following part of first macro.
>> >
>> >With Workbooks(sCurFile)
>> >
>> > >.Worksheets(2).PrintOut
>> > >.Worksheets(3).PrintOut
>> > >.Close SaveChanges:=False
>> > >End With
>> >
>> > replace with
>> >
>> > call PrintMost
>> >
>> > > activeworkbook.close SaveChanges:=False
>> >
>> > Hope this works. You need not combine the two functions, rather use both
>> of
>> > them.
>> >
>> > Akhilesh Kumar Karna
>> >
>> > On Fri, Nov 7, 2008 at 9:39 AM, Howy <[EMAIL PROTECTED]> wrote:
>> >
>> > > Hi there,
>> >
>> > > I have a timesheet spreadsheet i have designed, for each employee they
>> > > have a workbook. in a directory and subdirectories by there pay
>> > > location.
>> >
>> > > I would like to create a macro in a new workbook. Which asks the path
>> > > the workbooks are in then prints the worksheets if data exists in a
>> > > range on that workbook. I am not super experienced with vba however
>> > > i've found the two following snippets of code which as i see need to
>> > > be joined up.
>> >
>> > > Ideally i'd like to drill into subdirectories but that is not urgent.
>> >
>> > > This code prints sheets 2 & 3 of each workbook, however i want it to
>> > > only print the sheets if a value exists in a range. I've pasted a code
>> > > below which does something similar.
>> >
>> > > Public Sub PrintWorkbooks()
>> > >Dim sCurFile As String
>> > >Dim sPath As String
>> >
>> > >'Get the path
>> > >sPath = InputBox("Starting path?", "PrintWorkbooks")
>> > >If sPath <> "" Then
>> > >On Error Resume Next
>> > >Application.ScreenUpdating = False
>> > >If Right(sPath, 1) <> "\" Then
>> > >sPath = sPath & "\"
>> > >End If
>> > >sCurFile = Dir(sPath & "*.xls", vbNormal)
>> > >Do While Len(sCurFile) <> 0
>> > >Workbooks.Open sPath & sCurFile, , True
>> > >With Workbooks(sCurFile)
>> > >.Worksheets(2).PrintOut
>> > >.Worksheets(3).PrintOut
>> > >.Close SaveChanges:=False
>> > >End With
>> > >sCurFile = Dir
>> > >DoEvents
>> > >Loop
>> > >Application.ScreenUpdating = True
>> > >On Error GoTo 0
>> > >End If
>> > > End Sub
>> >
>> > > This code prints sheets if a value exists on each sheet.
>> >
>> > > Sub PrintMost()
>> > >Dim wks As Worksheet
>> > >For Each wks In ActiveWorkbook.Worksheets
>> > >If Not IsEmpty(wks.Range("G41")) Then
>> > >wks.PrintOut
>> > >End If
>> > >Next
>> > >Set wks = Nothing
>> > > End Sub
>> >
>> > > Can anyone help me combine these two functions.
>> >
>> > > Any help is much appreciatted
>> >
>> > > Kind regards,
>> >
>> > > Ben Howard
>>
>> >
>>
>
> >
>
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~--~~~~--~~--~--~---
