Re: $$Excel-Macros$$ Using vba to open files with same name format

See attached file.. Click on blue button you will be prompted for Folder in which you have files, click ok then all excel files will be listed. In filter box type pattern of files you wan & click filter button then you will see filtered files in search box. Click file name & press OK to open file

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

I applied the formula as you did to one cell, but now i want to apply it to a whole table as attached. I applied it to Cell C3 to be based on O, P, Q in the attached file. Now i want to apply it to the cell range from C3 to N3 and C22 to N22. Brief: the formula to apply on every row from C to N

Re: $$Excel-Macros$$ macro

thanks daya brother On Sat, Jul 19, 2014 at 9:46 PM, my excel wrote: > Thank you Guruji > > > On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi wrote: > >> Hi >> >> you can run macro thru one go by creating macro.. >> >> >> Sub AllMacro() >> >>Call Macro1 >>Call Macro2 >>Call Macro3 >

Re: $$Excel-Macros$$ macro

Thank you Guruji On Sat, Jul 19, 2014 at 9:19 PM, Vaibhav Joshi wrote: > Hi > > you can run macro thru one go by creating macro.. > > > Sub AllMacro() > >Call Macro1 >Call Macro2 >Call Macro3 > End Sub > > > > On Sat, Jul 19, 2014 at 6:41 PM, daya p wrote: > >> Sir, >> i created 3

RE: $$Excel-Macros$$ Using vba to open files with same name format

Hi Vaibhav, To be more specific, reports name can begin with any one out of five specific strings with dates at end in the file name convention. Please contact if you require more clarification. Thanks. Regards, Nitin Balodi Sent from my Windows Phone From: Ni

RE: $$Excel-Macros$$ Using vba to open files with same name format

Hi Vaibhav, File name begins with a specific format, and yes, extension can be xls or xlsx. Like name is Nitin Report Jul 2014_07182014 Nitin Report Jul 2014_07112014 Nitin Report Jul 2014_07042014 Nitin Report Jun 2014_06252014 Thanks. Regards, Nitin Balodi Sent from my Windows Phone ___

Re: $$Excel-Macros$$ Using vba to open files with same name format

Hi Does it mean that you want to open only files having _DDMMYY format & also having more than one excel type? Cheers!! On Sat, Jul 19, 2014 at 2:13 PM, Nitin Balodi wrote: > Hi experts, > > Is there any way to open all excel files in a specific folder, having a > specific format like nitin

Re: $$Excel-Macros$$ macro

Hi you can run macro thru one go by creating macro.. Sub AllMacro() Call Macro1 Call Macro2 Call Macro3 End Sub On Sat, Jul 19, 2014 at 6:41 PM, daya p wrote: > Sir, > i created 3 macro > & i want run all 3 macro at a time > > means macro1,macro2,macro3 > macro1 for sheet2 report

$$Excel-Macros$$ macro

Sir, i created 3 macro & i want run all 3 macro at a time means macro1,macro2,macro3 macro1 for sheet2 report macro2 for sheet3 report macro3 for sheet4 report pls suggest with example sir thanks sir, Daya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO

Re: $$Excel-Macros$$ Fwd: R Shop Data

thanks a lot sir On 19 July 2014 18:31, my excel wrote: > thanks a lot guruji > > > On Fri, Jul 18, 2014 at 9:12 PM, Vaibhav Joshi wrote: > >> PFA excel with vba Macro!! >> >> Its more dynamic, click blue button & new sheet will get created. >> >> Cheers!! >> >> >> On Fri, Jul 18, 2014 at 10:3

Re: $$Excel-Macros$$ Fwd: R Shop Data

thanks a lot guruji On Fri, Jul 18, 2014 at 9:12 PM, Vaibhav Joshi wrote: > PFA excel with vba Macro!! > > Its more dynamic, click blue button & new sheet will get created. > > Cheers!! > > > On Fri, Jul 18, 2014 at 10:30 AM, my excel wrote: > >> Sir, >> i sent attached file of my friend ratio

$$Excel-Macros$$ Re: Send Atachment ExcelFile

Dear Team, Please Help on this to Solve this Problem !!! Regards, Vijayakumar R On Monday, July 14, 2014 3:46:45 PM UTC+5:30, Vijay wrote: > Dear Team, > > need your help to solve this problem !!! > > > 1) PFA, attached File already done by this Team, but require some more > query to b

$$Excel-Macros$$ Using vba to open files with same name format

Hi experts, Is there any way to open all excel files in a specific folder, having a specific format like nitin_mmdd. There are five files, with same name format, but extension can be either xls or xlsx. Thanks in advance. Regards, Nitin Balodi Sent from my Windows Phone -- Are you =EX