$$Excel-Macros$$ Changing Region and Language Setting using VBA

Hi, Can anyone help me understand how can we change Region and Language setting using VBA. I want to change *Format:* English (United States) to English (United Kingdom) and vice-versa. Thanks in advance. Regards, Nitin Balodi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ Changing Regional Settings using VBA

Hi Champs, Can anyone help me to understand how to change Regional Settings using VBA. I need to change Region and Language format to English (UK) from English (US) and vice-versa. Thanks in advance. Regards. Yours Sincerely, Nitin Balodi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

$$Excel-Macros$$ Browsing through all open workbooks

kbook.NameElseIf Workbook.Name Like "*456*" Then SourceFile = ActiveWorkbook.NameEnd IfNextMsgBox DestinationFile MsgBox SourceFile End Sub Can someone help me on this. Regards. Yours Sincerely,Nitin Balodi -- Are you =EXP(E:RT) or =NOT

RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

Sorry Mandeep, I cant share the file due to confidentiality issue, but I am looking for a generic solution for this issue. Regards. Yours Sincerely,Nitin Balodi Date: Mon, 18 May 2015 04:55:09 -0700 From: rockerna...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re

$$Excel-Macros$$ VBA Error in copying filtered rows

).CurrentRegion.SpecialCells(xlCellTypeVisible).Copy Sheets(3).ActivateActiveSheet.Paste Can you help me on this. Thanks and Regards. Yours Sincerely,Nitin Balodi -- 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

RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

Hi Mandeep, Thanks for the response, I have tried that and getting same result and I cannot give predefined rows range since these are filtered out during run time. Regards. Yours Sincerely,Nitin Balodi Date: Mon, 18 May 2015 04:10:25 -0700 From: rockerna...@gmail.com To: excel-macros

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

Thanks Vaibhav, it worked. This group is really amazing. Thanks for your support and help. Thanks and Regards, Nitin Balodi From: v...@vabs.in Date: Mon, 2 Feb 2015 12:59:48 +0530 Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA To: excel-macros@googlegroups.com Hi

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

Hi Vaibhav, Attached is the sample data file. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Sat, 31 Jan 2015 20:07:02 +0530 Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA To: excel-macros@googlegroups.com Hi Share sample chart.. On Fri, Jan 30

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

,Nitin Balodi From: v...@vabs.in Date: Fri, 30 Jan 2015 18:18:09 +0530 Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA To: excel-macros@googlegroups.com try Charts(Chart1).SetSourceData Source:=application.union(Range1,Range2) Cheers!!ᐧ On Fri, Jan 30, 2015 at 5:59 PM

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

(A StartRow :B EndRow)Set Range2 = Range(D StartRow :D EndRow) Charts(Chart1).SetSourceData Source:=Range(Range1, Range2) I also tried different things like: Charts(Chart1).SetSourceData Source:=Range(A StartRow :B EndRow, Range2) Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

hh:ss. Colb has date time format while you are giving only date in filter. ᐧ On Tue, Jan 27, 2015 at 8:17 PM, Nitin Balodi nitinbal...@live.com wrote: Hi Vaibhav, Thanks for your response. I have tried code you had suggested but it showing me object defined or application defined error

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

hh:ss. Colb has date time format while you are giving only date in filter. ᐧ On Tue, Jan 27, 2015 at 8:17 PM, Nitin Balodi nitinbal...@live.com wrote: Hi Vaibhav, Thanks for your response. I have tried code you had suggested but it showing me object defined or application defined error

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

Hi Vaibhav, Thanks for your response. I have tried code you had suggested but it showing me object defined or application defined error. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Tue, 27 Jan 2015 16:50:17 +0530 Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table

$$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

).PivotFilters.Add Type:=xlSpecificDate, Value1:=01/23/2015 Many thanks for your help in advance. Regards. Yours Sincerely,Nitin Balodi -- 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

RE: $$Excel-Macros$$ Iterating Filtered list using VBA

Hi Vaibhav, Many thanks, code worked. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 12 Jan 2015 15:45:33 +0530 Subject: Re: $$Excel-Macros$$ Iterating Filtered list using VBA To: excel-macros@googlegroups.com Hi Nitin, Browsing thru filtered cell you can use following code

$$Excel-Macros$$ Iterating Filtered list using VBA

to iterate the list'Range(A2, Cells(Rows.Count, A).End(xlUp)).SpecialCells(xlCellTypeVisible).Cells(i, 1).Select MsgBox Selection.ValueNext i End Sub Regards. Yours Sincerely,Nitin Balodi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

RE: $$Excel-Macros$$ Applying Date Filters using VBA

Hi Paul, Thanks for your response. The format will always be in mm-dd- hh:mm format and I want to apply filter for yesterday date for example, today I applied for 25th September 2014, I want to filter out yesterday date data only. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in

RE: $$Excel-Macros$$ Applying Date Filters using VBA

Hi Vaibhav, Thanks for the link. It certainly clear many concepts regarding date filters. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Fri, 26 Sep 2014 18:38:09 +0530 Subject: Re: $$Excel-Macros$$ Applying Date Filters using VBA To: excel-macros@googlegroups.com Refer

