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

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

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

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

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

Visible).Count - 1 = 0 Then GoTo ErrorMessageCode Range("A1").SelectRange("A1").CurrentRegion.SpecialCells(xlCellTypeVisible).Copy Sheets(3).ActivateActiveSheet.Paste Can you help me on this. Thanks and Regards. Yours Sincerely,Nitin Balodi -- Ar

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

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

urce:=Range("A" & StartRow & ":B" & EndRow, Range2) Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Thu, 29 Jan 2015 21:53:29 +0530 Subject: Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA To: excel-macros@googlegroups.com check t

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

t pivot table in your sheet, Also check date format, you need to give exact same format i.e. m/d/y 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 wrote: Hi Vaibhav, Thanks for your response. I have tried code

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

t pivot table in your sheet, Also check date format, you need to give exact same format i.e. m/d/y 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 wrote: Hi Vaibhav, Thanks for your response. I have tried code

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

).PivotTables("PivotTable1").PivotFields("Created Date").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(

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

cialCells(xlCellTypeVisible).Offset(i, 1).Select //Code line 2 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

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

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

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 this

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

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 filteri

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

:=xlAnd, Criteria2:="<>#N/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

RE: $$Excel-Macros$$ Error in Filtering Data using VBA

Hi Vaibhav, Thanks for the solution. Its working fine. Regards. Yours Sincerely,Nitin Balodi From: v...@vabs.in Date: Mon, 8 Sep 2014 23:12:00 +0530 Subject: Re: $$Excel-Macros$$ Error in Filtering Data using VBA To: excel-macros@googlegroups.com Hi FA, cheers!!+I did not do this for you

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$$ Assign already open workbooks name to variables using wildcard

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

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

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 of

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

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

cros$$ Macro 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 wrote: > Hi Experts, > > I am in fix over this part of my repo

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

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

RC[-3],'[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?

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

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

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

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