*Best Regards,*
*Nitin Gupta **| Sr. Technical Recruiter | LinkedIn Profile
<http://www.linkedin.com/in/nitingupta-canvas/>*
Web: http://www.canvasinfotech.com
Email: ni...@canvasitsolutions.com
Phone: 510-313-1119
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=T
ards,*
*NITIN | *
* Sr. Sales Associate Neo Prism Solutions LLC, Phone: 214 257
0158| Fax: 630-447-0034, E mail: **ni...@neoprisminc.com*
* 917 N Plum Grove Rd, Suite C, Schaumburg, IL – 60173, URL: *
*www.neoprisminc.com* <http://www.neoprisminc.com/>
*An E-Verified company
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
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
Hi
Please find the summary of my consultant who is available immediately for
the new projects.
Let me know if you have any suitable position for him.
*Please reply at ans...@enolimitsinc.com for
quick response. *
*NAME*
*SKILL*
*LOCATION*
*AVAILABILITY*
*RELOCATION*
Nitin Taneja
.NET
Hi
Please find the summary of my consultant who is available immediately for
the new projects.
Let me know if you have any suitable position for him.
*Please reply at ans...@enolimitsinc.com for
quick response. *
*NAME*
*SKILL*
*LOCATION*
*AVAILABILITY*
*RELOCATION*
Nitin Taneja
.NET
Hi
Please find the summary of my consultant who is available immediately for
the new projects.
Let me know if you have any suitable position for him.
*Please reply at ans...@enolimitsinc.com for
quick response. *
*NAME*
*SKILL*
*LOCATION*
*AVAILABILITY*
*RELOCATION*
Nitin Taneja
.NET
Hi
Please find the summary of my consultant who is available immediately for
the new projects.
Let me know if you have any suitable position for him.
*Please reply at ans...@enolimitsinc.com for
quick response. *
*NAME*
*SKILL*
*LOCATION*
*AVAILABILITY*
*RELOCATION*
Nitin Taneja
.NET
Hi
Please find the summary of my consultant who is available immediately for
the new projects.
Let me know if you have any suitable position for him.
*Please reply at ans...@enolimitsinc.com for
quick response. *
*NAME*
*SKILL*
*LOCATION*
*AVAILABILITY*
*RELOCATION*
Nitin Taneja
.NET
Hi All,
Please find the summary of my consultant who is available immediately for
the new projects.
Let me know if you have any suitable position for him.
*NAME*
*SKILL*
*LOCATION*
*AVAILABILITY*
*RELOCATION*
Nitin Taneja
.NET
Parsippany, NJ
Immediate
Open
*BACKGROUND SUMMARY
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(
I am trying to make an Invoice and inventory management sheet in excel.
Sheet1(ITEMS) - List of all items, Name, Value, tax, Unit of Measurement
Sheet2(SALES INVOICE) - Invoice Template, we select items and input qty to
print invoice.
Sheet3 (STOCK oUT) - On a button press on sheet2, qty for ite
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
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
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
Dear all,
Pls help me on this how can we read crypt files in excel or txt.
Regards
Nitin upadhyay
--
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 this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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
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
,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
("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 So
Hi Vaibhav,
I have tried using below code but it is giving only the last record of
yesterday date after it run through the loop, I did tried to do some editing to
the code but of no use :( and yes the sheet name is Pivot and Pivot Table name
is PivotTable1.
Regards.
Yours Sincerely,Nitin
Hi Vaibhav,
I have tried using below code but it is giving only the last record of
yesterday date after it run through the loop, I did tried to do some editing to
the code but of no use :( and yes the sheet name is Pivot and Pivot Table name
is PivotTable1.
Regards.
Yours Sincerely,Nitin
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
).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(
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
ot;).AutoFilter Field:=10, Criteria1:="Nitin",
Operator:=xlOr, Criteria2:="Balodi"CountValue =
ActiveSheet.UsedRange.Columns(1).SpecialCells(xlCellTypeVisible).Count - 1
For i = 2 To CountValueRange("A1").Select
//Code line 1 to iterate the
listRange("A1").Spe
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:
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
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
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
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
:=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
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
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
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
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
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
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
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
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
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
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?
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
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
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
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
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
Dear Team,
Below software is can recover password only VBA project file of Doc, Xla
and Xls files but my exel file is xlsx so its not working.
so plz suggest me the password remover of xlsx file format.
Regards,
Nitin Kumar
Pfa,
Regards,
Nitin Kumar
Pfa,
Regards,
Nitin Kumar
On Fri, Feb 28
Dear Team,
Below software is can recover password only VBA project file of Doc, Xla
and Xls files but my exel file is xlsx so its not working.
so plz suggest me the password remover of xlsx file format.
Regards,
Nitin Kumar
Pfa,
Regards,
Nitin Kumar
On Wed, Mar 5, 2014 at 1:09 PM, nancy
Dear Elis,
below software is not working & not showing the password can u find the the
password of attached file password.
please...
Regards,
Nitin Kumar
+91 9784363535
Pfa,
Regards,
Nitin Kumar
On Fri, Feb 21, 2014 at 6:08 PM, elis smith wrote:
> * You can use Excel file password c
Dear Team,
U r just share the Excel Password recovery software but its Not working so
please Help
Regards,
Nitin Kumar
Pfa,
Regards,
Nitin Kumar
On Wed, Feb 12, 2014 at 2:57 PM, elis smith wrote:
> *You can use this Excel Password Recovery software to recover Excel file
>> pas
Hi All, I am Nitin Mittal, working as HR Manager in Stonehill International
School Bangalore. I want to learn advanced Excel and VBA, hence joined here.
--
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 this forum
Dear team,
Plz Help problem not resolved same issue file still not open so plz ...
regards.
Nitin Kumar
On Tuesday, December 17, 2013 11:59:30 AM UTC+5:30, nitin kumar wrote:
>
> Dear Kuldeep,
>
> this software shows cant remove the VB password
> PLz Help file is bel
Next
>> Next
>> Next
>> Next
>> Next
>> Next
>> NextNext300 MsgBox "exited"End Sub
>>
>> Regards,
>> Kuldeep Singh
>> Assistant Manager Quality
>&
Sorry but its not working
On Dec 17, 2013 1:39 AM, "nitin kumar" wrote:
> Sorry but its not working plz help
> On Dec 16, 2013 7:51 PM, "Kuldeep Singh" wrote:
>
>> http://remove-vba-password.software.informer.com/
>>
>>
>> On Mon, Dec 16,
hello dear,
i'm lost my excel file password & i cant opne file so plz help
& string DPB is not found in hex editor
nitin kumar
On Saturday, February 20, 2010 10:08:47 AM UTC+5:30, cma.ankur wrote:
>
> plz send ur file
> Have A Nice Time & Enjoy Life
>
> Regard
'Thanks
On Tuesday, February 26, 2013 1:09:46 PM UTC+5:30, bé trần văn wrote:
>
> Menu> Toosl> Macro> Macro and click Run to view the results
>
> 2013/2/23 Nitin Gupta >
>
>> Hi
>> I want to link multiple data in row to column, but when you use tran
On Saturday, February 23, 2013 8:09:18 PM UTC+5:30, अनिल नारायण गवली wrote:
>
> Dear Ramjit,
>
> Pls share a worksheet with us.
>
>
>
> Warm Regards,
> Gawli Anil
>
> On Sat, Feb 23, 2013 at 4:06 PM, Ranjeet Negi
>
> > wrote:
>
>> Dear Sir,
>>
>> I have a data in Range (C2:C50). There are valu
Hi
I want to link multiple data in row to column, but when you use transpose
function the links are not working need to past special in value term
Sample Sheet attached
Please advice
--
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 officia
Solution in Single Step
On Saturday, February 23, 2013 5:01:30 PM UTC+5:30, Ranjeet Negi wrote:
>
> Thanks, but is it possible to make one formula instead of two step.
>
> On Saturday, 23 February 2013 16:45:09 UTC+5:30, Nitin Gupta wrote:
>>
>> I see the answer in 2 ste
I see the answer in 2 steps, as attached
IF & SUMIF
Regards
Nitin
On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote:
>
> Dear Sir,
>
> I have a data in Range (C2:C50). There are values. I want to sum all
> value upto or equal to 6500, wherein value
Pls see the solution in attached sheet
Nitin
On Saturday, February 23, 2013 1:14:46 PM UTC+5:30, satyas wrote:
>
>
> Hi Experts,
>
> Just need to compare two columns by last name . Will appreciate if you can
> help me for this.
>
> Satya.
>
--
Are you =EXP(E:RT)
Hi, Noorain
I am not able to do this.. Link not working for new ID.. Please add my
outlook id as well
nitin.upadh...@in.aegisglobal.com
On Thu, Jul 12, 2012 at 5:33 PM, NOORAIN ANSARI wrote:
> Dear Nitin,
>
> you can join group through below link...
>
> http://groups.google.
Thanks NOORAIN ANSARI & Asa rossoff
On Fri, May 11, 2012 at 11:47 AM, Asa Rossoff wrote:
> Thank you Noorain for sharing those. I just started reading through "50
> Excel VBA Oral Questions…" and the Q & As seem good, but not all the
> answers are complete and thorough, and some could be mislea
Hi,
I sent few mails to this group which have excel file attched to them. I
request you to please delete all my posts on priority from the group.
My email id is: nitinaror...@gmail.com
Regards,
Nitin Arora
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
---
nitin arora wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-1bce156c49-49439e65f4-TjijJGrT3mGgSPg1dNIXfciG6S4
Y
144138763 Total Common Equity Missed
30839253 144138763 Net Income Missed.
Please let me know if I am missing something over here
Regards,
Nitin Arora
On Wed, Jan 4, 2012 at 6:51 PM, dguillett1 wrote:
> FIRST. To some of us, ME, “urgent help required” is a NO NO. All
> req
= 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
Cells.Select
Selection.Copy
Sheets("Validation Not Done").Select
'Sheets("Sheet1").Name = "Validation Not Done"
Cells.Select
ActiveSheet.P
30839253 144138763 Total Common Equity Missed
30839253 144138763 Net Income Missed.
It would be great if you can tell me a solution for this.
Many Thanks in advance.
Regards,
Nitin Arora
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
"\\path.odc"
.Refresh BackgroundQuery:=False
End With
On Mon, Oct 3, 2011 at 1:41 PM, Nitin Hemmady wrote:
> Yes maybe the macro recorder is a good idea, thanks!
>
>
> On Mon, Oct 3, 2011 at 1:33 PM, Sam Mathai Chacko wrote:
>
>> I connect to A
th a more conventional VBA connection code snippet? If that
> didn't work, did you try recording a macro while you perform the query
> manually?
>
> Regards,
>
> Sam
>
>
> On Tue, Oct 4, 2011 at 12:00 AM, Nitin Hemmady wrote:
>
>> Hi Yes I saw this, but I still
nstrings.com/*
>
> And on how to run a query from within Excel, try
>
> *
> http://www.excelfox.com/forum/showthread.php?66-Execute-SQL-From-Excel-(VBA)
> *
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
>
> On Mon, Oct 3, 2011 at 10:48 PM, Nitin wrote:
>
>>
Hi All,
I want to be able to run queries within Excel like this:
--
mysql01 = "select * from some_table"
ActiveWorkbook.Worksheets.Add
With ActiveSheet.QueryTables.Add(Connection:= _
If you are working in 1 workbook in that case both terms are same and If you
are working with more that 1 workbook then ActiveWorkbook denote the current
selected workbook and Thisworkbook denote the workbook where the coding is
stored.
Regards
Nitin Gupta
On Tue, Feb 9, 2010 at 11:03 PM, Shiv
Hi,
Do share the file on Network.
Regards
Nitin Gupta
On Mon, Jan 11, 2010 at 3:29 PM, Anant Shelke wrote:
>
> Hi,
>
> I want some help and little bit
> challenging
>
> I WANT TO WORK IN ONE FILE IN MULTIPLE LOCATIONS
> AND ALL THE CHANGES MADE BY ALL USERS IT TO BE S
ired
---> Above macro should be in a excel file which should have buttons to ask
for Location of Dumps(i.e location of 20 files) and one more button to ask
for Location of new file (XYZ). And this macro can be used in any machine/PC
Any help
76 matches
Mail list logo