Re: $$Excel-Macros$$ Login password in excel
Dear Vabs Thanks for explanation of issue. Means that error show always in excel 2003 2007.we can not do anything to remove error window of object doesn't support this property or method.Bcos now all things done by you as per my requirement but small issue of this error window. Regards Amar On Sat, Apr 26, 2014 at 11:54 AM, Vaibhav Joshi v...@vabs.in wrote: PROPERTY ISSUE IS DUE TO EXCEL 2003 2007 ISSUE. REFER ATTACHMENT. On Sat, Apr 26, 2014 at 11:46 AM, Vaibhav Joshi v...@vabs.in wrote: Hi PFA this is with masking your password. Thx On Sat, Apr 26, 2014 at 11:17 AM, amar takale amartak...@gmail.com wrote: Dear Vabs Again some thing small issue accrued,pls see screen shot. Regards Amar On Sat, Apr 26, 2014 at 11:02 AM, Vabs v...@vabs.in wrote: Hi Pls check this.. Thanks On Sat, Apr 26, 2014 at 10:54 AM, amar takale amartak...@gmail.com wrote: Dear Vabs There are problem of password,it show wrong password.Pls can you see sheet. Regards Amar On Fri, Apr 25, 2014 at 9:23 PM, Vabs v...@vabs.in wrote: Thanks!!! PFA Cheers!! On Fri, Apr 25, 2014 at 7:06 PM, amar takale amartak...@gmail.com wrote: Dear Vaibhav Mind Freaking !!! Awesome!!! Perfect,You are done it……… I am really thankful for its wonderful Coding. One thing small issue that if I login sheet save it close sheet.When again open that sheet then Login Password (AMAR AMAR) show everyone who open this sheet.I think it will show invisible (Login Password) when second time open sheet.every second user must to login put password then show Reports sheet. Regards Amar Regards Amar On Wed, Apr 23, 2014 at 8:57 PM, Vaibhav Joshi v...@vabs.in wrote: Hi PFA, i have done changes as per basic requirements Cheers! On Wed, Apr 23, 2014 at 5:41 PM, amar takale amartak...@gmail.com wrote: Dear abhishek Thanks for reply i want to wish proceed with this discussion but in our office chat window is blocked. So i cant chat with you.but I am very pleased with your Efforts for work.Thanks very much friend,I will try it again on Google. If I got any solution for that issue then i will send file for you on our Excel forum. All Excel team experts pls give me idea for above matter issue. Regards Amar On Wed, Apr 23, 2014 at 5:19 PM, Abhishek Jain abhishek@gmail.com wrote: You can change the login names and password in the VBA code of the form / sheet. I am not sure how to do this with hyperlinks. You may contact me via chat if you wish to proceed with this or need to discuss anything further. Regards, Abhishek On Wed, Apr 23, 2014 at 5:13 PM, amar takale amartak...@gmail.com wrote: Dear Abhishek Thanks good one solution of my issue but can we go through my discussion.And also How can we change Login password of sheet which one you sent. Pls give me solution as per my requirement (VBA OR Hyperlink) then that great work for me. Thanks again for help Regards Amar On Thu, Apr 17, 2014 at 1:07 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Abhishek Sir, Great. Regards, Prafull Jadhav 9920553518 On 17 April 2014 12:09, Abhishek Jain abhishek@gmail.com wrote: Dear Amar, Please see the attached file. I hope this works for you. You may login by using any of the following credentials (both username and password fields are case sensitive) User - ABHI Pass - abhi User - AMAR Pass - amar After login, it will take you to the reports sheet. Upon opening the file, you might need to allow the macros to run. Hope this helps. Regards, Abhishek On Thu, Apr 17, 2014 at 11:30 AM, amar takale amartak...@gmail.com wrote: -- 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
$$Excel-Macros$$ Please Visit below link for All Shortcuts including Excel
Please visit this link for All Shortcuts Keys including Excel http://excelvbasupport.com/forum/showthread.php?tid=4 -- 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/d/optout.
$$Excel-Macros$$ How to share Code/Macro ?
Hello All, Kindly refer attached file, I've created macro but I want to share this macro to other users. Following are my difficulties. 1. How can I secure the code ? Kindly add password 12345 for this file. 2. To run the code I need to keep this file open but which I don't want normal user to do ? This macro should run automatically on any pc. 3. Can I add Any additional button which would be appear along with the exiting toolbar of excel ? so that normal use will only click that button without headache ? Kindly advice me. With Regards, Suyog -- 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/d/optout. Rw.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
RE: $$Excel-Macros$$ How to share Code/Macro ?
Pls visit below link for solution http://excelvbasupport.com/forum/showthread.php?tid=8 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suyog Kulkarni Sent: Saturday, April 26, 2014 2:40 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to share Code/Macro ? Hello All, Kindly refer attached file, I've created macro but I want to share this macro to other users. Following are my difficulties. 1. How can I secure the code ? Kindly add password 12345 for this file. 2. To run the code I need to keep this file open but which I don't want normal user to do ? This macro should run automatically on any pc. 3. Can I add Any additional button which would be appear along with the exiting toolbar of excel ? so that normal use will only click that button without headache ? Kindly advice me. With Regards, Suyog -- 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/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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ How to share Code/Macro ?
Please go through the below link: http://velin-georgiev-blog.appspot.com/blog/fully-automated-excel-reporting-by-using-windows-task-scheduler-vba-and-simple-vba-functions-library/ On Sat, Apr 26, 2014 at 3:06 PM, Ravinder ravindervbacli...@gmail.comwrote: Pls visit below link for solution *http://excelvbasupport.com/forum/showthread.php?tid=8 http://excelvbasupport.com/forum/showthread.php?tid=8* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Suyog Kulkarni *Sent:* Saturday, April 26, 2014 2:40 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to share Code/Macro ? Hello All, Kindly refer attached file, I've created macro but I want to share this macro to other users. Following are my difficulties. 1. How can I secure the code ? Kindly add password 12345 for this file. 2. To run the code I need to keep this file open but which I don't want normal user to do ? This macro should run automatically on any pc. 3. Can I add Any additional button which would be appear along with the exiting toolbar of excel ? so that normal use will only click that button without headache ? Kindly advice me. With Regards, Suyog -- 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/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 http://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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Login password in excel
Dear Vabs This is fabulous work! I think this must be flashing on the front page! :D Thank you very much for all of your efforts on this. I sincerely appreciate it. Best regards and wishing you a fine day. Amar On Sat, Apr 26, 2014 at 2:17 PM, Vaibhav Joshi v...@vabs.in wrote: Hi This will work.. Cheers!! On Sat, Apr 26, 2014 at 12:40 PM, amar takale amartak...@gmail.com wrote: Dear Vabs Thanks for explanation of issue. Means that error show always in excel 2003 2007.we can not do anything to remove error window of object doesn't support this property or method.Bcos now all things done by you as per my requirement but small issue of this error window. Regards Amar On Sat, Apr 26, 2014 at 11:54 AM, Vaibhav Joshi v...@vabs.in wrote: PROPERTY ISSUE IS DUE TO EXCEL 2003 2007 ISSUE. REFER ATTACHMENT. On Sat, Apr 26, 2014 at 11:46 AM, Vaibhav Joshi v...@vabs.in wrote: Hi PFA this is with masking your password. Thx On Sat, Apr 26, 2014 at 11:17 AM, amar takale amartak...@gmail.com wrote: Dear Vabs Again some thing small issue accrued,pls see screen shot. Regards Amar On Sat, Apr 26, 2014 at 11:02 AM, Vabs v...@vabs.in wrote: Hi Pls check this.. Thanks On Sat, Apr 26, 2014 at 10:54 AM, amar takale amartak...@gmail.com wrote: Dear Vabs There are problem of password,it show wrong password.Pls can you see sheet. Regards Amar On Fri, Apr 25, 2014 at 9:23 PM, Vabs v...@vabs.in wrote: Thanks!!! PFA Cheers!! On Fri, Apr 25, 2014 at 7:06 PM, amar takale amartak...@gmail.com wrote: Dear Vaibhav Mind Freaking !!! Awesome!!! Perfect,You are done it……… I am really thankful for its wonderful Coding. One thing small issue that if I login sheet save it close sheet.When again open that sheet then Login Password (AMAR AMAR) show everyone who open this sheet.I think it will show invisible (Login Password) when second time open sheet.every second user must to login put password then show Reports sheet. Regards Amar Regards Amar On Wed, Apr 23, 2014 at 8:57 PM, Vaibhav Joshi v...@vabs.in wrote: Hi PFA, i have done changes as per basic requirements Cheers! On Wed, Apr 23, 2014 at 5:41 PM, amar takale amartak...@gmail.com wrote: Dear abhishek Thanks for reply i want to wish proceed with this discussion but in our office chat window is blocked. So i cant chat with you.but I am very pleased with your Efforts for work.Thanks very much friend,I will try it again on Google. If I got any solution for that issue then i will send file for you on our Excel forum. All Excel team experts pls give me idea for above matter issue. Regards Amar On Wed, Apr 23, 2014 at 5:19 PM, Abhishek Jain abhishek@gmail.com wrote: You can change the login names and password in the VBA code of the form / sheet. I am not sure how to do this with hyperlinks. You may contact me via chat if you wish to proceed with this or need to discuss anything further. Regards, Abhishek On Wed, Apr 23, 2014 at 5:13 PM, amar takale amartak...@gmail.com wrote: Dear Abhishek Thanks good one solution of my issue but can we go through my discussion.And also How can we change Login password of sheet which one you sent. Pls give me solution as per my requirement (VBA OR Hyperlink) then that great work for me. Thanks again for help Regards Amar On Thu, Apr 17, 2014 at 1:07 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Abhishek Sir, Great. Regards, Prafull Jadhav 9920553518 On 17 April 2014 12:09, Abhishek Jain abhishek@gmail.com wrote: Dear Amar, Please see the attached file. I hope this works for you. You may login by using any of the following credentials (both username and password fields are case sensitive) User - ABHI Pass - abhi User - AMAR Pass - amar After login, it will take you to the reports sheet. Upon opening the file, you might need to allow the macros to run. Hope this helps. Regards, Abhishek On Thu, Apr 17, 2014 at 11:30 AM, amar takale amartak...@gmail.com
$$Excel-Macros$$ hi ayush ji
please include me in your group pls -- 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/d/optout.
$$Excel-Macros$$ shortcut keys to increase efficiency of daily work in Excel
just visit below link;-- http://excelvbasupport.com/forum/newthread.php?fid=7processed=1 Thanks Regards Ravinder Negi -- 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/d/optout.
Re: $$Excel-Macros$$ Need new Workbook create using Macros
Hi Thanks Sir, Thats great. Regards, Kapil Gupta On Tuesday, April 22, 2014 11:32:48 AM UTC+5:30, Abhi wrote: Dear Kapil, Please see the attached. This will create workbooks, paste filtered data and save them as per the name column (Col G). *Keep in mind the following:* a) The new excel files will be created in the same folder* where you have saved this file*. So, when you download this, save it in a folder where you can locate it. b) If destination files are already in that folder (means if you have run the macro once), *the code will NOT overwrite them*. You will have to *remove the files manually* before you re-run the macro, else there will be errors. Hope this helps. Abhishek On Mon, Apr 21, 2014 at 8:48 PM, kapil Gupta kgup...@gmail.comjavascript: wrote: Hi, Kindly solve this query. 1. I have attached one sheet all data in sheet according by name 2 need create new workbook using macros according by name wise.. Means Name is A then should be Create workbook A and other is B then create other workbook Name is B. and data also Assign in name sheet. I have attached the example Regards, Kapil -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need a code to update the non existing data
Hi Team, I need to update the data in second sheet. before that i want to check the data is already updated or not if already updated i need a msg else the data needs to be update (I want to check the date and prj code, becoz week on week prj and date will change. so i dont want to make a duplicate ). I wrote coding for update the data. I need a code to check the condition. Kindly help me on that. Please find the attachment for your reference. Thanks Regards, Ganesh N -- 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/d/optout. Data to be update.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ please help for consolidate in excel
Hi All, I have some data for date wise but I want all excel file in one sheet through macro. Example. Regards, Jitendra//9650449202 -- 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/d/optout. 1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet example.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need a code to update the non existing data
Hi Team, Any update on my request ? Thanks Regards, Ganesh N On Sun, Apr 27, 2014 at 7:50 AM, Ganesh N ganeshg...@gmail.com wrote: Hi Team, I need to update the data in second sheet. before that i want to check the data is already updated or not if already updated i need a msg else the data needs to be update (I want to check the date and prj code, becoz week on week prj and date will change. so i dont want to make a duplicate ). I wrote coding for update the data. I need a code to check the condition. Kindly help me on that. Please find the attachment for your reference. Thanks Regards, Ganesh N -- 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/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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ please help for consolidate in excel
Hi, You can try this excellent codes share by Ashish earlier this month: Sub merge() Dim fld As Object, fil As Object, fso As Object, fldpath With Application.FileDialog(msoFileDialogFolderPicker) .Title = Choose the folder .Show End With On Error Resume Next fldpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ If fldpath = False Then MsgBox Folder Not Selected Exit Sub End If Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpath) Application.DisplayAlerts = False Application.ScreenUpdating = False For Each fil In fld.Files If Right(fil.Name, 4) = .xls And fil.Name ThisWorkbook.Name Then Call import_data(fil.Path) Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub Sub import_data(filename As String) Dim wkb As Workbook Dim lastrow As Long lastrow = ThisWorkbook.Sheets(Sheet1).Range(a65356).End(xlUp).Row + 1 Set wkb = Workbooks.Open(filename) wkb.Sheets(Summary Sheet).Range(e2:j2).Copy Destination:=ThisWorkbook.Sheets(Sheet1).Range(a lastrow) wkb.Sheets(Summary Sheet).Range(b13:f13).Copy Destination:=ThisWorkbook.Sheets(Sheet1).Range(g lastrow) wkb.Close End Sub Thanks On Sun, Apr 27, 2014 at 9:44 AM, Jitendra Yadav jitendr...@gmail.comwrote: Hi All, I have some data for date wise but I want all excel file in one sheet through macro. Example. Regards, Jitendra//9650449202 -- 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/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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Need a code to update the non existing data
hi, please visit below link for your solution, please advise if anything else required. http://excelvbasupport.com/forum/showthread.php?tid=15 Note I have checked only code number. On Sat, Apr 26, 2014 at 7:20 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Team, I need to update the data in second sheet. before that i want to check the data is already updated or not if already updated i need a msg else the data needs to be update (I want to check the date and prj code, becoz week on week prj and date will change. so i dont want to make a duplicate ). I wrote coding for update the data. I need a code to check the condition. Kindly help me on that. Please find the attachment for your reference. Thanks Regards, Ganesh N -- 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/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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.