Re: $$Excel-Macros$$ doubt with prefix
Dear Shankar, Please see attached sheet and use code format for your coding. On Fri, Jan 27, 2012 at 2:23 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts I attached an userform, in which, frame2 contains total service. Which obtains by deducting date of joining from date of retirement. wherein, if a single digit comes, I need 0 as prefix for example: 1 yrs 2 mnths 3 days should reflect as 01 yrs 02 mnths 03 days. regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Example_(yy-mm-dd Format).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ doubt with prefix
thank you noorain bhai On Fri, Jan 27, 2012 at 2:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Please see attached sheet and use code format for your coding. On Fri, Jan 27, 2012 at 2:23 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts I attached an userform, in which, frame2 contains total service. Which obtains by deducting date of joining from date of retirement. wherein, if a single digit comes, I need 0 as prefix for example: 1 yrs 2 mnths 3 days should reflect as 01 yrs 02 mnths 03 days. regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ doubt with prefix
Dear Shankar, Please check once again -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Jan 27, 2012 at 4:20 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear Noorain, I have tried with the provided code. But it is throwing error. I am not getting where I am making mistake. Pls check the attached file. regards shankar On Fri, Jan 27, 2012 at 3:38 PM, Shankar Bheema shankar.n...@gmail.comwrote: thank you noorain bhai On Fri, Jan 27, 2012 at 2:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Shankar, Please see attached sheet and use code format for your coding. On Fri, Jan 27, 2012 at 2:23 PM, Shankar Bheema shankar.n...@gmail.com wrote: Dear experts I attached an userform, in which, frame2 contains total service. Which obtains by deducting date of joining from date of retirement. wherein, if a single digit comes, I need 0 as prefix for example: 1 yrs 2 mnths 3 days should reflect as 01 yrs 02 mnths 03 days. regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Pop up box required if cell is empty
Thanks alot Ansari ... its working superb.. thanks for your quick revert .. Regards, Raj On Fri, Jan 27, 2012 at 5:06 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Rekha, Please try it..Hope it will help to you Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If ActiveCell.Column 1 And ActiveCell.Column = 10 Or ActiveCell.Row 1 And ActiveCell.Row = 27 Then If Not IsEmpty(ActiveCell.Value) Then Exit Sub Else MsgBox Can't Leave it Blank, vbInformation End If End If End Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Jan 27, 2012 at 4:12 PM, rekha siri rekha.siri2...@gmail.comwrote: hi Experts, i require a popup box if cell is empty while moving to another cell. i tried placing code but not successful can anyone please provide me code. Thanks, Rekha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Code for deleting files in a folder.
will this work automatically or should the excel sheet should be open for the macro to run. On Thu, Jan 26, 2012 at 8:32 AM, Mr excel excelkeec...@gmail.com wrote: thanks for the update guillett On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 dguille...@gmail.com wrote: Just copy into a regular module. Change the date, folder, as I said.. It’s automatic based on the date. Don Guillett SalesAid Software dguille...@gmail.com *From:* Mr excel excelkeec...@gmail.com *Sent:* Wednesday, January 25, 2012 6:51 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder. thanks a lot guillet for your support.i would further like to know whether this code works simply by installing it in the code window of an excel sheet and triggers itself on that particular date (checking the date with the system date). Tell me how to get this code work with out any problems. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Import data
Dear Raghu, I have already provided a sample Macro/VBA coding, you can use it as per your requirement Press Alt+F11 and Paste Code in Module For more clearity, Please share sample file with group. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Jan 26, 2012 at 10:17 PM, raghu gr balaji.bra...@gmail.com wrote: hi noorain, I mean how Mr.Selva wrote or record the macro to import data set from two files and consolidate the data into a master file. thank you raghu On Thu, Jan 26, 2012 at 7:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Raghu, Please use attached sheet vba code as per your requirement. Press Alt+F11 to See Code. On Thu, Jan 26, 2012 at 7:25 PM, raghu gr balaji.bra...@gmail.comwrote: hi, how will u run macro, please elobarate with regards Raghu On Wed, Jan 25, 2012 at 10:53 AM, LearnExcel sendse...@gmail.comwrote: Hi team, i wanted to import data set from two files and consolidate the data into a master file. I need something in VBA, currently i run a marco that goes through each sheet and copies them into the marco but for some reason it takes some time im sure theres a better way.. let me know if you need more info -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please
Re: $$Excel-Macros$$ Code for deleting files in a folder.
thanks noorain for the reply.but my requirement is to delete the files folders dynamically on the date in the code.any other way around.pls tell me. On Fri, Jan 27, 2012 at 5:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mr. excel, It will work automatically when you run macro. On Fri, Jan 27, 2012 at 5:35 PM, Mr excel excelkeec...@gmail.com wrote: will this work automatically or should the excel sheet should be open for the macro to run. On Thu, Jan 26, 2012 at 8:32 AM, Mr excel excelkeec...@gmail.com wrote: thanks for the update guillett On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 dguille...@gmail.comwrote: Just copy into a regular module. Change the date, folder, as I said.. It’s automatic based on the date. Don Guillett SalesAid Software dguille...@gmail.com *From:* Mr excel excelkeec...@gmail.com *Sent:* Wednesday, January 25, 2012 6:51 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder. thanks a lot guillet for your support.i would further like to know whether this code works simply by installing it in the code window of an excel sheet and triggers itself on that particular date (checking the date with the system date). Tell me how to get this code work with out any problems. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to
Re: $$Excel-Macros$$ Code for deleting files in a folder.
Dear Excel, Have you tried Don's VBA Code I think it will perfect for your requirement. Please try it once again.. Sub DeleteFilesIfDay() If Date = DateValue(1/28/2012) Then On Error Resume Next Kill C:\yourfoldernamehere\*.* On Error GoTo 0 End If End Sub or Sub DeleteFilesbetweentwodays() if day(date) = 5 and day(date) =10 then On Error Resume Next Kill C:\yourfoldernamehere\*.* On Error GoTo 0 end if end Sub -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jan 27, 2012 at 6:16 PM, Mr excel excelkeec...@gmail.com wrote: thanks noorain for the reply.but my requirement is to delete the files folders dynamically on the date in the code.any other way around.pls tell me. On Fri, Jan 27, 2012 at 5:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mr. excel, It will work automatically when you run macro. ** http://noorain-ansari.blogspot.com/ On Fri, Jan 27, 2012 at 5:35 PM, Mr excel excelkeec...@gmail.com wrote: will this work automatically or should the excel sheet should be open for the macro to run. On Thu, Jan 26, 2012 at 8:32 AM, Mr excel excelkeec...@gmail.comwrote: thanks for the update guillett On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 dguille...@gmail.comwrote: Just copy into a regular module. Change the date, folder, as I said.. It’s automatic based on the date. Don Guillett SalesAid Software dguille...@gmail.com *From:* Mr excel excelkeec...@gmail.com *Sent:* Wednesday, January 25, 2012 6:51 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Code for deleting files in a folder. thanks a lot guillet for your support.i would further like to know whether this code works simply by installing it in the code window of an excel sheet and triggers itself on that particular date (checking the date with the system date). Tell me how to get this code work with out any problems. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another
Re: $$Excel-Macros$$ Code for deleting files in a folder.
If placed in the Thisworkbook module in the workbook_open event it will fire when you open the workbook. Don Guillett SalesAid Software dguille...@gmail.com From: Mr excel Sent: Friday, January 27, 2012 6:05 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Code for deleting files in a folder. will this work automatically or should the excel sheet should be open for the macro to run. On Thu, Jan 26, 2012 at 8:32 AM, Mr excel excelkeec...@gmail.com wrote: thanks for the update guillett On Thu, Jan 26, 2012 at 6:31 AM, dguillett1 dguille...@gmail.com wrote: Just copy into a regular module. Change the date, folder, as I said.. It’s automatic based on the date. Don Guillett SalesAid Software dguille...@gmail.com From: Mr excel Sent: Wednesday, January 25, 2012 6:51 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Code for deleting files in a folder. thanks a lot guillet for your support.i would further like to know whether this code works simply by installing it in the code window of an excel sheet and triggers itself on that particular date (checking the date with the system date). Tell me how to get this code work with out any problems. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ JOB
a person is required in this job name :- Devraj mob :- 9899399499 On Fri, Jan 27, 2012 at 5:12 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: *Job Location:* Gurgaon *Email ID* : resume.curv...@gmail.com http://apply.naukri.com/Apply/mn_Apply.php?applytype=singleApplyMode=1src=rmjmessageId=07b63a882b361e85f7a91972e21854cb465b085a5708160253080206025d40024551574405033308550f085c0d424e005245560c5d56075 *Dear Candidate,* Mission Control Analyst/WFM-Executive/MIS Candidate must be comfortable with night shifts Job Responsibilities: Would act as the first point of contact for all service related escalations occurring on account of issues such as call routing, technical glitches, unscheduled absence OR any other. Would constantly monitor, track, document and communicate real time floor activities in terms of adherence to process defined AUX/ACW/BREAKS SHIFTS. Would ensure availability of analysts on phones as per the business model requirement. Complete all required forms, reports, etc. within established timelines Interested candidate can send their profile @ resume.curv...@gmail.com And Mention details ; Total Experience : Relevant Experience : Current CTC : Expected CTC: Lead Time to Join : Regards Pooja 9716451777 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Fwd: VB Script - looping of files
varArray = Split(C:\New folder\text.xlsx|D:\New Folder\text1.xlsx|E:\New folder\text2.xlsx, |) Set objExcel = CreateObject(Excel.Application) For lng = LBound(varArray) To UBound(varArray) Set objWorkbook = objExcel.Workbooks.Open(varArray(lng)) For Each wks In objWorkbook.Worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete Next objWorkbook.Save 'C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls objWorkbook.Close Next objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards, Sam Mathai Chacko On Fri, Jan 27, 2012 at 7:43 AM, yogananda muthaiah yogananda.mutha...@gmail.com wrote: Dear All, Did anyone try this .. Regards Yogananda -- Forwarded message -- From: yogananda muthaiah yogananda.mutha...@gmail.com Date: Wed, Jan 25, 2012 at 10:06 PM Subject: VB Script - looping of files To: excel-macros@googlegroups.com Dear All I have 3 excel path mentioned below which needs to be looped for below VB script. Path : C:\New folder\text.xlsx D:\New Folder\text1.xlsx E:\New folder\text2.xlsx --- Below code working sucessfull for single excel --- Set objExcel = CreateObject(Excel.Application) Set objWorkbook = objExcel.Workbooks.Open(*C:\**Users\Sam\Desktop\** DelAllRowsExcelA1.xls*) for each wks in objworkbook.worksheets wks.Range(A2, wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save '*C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls* objWorkbook.Close objExcel.Application.Quit WScript.Echo Finished. WScript.Quit Regards Yogananda Muthaiah Ph : 973 123 7267 -- Regards Yogananda Muthaiah Ph : 973 123 7267 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ about set focus event
Dear Experts In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not provided. Is there any alternative for it in excel vba ? regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ help
Hello sir, Just i want to know about use relative reference in vb developer tab.? What is use of that ? Thanks in advance ' -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ about set focus event
Hello Shankar, If you mean a SetFocus method, form and ActiveX controls have that in Excel. If you mean a GotFocus event, ActiveX controls have that and you can use them in Excel. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shankar Bheema Sent: Friday, January 27, 2012 9:07 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ about set focus event Dear Experts In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not provided. Is there any alternative for it in excel vba ? regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com