hi Kenil Gala,
find the attached file it will solve your prob
regards
Delin.F
From: Kenil Gala keni...@yahoo.com
To: excel macros excel-macros@googlegroups.com
Sent: Monday, 26 November 2012 8:48 PM
Subject: $$Excel-Macros$$ Small Query
Hi,
Pls
Dear All..
Bhanu Prakash, works for Oracle as Business analyst...Im proud to be part
of loverly group...Keep rocking..
Thanks
Bhanu
On Mon, Nov 26, 2012 at 10:43 PM, Ayush Jain jainayus...@gmail.com wrote:
CSk, start the new topic please
Thanks.
On Nov 25, 2012 10:01 PM, CSK
Amol Shrivastava From Mumbai...thanks
On Tue, Nov 27, 2012 at 5:22 PM, bhanu prakash bhanu...@gmail.com wrote:
Dear All..
Bhanu Prakash, works for Oracle as Business analyst...Im proud to be part
of loverly group...Keep rocking..
Thanks
Bhanu
On Mon, Nov 26, 2012 at 10:43 PM, Ayush
Welcome n Keep posting!!!
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Kuldeep Singh naukrikuld...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 27 Nov 2012 17:26:16
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
Hi all Excelers,
Jorge Marques from Portugal, work in a Logistic Company and Excel is now
part of my life, my learning curve in VBA is improving alot since I
discovered this group, also use chandoo.org because it has some awesome
stuff, regarding formulas and Charts. In my spare time I´m learning
Hey welcome
Keep Posting!!!
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Jorge Marques leote.w...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 27 Nov 2012 12:25:10
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
Guys - I'm facing issues with column width when pasting from Excel to
Word.
Briefly,
- I have an Excel file comprising of several worksheets. Each worksheet
comprises of several tables (with specific column width and row heights).
- Certain cells within these tables are merged while
1.
I have a number of spreadsheets in one folder. For each spreadsheet, I
need to open, then copy all 6 tabs (all have the same name: Option A,
Option B, Option C, Francais A, Francais B, Francais C) to a new sheet and
name the new sheet with the the same name as the
-- Forwarded message --
From: ysofia yso...@magna.in
Date: Tue, Nov 27, 2012 at 2:41 PM
Subject: Immediate Joinee required for VBA,EXCELand MACROS in Gurgaon
Location
To: daksh1...@gmail.com
*Dear Candidate,*
This is *Sofia* from *Magna InfoTech*.
We have an urgent requirement
Sub emailstest()
' run loop here
Call send_emails(Range(a2).Text, Range(b2).Text, Range(c2).Text)
End Sub
Sub send_emails(nm As String, to1 As String, cc1 As String)
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim fld As Object, fil As Object
Dim attach1 As String
Set fso
You can go here and can modify the code as per your need
http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mel
Sent: 27
if you rows and columns are fixed why do u create a blank template in word
document , merge cells , row ,etc as per your need
Then run a loop through all the cells in table to add data in word document
Regards
Ashish
On Tue, Nov 27, 2012 at 6:15 PM, Jewel Sharma jewelsha...@gmail.com wrote:
can u share the sample workbook
On Tue, Nov 27, 2012 at 8:01 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*You can go here and can modify the code as per your need *
* *
*http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/*
* *
* *
* *
* *
*Regards*
*Rajan
Hi Pascal,
I am not get correct solution from this coding
Please help !!!
On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 bpascal...@gmail.com wrote:
Another shorter programming solution would have been to autofilter column
B and copy visible cells into a table and do the same thing and
share some sample text files
On Tue, Nov 27, 2012 at 8:21 PM, Ganesh ganesh.inscr...@gmail.com wrote:
Hi Pascal,
I am not get correct solution from this coding
Please help !!!
On Sat, Nov 24, 2012 at 8:11 PM, bpascal123 bpascal...@gmail.com wrote:
Another shorter programming
Hi Ashish,
Please find attached text files and excel sheet for your reference.
Please let me know if you have any clarifications.
Regards,
Ganesh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor
Sub emailstest()
' run loop here
Dim bdy As String
Dim bdyrng As Range
Dim cl As Range
Set bdyrng = Sheets(1).Range(g2:g50)
For Each cl In bdyrng
bdy = bdy vbNewLine cl.Text
Next
' run loop here
Call send_emails(Range(b2).Text, Range(c2).Text, bdy)
End Sub
Sub send_emails(to1 As
Pls help me solve my query.
I have mentioned my query in the file attached.
Thanks Regards,
Kenil Gala
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Here's what I came up with:
Weekly
From =$A5+1-WEEKDAY($A5,2)
TO =$A5+7-WEEKDAY($A5,2)
Monthly
From =DATEVALUE(MONTH($A5)-1-YEAR($A5))
TO =EOMONTH($A5,0)
Quatrly
From =DATEVALUE(ROUNDUP(MONTH($A5)/3,0)+2*(ROUNDUP(MONTH($A5)/3,0)-1)-1-YEAR($A5))
TO =EOMONTH(I5,2)
Half Yearly
From
check the attachment see if it helps
On Tue, Nov 27, 2012 at 11:14 PM, Kenil Gala keni...@yahoo.com wrote:
Pls help me solve my query.
I have mentioned my query in the file attached.
Thanks Regards,
Kenil Gala
--
Join official Facebook page of this forum @
I do not understand your problem.
You SAID:
I have table that give me sequence as I want..
Everything is fine till I bring numbr forward, like 10.
When I push something backwords is not working, like 9.
What do you mean bring number forward and
push something backwards.
I was able to sort
Hi Ganesh
I have currently too little time until end of week to look at your query.
Just check that everything is on C: path drive and that a folder merge
exist on the same location.
Else, I'll have to look closer.
Regards
Pascal
--
Join official Facebook page of this forum @
Hi,
If year,month,days are in A1,A2,A3 respectively then put the date on which
you want to calculate in A4,
enter the formula in A5(the joining date,if it is one complete spell,
=Date(Year(A4)-(A1),Month(A4)-(A2),Days(A4)-(A3))
R.Karunanithi
From:
Thank you sir! it worked amazing
--- On Wed, 11/28/12, ashish koul koul.ash...@gmail.com wrote:
From: ashish koul koul.ash...@gmail.com
Subject: Re: $$Excel-Macros$$ Small Date Query
To: excel-macros@googlegroups.com
Date: Wednesday, November 28, 2012, 12:30 AM
check the attachment see if it
Hi Experts
I have created a list in Name Manager named TTlist for values shown in
LIST sheet of attached file. I used to update this TTlist with some
other macro.
I have another sheet named TT in which 1st 5 rows are constant. I sued to
fill-in data from 6th row on-wards.
I need a macro which
25 matches
Mail list logo
