*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
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:= _
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 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
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
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 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 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,
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
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,
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
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 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
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 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
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
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
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
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
:=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 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
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 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 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
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 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
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 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,
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
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
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
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
).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,
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
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
("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
,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
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
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
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
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
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
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
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
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(
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, 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.
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
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
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
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:
>
>>
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
"\\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
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
= 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
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
---
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
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
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)
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
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
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
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
'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
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
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,
Next
>> Next
>> Next
>> Next
>> Next
>> Next
>> NextNext300 MsgBox "exited"End Sub
>>
>> Regards,
>> Kuldeep Singh
>> Assistant Manager Quality
>&
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
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,
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
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
76 matches
Mail list logo
