Re: $$Excel-Macros$$ Login password in excel

2014-04-26 Thread amar takale
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

$$Excel-Macros$$ Please Visit below link for All Shortcuts including Excel

2014-04-26 Thread Ravinder
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 @

$$Excel-Macros$$ How to share Code/Macro ?

2014-04-26 Thread Suyog Kulkarni
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

RE: $$Excel-Macros$$ How to share Code/Macro ?

2014-04-26 Thread Ravinder
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:

Re: $$Excel-Macros$$ How to share Code/Macro ?

2014-04-26 Thread ǝɹohsiʞ ʞ ʌ d
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

Re: $$Excel-Macros$$ Login password in excel

2014-04-26 Thread amar takale
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

$$Excel-Macros$$ hi ayush ji

2014-04-26 Thread ashish saini
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,

$$Excel-Macros$$ shortcut keys to increase efficiency of daily work in Excel

2014-04-26 Thread ravinder negi
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 @

Re: $$Excel-Macros$$ Need new Workbook create using Macros

2014-04-26 Thread kapil Gupta
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

$$Excel-Macros$$ Need a code to update the non existing data

2014-04-26 Thread Ganesh N
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

$$Excel-Macros$$ please help for consolidate in excel

2014-04-26 Thread Jitendra Yadav
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 @

Re: $$Excel-Macros$$ Need a code to update the non existing data

2014-04-26 Thread Ganesh N
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

Re: $$Excel-Macros$$ please help for consolidate in excel

2014-04-26 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Need a code to update the non existing data

2014-04-26 Thread ravinder negi
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