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

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

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

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

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

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

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.

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

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

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

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

$$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

$$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

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