- Original message
From:S Suvarna ssuva...@magna.in
Date: 12 Sep 11 13:12:37
Subject: Urgent Oening for SQL Server Developer at Chennai based Client
To: S Suvarna
Hi,
Greetings for the day!!!
Let me take this opportunity to introduce Magna Infotech Pvt. Ltd. We are
one ofthe
Hi Ashish, appreciate you help.
The code is partly okay. The above code created a new files with those x and
y sheets.
Can you alter the above macro code, so that those x and y sheets will get
pasted to already existing (12)files?
Appreciate your help once again.
Regards,
Sridhar BL
--
Thanks for your reply...
Can you please do a small favour for me.
Now I want to copy the same data not in to more sheets, it should be into
different workbooks.
Thanks and Regards,
Naresh V,
Sr Analyst,
iSpace global services India pvt ltd.
From: excel-macros@googlegroups.com
For each in a LIST in range(“a1:a12”)
Sub test()
For i = 1 To 12
ThisWorkbook.Sheets(Array(Sheet1, Sheet2)).Copy
ActiveWorkbook.SaveAs C:\Documents and Settings\ASHISH\Desktop\ABC\book
cells(I,”a”) .xlsx
ActiveWorkbook.Close
Next i
End Sub
From: ashish koul
Sent: Wednesday, September 07, 2011
Hey Folks,,
I have figured out a code to match the text file with excel sheet name.but
not able to open thetext file. Error in red line.
I want to open without using get openfilename.
Sub Read_text_File()
Dim fso, fld, fil As Object
Dim fldpth As String
fldpth = C:\Documents and
I guess I'm in over my head. I have no clue how to use what you just
attached. Thanks anyway.
On Sep 8, 9:30 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Robert,
Please see attached add-in. It will be help to Compare Table.
On Fri, Sep 9, 2011 at 12:29 AM, Robert Jacobs
hello everyone
I have created a macro long back and i have protected it
and now forgot the passwork,
is it possible to veiw the code??
--
--
Some important links for excel users:
1. Follow us on TWITTER for
hello everyone
i have created a macro and protected it
and i forgot the password
is it possible to view the code??
please help
thanks
srinivas
--
--
Some important links for excel users:
1. Follow us on TWITTER
- Original message
From:Scope International Pvt Ltd ramya.rampra...@sc.com
Date: 12 Sep 11 16:01:05
Subject: Walk in For Finance Professionals on September 13th and
14thTuesday and Wednesday@ Scope International Haddows Road
To:
The sender of this email is registered
Hai all,
I am attaching an excel userform which contains Dateof Birth textbox and
Date of Retirement textbox.
Conditions are:
i) Date of Retirement should be 60 years after Date of Birth
eg. if date of birth is in the year 1960 date of retirement would be 2020
ii) Date of retirement would be
Why not just a simple formula for a dob in cell d11
=DATE(YEAR(D11)+60,MONTH(D11)+1,0)
From: Shankar Bheema
Sent: Monday, September 12, 2011 9:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ date difference
Hai all,
I am attaching an excel userform which
Try
Workbooks.OpenText Filename:=fldpth fname, _
Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _
Array(0, 2), TrailingMinusNumbers:=True
On Mon, Sep 12, 2011 at 6:40 PM, mrinal saha mris...@gmail.com wrote:
Hey Folks,,
I have figured out a code to match the text file
but i am using userform na sir. So pls see my attachment and i am not
understanding the mistake i did in my code
On Mon, Sep 12, 2011 at 9:07 PM, dguillett1 dguille...@gmail.com wrote:
Why not just a simple formula for a dob in cell d11
=DATE(YEAR(D11)+60,MONTH(D11)+1,0)
*From:*
Private Sub CommandButton1_Click()
txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1,
DateAdd(d, -1, CDate(txtdob.Text)), CDate(txtdob.Text)))
End Sub
Regards,
Sam Mathai Chacko (GL)
On Mon, Sep 12, 2011 at 9:28 PM, Shankar Bheema shankar.n...@gmail.comwrote:
but i am
I tried with the provided code but its working only with the years but
months and days are not working
On Mon, Sep 12, 2011 at 9:33 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Private Sub CommandButton1_Click()
txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1,
And if you go the formula way, try this
=IF(DAY(A2)=1,DATE(YEAR(A2-1)+60,MONTH(A2-1)+1,0),DATE(YEAR(A2)+60,MONTH(A2)+1,0))
On Mon, Sep 12, 2011 at 9:43 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Thought you wanted to increment date only...
Try this
Private Sub CommandButton1_Click()
amazing its working bro.
i didnot understand that, in the code you have
written IIf(Day(CDate(txtdob.Text). I thought its wrong and changed it
to If(Day(CDate(txtdob.Text) then it thrown error. Why it happened so. IIf
is what for ?
On Mon, Sep 12, 2011 at 9:46 PM, Sam Mathai Chacko
Hi All,
Need your help to Populate the data from the pivot for the available
columns.
Regards
Anu
On Thu, Sep 8, 2011 at 10:57 PM, anu gomathi anugomathi.d...@gmail.comwrote:
Hi All,
Please find the attached file. Need to populate the data sheet from pivot
Regards
Anu
On Thu, Sep 8,
Thought you wanted to increment date only...
Try this
Private Sub CommandButton1_Click()
txtdor.Text = DateAdd(, 60, IIf(Day(CDate(txtdob.Text)) = 1,
DateAdd(d, -1, CDate(txtdob.Text)), DateAdd(m, 1,
DateSerial(Year(CDate(txtdob.Text)), Month(CDate(txtdob.Text)), 1)) - 1))
End Sub
Sam
Shankar, IIF is an alternative for the IF Else.End if. statement
to evaluate single-statement true-false comparisons. The *IIf* function is
easier to debug and shortens the amount of code you need to write, and it
takes for following format:
IIf(Expression, TruePart, FalsePart)
I am an advocate of the KISS (keep it simple stupid-not meant personally) so
stick with my original offering.
From: Shankar Bheema
Sent: Monday, September 12, 2011 10:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ date difference
but i am using userform na sir. So pls
Hi Experts,
Is there any formula we can use to select matched texts just like
sumif formula(in case of numbers).Kindly find the attached file it
ellaborate well about the issue.And tell me how to solve it.
Regards
Rajesh Kainikkara
--
Repost
I really don’t use USERFORMS, but try
Private Sub CommandButton1_Click()
txtdor.Text = DateSerial(Year(txtdob.Text) + 60, Month(txtdob.Text) + 1, 0)
End Sub
From: dguillett1
Sent: Monday, September 12, 2011 1:04 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ date
Hi,
Pls send me the file, I will try.
Regards
Rajesh
On 9/12/11, channa srinivas srinivascha...@yahoo.co.in wrote:
hello everyone
i have created a macro and protected it
and i forgot the password
is it possible to view the code??
please help
thanks
srinivas
--
It appears that a simple vlookup should do it.
=IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0)))
-Original Message-
From: Rajesh K R
Sent: Monday, September 12, 2011 1:51 PM
To: excel-macros
Subject: $$Excel-Macros$$ Look formula to select ledger group
Hi Experts,
I would strongly suggest that you not try to break this password UNLESS
poster can PROVE ownership. Legal problems
-Original Message-
From: Rajesh K R
Sent: Monday, September 12, 2011 1:58 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Hi,
Pls send me the
Hi,
I was not aware of that.Thanks for information.
Regards
Rajesh Kainikkara
On 9/13/11, dguillett1 dguille...@gmail.com wrote:
I would strongly suggest that you not try to break this password UNLESS
poster can PROVE ownership. Legal problems
-Original Message-
From: Rajesh
Hi,
Thanks for getting a very quick reply, I don't know lookup formulas.
Regards
Rajesh Kainikkara
On 9/13/11, dguillett1 dguille...@gmail.com wrote:
It appears that a simple vlookup should do it.
=IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0)))
-Original
Just put in the top cell and use the fill handle to copy down
-Original Message-
From: Rajesh K R
Sent: Monday, September 12, 2011 2:08 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Look formula to select ledger group
Hi,
Thanks for getting a very quick reply, I
Consultant Parvathy
Email ID parva...@absolutehrs.com
Subject: Absolute HR - XL Group - Analyst - Management Information
This refers to our telecon today; firstly I would like to thank you for your
time.
*Absolute HR International* is a Global Talent Acquisition Consulting
firm.
I have a macro to sort and subtotal a set of data. This data will
always be different amount of lines. I can set the macro to subtotal
only current range. If I try to include all lines so that I account
for when the lines of data increase, it will not allow the first line
to be included.
Here is
Hi All,
I need to compare two columns and sum the unique value.
Example:
Apple 10
Orange 5
Apple 20
Mango 25
Orange 15
Mango 7
Result
Apple 30
Orange 20
Mango 32
Plz help to know the formula.
Regards,
Prabhu
--
Hi All,
How to convert DAT to Excel file.
Now i am just converting by importing DAT to excel but i am facing
some alignment problem.
Plz help to know the same.
Regards
Prabhu
--
--
Some important links for excel
try this
Sub copy_files()
Dim ServerA As String
Dim ServerB As String
ServerA = C:\temp\filename.dat
ServerB = C:\temp\filename2.xls
FileCopy ServerA, ServerB
End Sub
On Tue, Sep 13, 2011 at 7:30 AM, Prabhu prabhugate...@gmail.com wrote:
Hi All,
How to convert DAT to Excel file.
Now i
Use sumif or put pivot tableplease find the attachment..
On Tue, Sep 13, 2011 at 7:15 AM, Prabhu prabhugate...@gmail.com wrote:
Hi All,
I need to compare two columns and sum the unique value.
Example:
Apple 10
Orange 5
Apple 20
Mango 25
Orange 15
Mango 7
Result
Dear Prabhu,
Please see attached sheet..
Conditional SUM thourgh VBA..
On Tue, Sep 13, 2011 at 7:15 AM, Prabhu prabhugate...@gmail.com wrote:
Hi All,
I need to compare two columns and sum the unique value.
Example:
Apple 10
Orange 5
Apple 20
Mango 25
Orange 15
Mango 7
Dear Awal,
Please see below link it will help to u.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=360
On Tue, Sep 13, 2011 at 5:46 AM, Awal malaw...@gmail.com wrote:
I have a macro to sort and subtotal a set of data. This data will
always be different amount of lines.
thank one and all for providing solution for me.
On Tue, Sep 13, 2011 at 12:23 AM, dguillett1 dguille...@gmail.com wrote:
Repost
I really don’t use USERFORMS, but try
Private Sub CommandButton1_Click()
txtdor.Text = DateSerial(Year(txtdob.Text) + 60, Month(txtdob.Text) + 1, 0)
End Sub
Hi All
Please help me for the inventory sheet for manufacturing unit.
Regards
Manhar
--
On Sat, Sep 10, 2011 at 4:33 PM, manhar prajapati
prajapati.man...@gmail.com wrote:
Hi
Anyone have inventory sheet for manufacturing unit.
--
*Manhar Prajapati*
*Contact: 9824335449*
:)
39 matches
Mail list logo