RE: $$Excel-Macros$$ Applying Date Filters using VBA

specific if we do not declare its datatype. I had done this thing (date filters) in three different macros and used three different methods. Thanks all for your efforts. I really need to work hard on this. Regards. Yours Sincerely,Nitin Balodi Date: Fri, 26 Sep 2014 20:57:18 +0530 Subject: Re: $$Excel

$$Excel-Macros$$ Error in filtering two criteria using Auto filter

/A If ActiveSheet.UsedRange.Columns(1).SpecialCells(xlCellTypeVisible).Count - 1 = 0 Then ErrorCell = Range(M1).Text GoTo WarningNoDataFound End If Please advise. Regards. Yours Sincerely,Nitin Balodi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

RE: $$Excel-Macros$$ Error in filtering two criteria using Auto filter

Hi Vaibhav, Thanks working fine, great. But I have a question, Data is filtered but #N/A is still not displayed in custom filter view. Is this an excel error? Regards. Yours Sincerely,Nitin Balodi Date: Sun, 14 Sep 2014 18:34:09 +0530 Subject: Re: $$Excel-Macros$$ Error in filtering two

RE: $$Excel-Macros$$ Error in filtering two criteria using Auto filter

Hi Vaibhav, Thanks for clearing doubts. Regards. Yours Sincerely,Nitin Balodi Date: Mon, 15 Sep 2014 09:39:54 +0530 Subject: RE: $$Excel-Macros$$ Error in filtering two criteria using Auto filter From: v...@vabs.in To: excel-macros@googlegroups.com Hi If your data in that column does

RE: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

are not same and will have timestamp of their extraction date and time. File1 = ForecastLastUpdated_*File2 = ForecastLastUpdated_ReferenceInformation* I hope it explains the criteria. Regards. Yours Sincerely,Nitin Balodi Date: Thu, 4 Sep 2014 03:33:36 -0700 From: schreiner_p...@att.net Subject: Re

RE: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

HI Paul., Thanks for your ideas, it worked. As suggested by you, I have changed naming convention so that each filename must be unique. Really appreciated. Regards. Yours Sincerely,Nitin Balodi Date: Thu, 4 Sep 2014 06:17:46 -0700 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros

RE: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation

Hi Vaibhav, Thanks for the idea. It works. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 1 Sep 2014 20:27:03 +0530 Subject: Re: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation To: excel-macros@googlegroups.com Hi check this, if you change

$$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

these variables to perform specific functions for files. Thanks for your help and support. Regards. Yours Sincerely,Nitin Balodi -- 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

RE: $$Excel-Macros$$ Macro Required for Auto Increment of Month Cell in calculation

Required for Auto Increment of Month Cell in calculation Hi How excel will know the starting month current month for which you are calculating formula? On Sun, Aug 31, 2014 at 3:31 PM, Nitin Balodi nitinbal...@live.com wrote: Hi Experts, I am in fix over this part of my report automation

$$Excel-Macros$$ VLookup file reference using VBA

],'[ForecastLastUpdated_18 July 2014 15.45.xlsx]Sheet1'!C1:C8,8,0) I want to replace the file name marked in Red with wrkbk. Thanks in advance. Regards. Yours Sincerely,Nitin Balodi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT

RE: $$Excel-Macros$$ VLookup file reference using VBA

Hi Vaibhav, Thanks for immediate response, but it is still showing me Syntax Error. ActiveCell.FormulaR1C1 = _ =VLOOKUP(RC[-3],'[wrkbk]Sheet1'!C1:C8,8,0) Value of WrkBk is ForecastLastUpdated_18 July 2014 15.45.xlsx Regards. Yours Sincerely,Nitin Balodi Date: Mon, 25 Aug 2014 16:25:31

RE: $$Excel-Macros$$ VLookup file reference using VBA

Hi Vaibhav, I had used this but it is still showing syntax error. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 25 Aug 2014 17:45:09 +0530 Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA To: excel-macros@googlegroups.com try: ActiveCell.FormulaR1C1

RE: $$Excel-Macros$$ VLookup file reference using VBA

Hi Paul and Vaibhav, Thanks, it worked by giving spaces. Regards. Yours Sincerely,Nitin Balodi Date: Mon, 25 Aug 2014 05:45:45 -0700 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA To: excel-macros@googlegroups.com The syntax error is probably because

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

Hi Vaibhav, Apologies for delayed response. Thanks for your help and idea, I have modified the code according to my requirement. Working fine. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Sun, 20 Jul 2014 12:21:48 +0530 Subject: Re: $$Excel-Macros$$ Using vba to open files

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

$$Excel-Macros$$ Re: Introduce Yourself !!

Hi All, I am Nitin Balodi, I work as a Associate into Commercial Operations with an MNC in Noida. Excel is an important aspect in my reporting automation and analysis. Feels good to be part of this Group and looking forward to contribute further. Regards, Nitin Balodi On Saturday, 9 June