Dear All,
I am face the attached Error in 2010 while saving active workbook on recording
macro.
[cid:image001.png@01CD8799.C70A4EE0]
Regards,
Shrinivas
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violati
Hi Friends,
My name is Shrinivas Chidurala, Currently living in Bangalore.
Working in Citi Bank as a Sr. Associate from post 5 years - Security Analyst.
Regards,
Shrinivas
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ashish Bhalara
Sent: Wednesday, J
Shrinivas,
Check below link
http://office.microsoft.com/en-us/excel-help/use-office-excel-2010-with-earlier-versions-of-excel-HA010342994.aspx
On Mon, Mar 19, 2012 at 7:51 PM, Chidurala, Shrinivas
mailto:shrinivas.chidur...@citi.com>> wrote:
Divaker,
I am facing the below error while running
Mar 15, 3:48 pm, "Chidurala, Shrinivas "
mailto:shrinivas.chidur...@citi.com>> wrote:
> Hi
>
> I am facing the below error while running below macro. Please can you advise
> on the same.
>
> Thank you for your help !
>
> Sub Convert_HTML_to_Excel()
>
>
Hi
I am facing the below error while running below macro. Please can you advise on
the same.
Thank you for your help !
Sub Convert_HTML_to_Excel()
Application.ScreenUpdating = False
Dim fldpth As String
Dim fld, fil As Object
Dim j, a As Long
Dim ask, ask2 As Workbook
'fldpth = SelectFolde
Dear Group,
Please suggest any formula to pick next working date, but Saturday and Sunday
should not include.
Working day Next Working day
9-Feb-12 10-Feb-12
10-Feb-1213-Feb-12
Regards,
Shrinivas
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
Dear Team,
I am creating macro for Recon of prices where facing problem in multiple
vlookup. Find attached Recon file.
Please any one help me the multiple vlookup function/coding multiple vlookup.
Thanking in Advance.
Regards,
Shrinivas
--
FORUM RULES (986+ members already BANNED for violati
ewBook
Application.Goto wbk.Sheets(1).Cells(1)
wbk.Close 1
Next lngLoop
ErrH:
Erase varDiv
Erase varBon
Erase varRight
If Err.Number <> 0 Then
MsgBox Err.Description, vbOKOnly + vbInformation, "Unknown Error"
Err.Clear: On Error GoTo
Thanks Mahesh,
But it is capturing only div sheet, i want to capture all 3 sheets.
Regards,
Shrinivas
From: Mahesh parab [mailto:mahes...@gmail.com]
Sent: Saturday, October 01, 2011 10:38 PM
To: excel-macros@googlegroups.com; Chidurala, Shrinivas [ICG-GTS
Hi Mahesh,
Find below coding to delete the contains "0" value from 13th row of column "P".
Sub Zero_data()
Dim Firstrow As Long
Dim Lastrow As Long
Dim Lrow As Long
Dim CalcMode As Long
Dim ViewMode As Long
Dim rng As Range
With Application
CalcMode = .Calcul
"\Desktop\" & ac_num & ".xlsx",
FileFormat:=xlOpenXMLWorkbook
nwkb.Close
Next j
Sheets(1).Rows("1").Delete shift:=xlUp
End Sub
----------
Thanks,
Anish
On Fri, Jul 15, 2011 at 4:12 PM, Chidurala, Shrinivas
mailto:shriniva
Rajan,
I am using Excel 2003 and the macro is not from coding " Dim Fso As New
Scripting.FileSystemObject" .
Regards,
Shrinivas
On Thu, Jul 7, 2011 at 10:45 PM, Chidurala, Shrinivas
mailto:shrinivas.chidur...@citi.com>> wrote:
Thanks a lot Rajan. But the below macro i
File Found For Compile", vbInformation
Else
MsgBox Counter & " File Has been Compiled, Please Find your File at"
& vbCrLf & compiledPath, vbInformation
End If
End Sub
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googleg
Atul,
Please use below coding it will help you to delete the blank cell of column A.
Sub Macro6()
Columns("A:A").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.Delete Shift:=xlUp
End Sub
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberr
Dear Gurus,
Please advise any formula to calculate the Book Value in given attachment.
Thanks in Advance
Regards,
Shrinivas
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and li
pen each file in the folder using
the for next where u can call ur macros
Hope this might help.
Please let me know if you need any further help on this
On Tue, Apr 26, 2011 at 11:46 AM, Chidurala, Shrinivas
mailto:shrinivas.chidur...@citi.com>> wrote:
Please help.
Regards,
Shriniva
Please help.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Email - shrinivas.chidur...@citi.com
-Original Message-
From: Chidurala, Shrinivas [ICG-GTS]
Sent: Monday
Dear Gurus,
I have created the attached macro for formatting of 50 to 60 files everyday
which are receive from system. But to run this macro i need to open and then
run. It taking too much time.
Please can you advise to prepare the macro which will give facility do similar
formatting of all fi
: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: Saturday, March 19, 2011 2:21 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert HTML file to Excel
can u send the sample file
On Thu, Mar 17, 2011 at 3:20 PM, Chidurala
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Chidurala, Shrinivas [ICG-GTS]
Sent: Thursday, March 17, 2011 3:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert HTML file to Excel
Dear All,
We received some HTML files from System and we save as
Dear All,
We received some HTML files from System and we save as them in Excel file and
do some formatting. Can we do this activity of converting HTML file to Excel by
Macro. Please adive on the somes.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24
Hi Ayush,
We have any VBA coding to convert Excel to PDF.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 01.
Ph- +91-80-4144 6339 / 6340
Email - shrinivas.chidur...@citi.com
__
Dear All,
I have cash entries in one workbook and I want total of some specific entries
in different workbook.
Please can you help me on the same.
Regards,
Shrinivas
--
--
Some important links for excel users:
1.
Dear All,
Please can any one help me to extract date in given securities by way of VBA
code and formula.
SecurityDate
REC 07.60% 22JAN13 22-Jan-2013
08.80% STATE BKOF BK&JAIPUR 05SEP11 FD
GAIL INDIA LIMITED
HDFC 0.00% 24AUG12
LIC HOUSING FINANCE 07.50% 10JUN13
Regards,
Shrinivas
-
$$ Help
try this it will extract last word.
RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
","")
On Fri, Jan 21, 2011 at 4:37 PM, Chidurala, Shrinivas
mailto:shrinivas.chidur...@citi.com>> wrote:
Thanks Ashish &
ehalf Of ashish koul
Sent: Wednesday, January 19, 2011 8:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help
try this formula
=MID(A2,FIND("%",A2)-5,5)
On Wed, Jan 19, 2011 at 8:04 PM, Chidurala, Shrinivas
mailto:shrinivas.chidur...@citi.com>> wrote:
Dear All,
Dear All,
Please can any one help me to extract percentage in given securities by way of
VBA code and formula.
SecurityPercentage
REC 07.60% 22JAN13 07.60
08.80% STATE BKOF BK&JAIPUR 05SEP11 FD
NAT HSG BK 6.90% 30OCT12 (P/C - 30OCT11)
HDFC 0.00% 24AUG12
Thanks in advance.
Regards,
Dear All,
I love Excel more than any Software in the World, I'm not alone, millions and
millions of people around the world use it too and, more or less, Love it.
Regards,
Shrinivas
Citi(r) Global Transaction Services - India
UB City, Canberra Block, # 24, Vittal Mallya Road,
Bangalore - 56 00 0
two macro first one to get file names and second will rename them
u can merge them also if u want
On Thu, Feb 18, 2010 at 9:18 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
Sorry Ashish, I am unable to open your file and also find attached list of file
names fo
looking for this
also just to avoid writing that 111 222 manually
can u tell us how account no are related top file names
can u provide few examples of file names
and is it fixed
that sbi is having 111
or hsbc 222
On Thu, Feb 18, 2010 at 4:11 PM, Chidurala, Shrinivas <
shrinivas.chi
: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com]on Behalf Of Chidurala, Shrinivas
Sent: Wednesday, February 17, 2010 2:31 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Rename the files
Dear All,
Every day we receive nearby 100 files from our system, which contain
Dear All,
Every day we receive nearby 100 files from our system, which contain some
client date and the file name is like ICICI, HDFC, SBI etc, I want rename the
files as per there account no. like 123, 456, 789 etc.
Require your help in creating a macro, which will rename the files as perthere
and what you dont want..)
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sat, Aug 8, 2009 at 4:49 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
Thanks Vivek, It is very useful for me.
I want another
where the
file containing this module is present. you can modify the code based on your
needs.
Feel free to mail me if more help required.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Fri, Aug 7, 2009 at 10:34 AM, Chid
needs.
Feel free to mail me if more help required.
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Fri, Aug 7, 2009 at 10:34 AM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
Dear Friends,
Find attac
Dear Friends,
Find attached a dump file of all clients,
1. I want one macro to spit the date as per clients in different sheet of same
Excel and the same name should be the client name.
2. I want another macro to split data as per client in new excel and save in
C:\.
Regards,
Shrinivas
--~-
files. You better address an Outlook forum. You
could try the NNTP newsgroup :
microsoft.public.outlook.general
Regards.
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de Chidurala, Shrinivas
> Envoyé
Set olApp = Nothing
End Sub
Regards.
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de Chidurala, Shrinivas
> Envoyé : lundi 6 juillet 2009 07:27
> À : excel-macros@googlegroups.com
> Obje
d Sub
Regards.
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de Chidurala, Shrinivas
> Envoyé : samedi 4 juillet 2009 14:55
> À : excel-macros@googlegroups.com
> Cc : bal...@gmail.com
> Objet :
Dear Friends,
I requeired i coding to create a draft with attachement and also the draft
format should be in plain text.
Find attached draft for your reference.
Thanks & Regards,
Shrinivas
--~--~-~--~~~---~--~~
---
: Monday, June 29, 2009 10:08 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Urgent help
Hi,
try this code
Activeworkbook.saveas(Thiswookbook.path & "\" ClinentName & format(now
(),"ddmmhhmm")&".xls")
With regards
BALA
On Jun 2
Dear Friends
I want file should be save like client name with current date & time
e.g.
ICICIBANK270620091500
Regards,
Shrinivas
Query Unit
Securities Services
Global Transaction Services - India.
Ph: +91-80-41446339
E-Mail: shrinivas.chidur...@citi.com
--~--~-~--~~~--
Dear Friends,
When ever the user open new excel the macro automatically open.
Please can any one tell me where should I save that macro.
Regards,
Shrinivas
Query Unit
Securities Services
Global Transaction Services - India.
Ph: +91-80-41446339
E-Mail: shrinivas.chidur...@citi.com
--~--~---
43 matches
Mail list logo
