Re: $$Excel-Macros$$ Macro for format table

2012-03-14 Thread Rajesh K R
Hi

Thank u very much.I need some change in the code.

here I want to count the number of  cells deleted in column B here 25 cells
In column C delete 50 cells
In column D delete 75 cells
In column E delete 100 cells.

Please refer the attached file

Regards

Rajesh Kainikkara

On 3/13/12, dguillett1  wrote:
> Should do it
>
> Sub CopyColumnsToTableSAS()
> Dim i As Integer
> Dim fr As Long
> Dim lr As Long
> 'col A
> Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, "g")
> 'other columns
> For i = 2 To 5
> fr = Cells(2, i).End(xlDown).Row
> lr = Cells(Rows.Count, i).End(xlUp).Row
> Cells(fr, i).Resize(lr).Copy Cells(2, i + 6)
> Next i
> End Sub
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message-
> From: Rajesh K R
> Sent: Tuesday, March 13, 2012 8:50 AM
> To: excel-macros
> Subject: $$Excel-Macros$$ Macro for format table
>
> Hi experts
> Find the attached file,and help me to create a macro to format a table
> from the data given.
> My idea to solve this
>
> select column A:E, & paste in G1
> Select blank cells in column B ,here B2:B26 & Delete them
> Repeat the sale in next columns
>
> Regards
>
> Rajesh Kainikkara
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


TallY.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12


Re: $$Excel-Macros$$ Format data from Tally 7.2

2012-03-14 Thread Maries
Hi,

Try below formula,

=IFERROR(INDEX(Table1[DSPVCHDATE],SMALL(IF(Table1[DSPVCHDATE]<>"",ROW(Table1[DSPVCHDATE])-1,""),ROW()-1)),"")

*Apply With Ctrl + Shift + Enter.*

Regards,

MARIES.


On Tue, Mar 13, 2012 at 10:45 PM, dguillett1  wrote:

> I thought I already  responded to this.
>
> Sub CopyColumnsToTableSAS()
> Dim i As Integer
> Dim fr As Long
> Dim lr As Long
> 'col A
> Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, "g")
> 'other columns
> For i = 2 To 5
> fr = Cells(2, i).End(xlDown).Row
> lr = Cells(Rows.Count, i).End(xlUp).Row
> Cells(fr, i).Resize(lr).Copy Cells(2, i + 6)
> Next i
> End Sub
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Rajesh K R
> Sent: Monday, March 12, 2012 11:16 PM
> To: excel-macros
> Subject: $$Excel-Macros$$ Format data from Tally 7.2
>
>
> Hi experts,
>
> I have a large data in Tally 7.2,when i try to I got data in a
> different format, please check the attached file "Sheet 2" and make a
> solution.
>
> Thanks in advance
>
> Rajesh Kainikkara
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --**--**
> --**
> To post to this group, send email to excel-macros@googlegroups.com
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --**--**
> --**
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


TallY_Solved By Maries 14.03.2012.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Macro for format table

2012-03-14 Thread dguillett1

lr = Cells(Rows.Count, i).End(xlUp).Row
'two lines below added.
MsgBox fr - 2
Cells(1, i + 6) = fr - 2
'===
Cells(fr, i).Resize(lr).Copy Cells(2, i + 6)



Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Rajesh K R

Sent: Wednesday, March 14, 2012 3:01 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for format table

Hi

Thank u very much.I need some change in the code.

here I want to count the number of  cells deleted in column B here 25 cells
In column C delete 50 cells
In column D delete 75 cells
In column E delete 100 cells.

Please refer the attached file

Regards

Rajesh Kainikkara

On 3/13/12, dguillett1  wrote:

Should do it

Sub CopyColumnsToTableSAS()
Dim i As Integer
Dim fr As Long
Dim lr As Long
'col A
Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, "g")
'other columns
For i = 2 To 5
fr = Cells(2, i).End(xlDown).Row
lr = Cells(Rows.Count, i).End(xlUp).Row
Cells(fr, i).Resize(lr).Copy Cells(2, i + 6)
Next i
End Sub


Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajesh K R
Sent: Tuesday, March 13, 2012 8:50 AM
To: excel-macros
Subject: $$Excel-Macros$$ Macro for format table

Hi experts
Find the attached file,and help me to create a macro to format a table
from the data given.
My idea to solve this

select column A:E, & paste in G1
Select blank cells in column B ,here B2:B26 & Delete them
Repeat the sale in next columns

Regards

Rajesh Kainikkara

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
will

not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
will

not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com



--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Help Needed

2012-03-14 Thread Patil MG
Dear Sir

I can able to create Notepad files , but i getting following error when
trying to create word files
Run Time Error
User Defined is not found

On Tue, Mar 13, 2012 at 4:39 PM, BNS kumar  wrote:

> Hi,
>
> check this out
>
> Sub CreateWordDocs()
> ' add a reference to the Word-library
> ' this is for creating number word Documents and renaming them with
> file names mentioned in 'C' column
> ' this code doesn't write any content, it just creates word documents
> and saves them
>
> Dim newapp As Word.Application
> Dim newDoc As Word.Document
> Dim xsht As Worksheet
> Dim filename As Range
> Dim xcell As Range
> Dim LastCell As Range
> Dim i As Integer
>
> Set xsht = ActiveWorkbook.Sheets("Sheet1")
> Set LastCell = xsht.Range("C65000").End(xlUp)
>
> If Not LastCell.Row > 1 Then Exit Sub 'condition to check whether
> filename is entered or not
>
> Set filename = xsht.Range("C2:C" & LastCell.Row)
>
> Set newapp = CreateObject("word.application")
> newapp.Visible = True
>
> For Each xcell In filename
>
> Set newDoc = newapp.Documents.Add
>
> With newDoc
> .SaveAs ("D:\New Folder\" & xcell.Value & ".doc") 'instead of
> "D;\New Folder", you can give your own path
> .Close
> End With
> Set newDoc = Nothing
> Next xcell
>
> newapp.Quit
> Set newDoc = Nothing
> Set newapp = Nothing
>
> End Sub
>
>
> --
>
> Sub CreateNotePads()
>
> 'this with create notepads without writing any content in them
>
> Dim fs As Object
> Dim a As Object
> Dim xsht As Worksheet
> Dim filename As Range
> Dim xcell As Range
> Dim LastCell As Range
> Dim i As Integer
>
> Set xsht = Sheets("Sheet1")
> Set LastCell = xsht.Range("C65000").End(xlUp)
>
> If Not LastCell.Row > 1 Then Exit Sub 'condition to check whether
> filename is entered or not
>
> Set filename = xsht.Range("C2:C" & LastCell.Row)
>
> Set fs = CreateObject("scripting.filesystemobject")
>
> For Each xcell In filename
>
> Set a = fs.createtextfile("D:\New Folder\" & xcell.Value & ".txt",
> True) 'give your own path
>
> Set a = Nothing
> Next xcell
>
>
> End Sub
>
>
> Regards
> Kumar
>
>
> On Tue, Mar 13, 2012 at 2:08 PM, Patil MG  wrote:
>
>> Hi All
>>
>> can any one help me pl..its very urgent,,,
>>
>>
>> On Mon, Mar 12, 2012 at 12:52 PM, Patil MG  wrote:
>>
>>> Dear Experts,
>>>
>>> I have to create 'N' number of empty files of word and note pad files,
>>> this word will long time to do can any one help to write a macro where in
>>> which i can create empty word files or note pad files by running the macro,
>>> my files will be listed in excel file (please refer the attached Excel
>>> sheets
>>>
>>> --
>>> Thank You
>>> Patil MG
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Thank You
>> Patil MG
>> 9663374848
>>
>> Life is Very Beautiful!!!
>> ¨`•.•´¨)  Always
>> `•.¸(¨`•.•´¨)  Keep
>> (¨`•.•´¨)¸•´ Smiling!
>>   `•.¸.•´.
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members a

$$Excel-Macros$$ Re: SQL - Query

2012-03-14 Thread bpascal123
Hi there,

I'm not sure the kind of vba code you're looking for.  If it's about
using vlookup, match and so on to retrieve data, so far, i'm not able
to do much just following you sql code. If you want me to help, copy
paste the tables you want to query on and I see


Comments in the code below may help you. It's a simple Excel-Ms Sql
Server connection to update a table using Vba for Excel.

I don't understand advanced sql meanings such as
[SRT1].RequestToolDev.dbo.ReqAMROOS and .ReqMain. Are these tables,
what kind of data, fields? Provide a sample of your tables on a
worksheet if you can then I'll modify the code below to see if it
works.

Cheers,
Pascal Baro



Sub Databases()

'ADO = activex data objects
'data source (SQL database) <--> OLEDB Provider <--> ADO Data objects
'YOU NEED A REFERENCE TO ADO LIBRARY

Dim sSql As String
Dim rs As ADODB.Recordset 'rs holds the data
Dim cn As ADODB.Connection ' declare connection
Dim cmdObj As ADODB.Command 'declare a command object
Dim qf As Object
Dim numberOfRowsAffected As Integer
Dim IDtoUPdate As Integer
Dim varName As String
Dim varAge As Integer

Sheets("sheet1").Select
Cells.Select
Selection.ClearContents

'''SELECT STATEMENT
Set cn = New ADODB.Connection
cn.Open "Provider= SQLOLEDB.1; Integrated Security = SSPI; username =
test; password = test; Initial catalog =MyCompany;Data Source =XXX-PC
\SQLEXPRESS"
sSql = "select id, name, age, date from people"
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient 'who manages the cursor ADO
(adUSEclient) or Server (adUseServer)
rs.Open sSql, cn, adOpenForwardOnly, adLockReadOnly, adCmdText

'check if rs is empty
If rs.EOF Then
MsgBox ("The record set is empty. rs.EOF = " & rs.EOF)
Else
MsgBox ("The number of rows returned from the select statement is : "
& rs.RecordCount)
Range("a1").Select
For Each qf In rs.Fields
Range("a1").Offset(0, coloffset).Value = qf.Name
coloffset = coloffset + 1
Next qf
Range("A2").CopyFromRecordset rs 'send data to worksheet
rs.MoveLast 'go to the last row of the record set
IDtoUPdate = rs.Fields(0) 'Get the ID of the last row
rs.Close 'close the recordset
Set rs = Nothing 'DESTROY THE Recordset

End If

 varName = "xxx"
 varAge = 100
 varDate = "1/1/2005"
'''UPDATE STATEMENT
sSql = "update people set name = '" & varName & "' where id = " &
IDtoUPdate
cn.Execute sSql, numberOfRowsAffected, adCmdText
MsgBox ("Number of Rows Updated = " & numberOfRowsAffected)

INSERT STATEMENT
sSql = "insert into people (name, age, date) values ('bob'," & varAge
& ",'" & varDate & "')"
cn.Execute sSql, numberOfRowsAffected, adCmdText
MsgBox ("Number of Rows Inserted = " & numberOfRowsAffected)

'''DELETE STATEMENT
'sSql = "delete from people where id >6"
'cn.Execute sSql, numberOfRowsAffected, adCmdText
'MsgBox ("Number of Rows Deleted = " & numberOfRowsAffected)

'STORED PROCEDURE that
SELECTS DATA
Set cmdObj = New ADODB.Command
cmdObj.ActiveConnection = cn
cmdObj.CommandType = adCmdStoredProc
cmdObj.CommandText = "GetPeopleData"
Set prm = cmdObj.CreateParameter("id", adInteger, adParamInput)
cmdObj.Parameters.Append prm
cmdObj.Parameters("id").Value = 21

Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient 'sets cursor location ADO
(adUSeClient) or Server (adUSEserver)
rs.CursorType = adOpenStatic 'sets teh cursor type how can the
recordset be manuvered?
rs.LockType = adLockOptimistic 'sets the lock type
rs.Open cmdObj 'this executes the Stored PROC

coloffset = 0
If rs.EOF Then
MsgBox ("The record set is empty. rs.EOF = " & rs.EOF)
Else
Range("f1").Select
For Each qf In rs.Fields
Range("f1").Offset(0, coloffset).Value = qf.Name
coloffset = coloffset + 1
Next qf

'manipulate data in the recordset in memory and in the
Database!!
Do While Not rs.EOF
rs.Fields(1).Value = "changed name" 'this changed the data in
the DB
rs.MoveNext
Loop
rs.MoveFirst 'MOVE BACK TO FIRST RECORD
Range("f2").CopyFromRecordset rs 'send data to worksheet

rs.Close 'close the recordset
Set rs = Nothing 'DESTORY THE record set
End If

cn.Close 'close the connection to the database
Set cn = Nothing 'DESTROY CONNECTION to the database
End Sub

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever pos

Re: $$Excel-Macros$$ Divide Results from 2 Pivot Tables

2012-03-14 Thread Sam Mathai Chacko
There ain't no attachment!

Sam

On Wed, Mar 14, 2012 at 8:51 AM, Jim  wrote:

> I'm trying to divide a value in one Pivot Table by a value in a second
> Table.  Please see the screen shot and the following explanation in
> the attached Word document.
>
> Any ideas? I'm thinking that I may be missing a very obvious alternate
> to solving this problem:
>
>
> "The YTD Booking Rate isn’t the solution since the Pivot Tables change
> and while the names match up row for row in this example, If Sue
> doesn’t book any jobs, her name isn’t in the PT on the right and the
> YTD Booking Rate table to the right is incorrect."
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Help Needed

2012-03-14 Thread Sam Mathai Chacko
Try this

Sub CreateWordDocs()

Dim xsht As Worksheet
Dim rng As Range
Dim lngLoop As Integer

Set xsht = ActiveWorkbook.Worksheets("Sheet1")
lngLoop = xsht.Cells(Rows.Count, 3).End(xlUp).Row

If lngLoop > 1 Then
With CreateObject("Word.Application")
.Visible = True
For Each rng In xsht.Range("C2:C" & lngLoop)
With .Documents.Add
.SaveAs "F:\Folder\" & rng.Value, 16
.Close 0
End With
Next rng
.Quit 0
End With
End If

End Sub

Regards,

Sam Mathai Chacko

On Wed, Mar 14, 2012 at 9:17 PM, Patil MG  wrote:

> Dear Sir
>
> I can able to create Notepad files , but i getting following error when
> trying to create word files
> Run Time Error
> User Defined is not found
>
>
> On Tue, Mar 13, 2012 at 4:39 PM, BNS kumar  wrote:
>
>> Hi,
>>
>> check this out
>>
>> Sub CreateWordDocs()
>> ' add a reference to the Word-library
>> ' this is for creating number word Documents and renaming them with
>> file names mentioned in 'C' column
>> ' this code doesn't write any content, it just creates word documents
>> and saves them
>>
>> Dim newapp As Word.Application
>> Dim newDoc As Word.Document
>> Dim xsht As Worksheet
>> Dim filename As Range
>> Dim xcell As Range
>> Dim LastCell As Range
>> Dim i As Integer
>>
>> Set xsht = ActiveWorkbook.Sheets("Sheet1")
>> Set LastCell = xsht.Range("C65000").End(xlUp)
>>
>> If Not LastCell.Row > 1 Then Exit Sub 'condition to check whether
>> filename is entered or not
>>
>> Set filename = xsht.Range("C2:C" & LastCell.Row)
>>
>> Set newapp = CreateObject("word.application")
>> newapp.Visible = True
>>
>> For Each xcell In filename
>>
>> Set newDoc = newapp.Documents.Add
>>
>> With newDoc
>> .SaveAs ("D:\New Folder\" & xcell.Value & ".doc") 'instead of
>> "D;\New Folder", you can give your own path
>> .Close
>> End With
>> Set newDoc = Nothing
>> Next xcell
>>
>> newapp.Quit
>> Set newDoc = Nothing
>> Set newapp = Nothing
>>
>> End Sub
>>
>>
>> --
>>
>> Sub CreateNotePads()
>>
>> 'this with create notepads without writing any content in them
>>
>> Dim fs As Object
>> Dim a As Object
>> Dim xsht As Worksheet
>> Dim filename As Range
>> Dim xcell As Range
>> Dim LastCell As Range
>> Dim i As Integer
>>
>> Set xsht = Sheets("Sheet1")
>> Set LastCell = xsht.Range("C65000").End(xlUp)
>>
>> If Not LastCell.Row > 1 Then Exit Sub 'condition to check whether
>> filename is entered or not
>>
>> Set filename = xsht.Range("C2:C" & LastCell.Row)
>>
>> Set fs = CreateObject("scripting.filesystemobject")
>>
>> For Each xcell In filename
>>
>> Set a = fs.createtextfile("D:\New Folder\" & xcell.Value &
>> ".txt", True) 'give your own path
>>
>> Set a = Nothing
>> Next xcell
>>
>>
>> End Sub
>>
>>
>> Regards
>> Kumar
>>
>>
>> On Tue, Mar 13, 2012 at 2:08 PM, Patil MG  wrote:
>>
>>> Hi All
>>>
>>> can any one help me pl..its very urgent,,,
>>>
>>>
>>> On Mon, Mar 12, 2012 at 12:52 PM, Patil MG wrote:
>>>
 Dear Experts,

 I have to create 'N' number of empty files of word and note pad files,
 this word will long time to do can any one help to write a macro where in
 which i can create empty word files or note pad files by running the macro,
 my files will be listed in excel file (please refer the attached Excel
 sheets

 --
 Thank You
 Patil MG


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>
>>>
>>> --
>>> Thank You
>>> Patil MG
>>> 9663374848
>>>
>>> Life is Very Beautiful!!!
>>> ¨`•.•´¨)  Always
>>> `•.¸(¨`•.•´¨)  Keep
>>> (¨`•.•´¨)¸•´ Smiling!
>>>   `•.¸.•´.
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles

$$Excel-Macros$$ Sum hours weeks

2012-03-14 Thread ChilExcel
HELP !! please I need help with macro function that sum hours week .

attached excel file

For this example we use in January, but I need it for all months


thx all group


-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


SumHoursWeeks.xlsm
Description: Binary data


RE: $$Excel-Macros$$ SQL - Query

2012-03-14 Thread Asa Rossoff
Hi Sharma,

How do you define failure for the first query?  0 records returned?  an
error from the database server/engine?

 

What do you want to do with the result of the query?  Put it on a (new?)
sheet in your workbook?

*writing* the queries using VBA is very simple.  The following assembles the
first query statement in a string variable:

Sub WriteSQLquery ()

Dim SQL As String

SQL = _

"SELECT " & _

"  distinct AMRCostCtr " & _

"FROM " & _

"  [SRT1].[RequestToolDev].[dbo].[vReqsocs] a, " & _

"  [SRT1].[RequestToolDev].[dbo].[ReqMain] b " & _

"WHERE " & _

"  a.ReqID = b.ReqID and MainRequestNumber = '365700';"

End Sub

 

Here's a robust-looking, general-purpose procedure called SQLLoad to open a
recordset for your query and copy the data to a worksheet: Beyond Excel -
Say Goodbye to QueryTables
 .  The associated blog actually contains a lot of good information
and code for working with databases from Excel (some of it advanced).

 

You will need a connection string to identify your data source and (if
needed) credentials.  Connectionstrings.com
  has a large index of connection string
examples.  You should avoid Microsoft Jet connection strings and in cases
where there are alternatives, ODBC connection strings, which have been
replaced by newer drivers.  (ODBC is still fine and commonly used with many
non-Microsoft data stores).

 

See if the above info gets you started.  I can provide more help if needed.

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amrahs k
Sent: Friday, March 09, 2012 7:59 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SQL - Query

 

Hi Folks,

 

Please guide me to write the below sql queries using vba macros.

 

SELECT

distinct AMRCostCtr 

FROM

[SRT1].[RequestToolDev].[dbo].[vReqsocs]
a,[SRT1].[RequestToolDev].[dbo].[ReqMain] b 

where

a.ReqID = b.ReqID and MainRequestNumber = '365700' 

If above query fails need to run the next query as given below.

 

SELECT

StationBranch 

FROM

[SRT1].RequestToolDev.dbo.ReqAMROOS 

WHERE

ReqID in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain 

where

mainrequestnumber = '365700') 

Thanks,

Sharma

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Email Sheet with message

2012-03-14 Thread Muhammad Talal Akbar
Hi
Mr. Ansari

how are you? My dear i need your help

can u guide me; how can i improve my skills in excel and VBA


regards,

On Wed, Mar 14, 2012 at 11:20 AM, NOORAIN ANSARI
wrote:

> Please add Outlook library before run the code
>
> Tools-Reference-Microsoft Outlook 12.0 Object Library.
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
> On Wed, Mar 14, 2012 at 11:13 AM, LearnExcel  wrote:
>
>> i'm using the following code to send email how do i add something to the
>> body?
>>
>>
>> does anyone know if its possible to add a message to the email?
>>
>>   ThisWorkbook.Sheets(1).Copy
>>
>> With ActiveWorkbook
>>
>>  .SendMail Recipients:="emailaddr...@df.com", _
>>
>>   Subject:="Try Me")
>>
>>  .Close SaveChanges:=False
>>
>> End With
>>
>>
>> *End Sub*
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


$$Excel-Macros$$ Re: Logical Formula Problem

2012-03-14 Thread CoRe
Hello, new around here ..

here is something that might help you...



luni, 12 martie 2012, 17:22:04 UTC+2, hilary lomotey a scris:
>
> Hi Experts
>
> i am trying to use the logical formula ie <  or > operator to have an 
> outcome such that if the figure in say cell A is greater than that of  cell 
> B, i want it to read is higher than, if false then lesser than, this would 
> be achieved by selecting the year from the drop down, i have done all than 
> but its not working, pls see the attached sheet and assist.
>
> Specifically, in 2009 Operating margin was lower than in 2008, but am not 
> getting the desired outcome.
>
> thanks 
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Logical+Formula+Problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ How to sort horizontaly a line of cells (values) in ascending order ?

2012-03-14 Thread Jean PIERRE
EUROPE - Belgium

Hi,

I would like to do a sorting of cells (values) horizontaly in
ascending order !
There are many lines to sort !
Which is the VBA code ?
Thank you for your help !
Regards,

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


$$Excel-Macros$$ Re: Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread LearnExcel
Thanks guys I want to thank everone on this site for making us feel welcome 
and open to answer any questions keep up the great work
 
 

On Wednesday, 14 March 2012 17:49:30 UTC-5, Ayush wrote:

>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of 
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his 
> expertise. He has been consistent contributor to this excel forum but has 
> acheived this recognition for third time.
>  
> *About Noorain Ansari :*
> [image: noorain.jpg]
>  
> Noorain is a great poet and keep sharing his thoughts on different topics 
> throgh cool poems. Professionally, he is a Excel aficionado and presently 
> working as senior business analyst in One97 Communication Ltd. He is a MS 
> excel - vba expert and keep sharing his thoughts with this forum. You can 
> follow his blogs for Excel knowledge and cool poems : 
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>  
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up 
> !!
> ** 
> *Keep posting.
>  
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Email Sheet with message

2012-03-14 Thread LearnExcel
thanks buddy i'll give this a try
 

On Wednesday, 14 March 2012 01:20:52 UTC-5, NOORAIN ANSARI wrote:

> Please add Outlook library before run the code
>  
> Tools-Reference-Microsoft Outlook 12.0 Object Library.
>
> -- 
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*
> On Wed, Mar 14, 2012 at 11:13 AM, LearnExcel  wrote:
>
>> i'm using the following code to send email how do i add something to the 
>> body?  
>>
>>
>> does anyone know if its possible to add a message to the email?
>>
>>   ThisWorkbook.Sheets(1).Copy
>>
>> With ActiveWorkbook
>>
>>  .SendMail Recipients:="emailaddr...@df.com", _
>>
>>   Subject:="Try Me")
>>
>>  .Close SaveChanges:=False
>>
>> End With
>>
>> 
>> *End Sub*
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>  
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


$$Excel-Macros$$ Re: Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread anandydr
Considering his work for the past few months.. could we recommend him
for next MVP 

On Mar 15, 3:49 am, Ayush Jain  wrote:
>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems 
> :www.excel-macro.blogspot.com&www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
>  noorain.jpg
> 2KViewDownload

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Venkat CV
Congrats Noorain:)

On 3/15/12, Ayush Jain  wrote:
>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


-- 
 *Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*
*
*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Veeru TOC
Congrats  Noorain Sir,,

On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain  wrote:

>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
> !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 





*Thanks&Regards*

* *

*   **Veerendra.Vanam*

  *TOC TEAM*
* *  *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
  Hyderabad-500072,-Andhra Pradesh
**   **91-9177-444-840**,*

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

$$Excel-Macros$$ Help:Open all excel files in folder

2012-03-14 Thread venkat1.sql
Dear All,

i want to get opened all excel files in certain folder by using vba coding.

 
Regards
venkat
Chennai 
 --
Sent from my Nokia phone

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Seraj Alam
Congrats noorain bhai.
[?][?][?][?][?]



On Wed, Mar 14, 2012 at 3:49 PM, Ayush Jain  wrote:

>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
> !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<><>

Re: $$Excel-Macros$$ How to sort horizontaly a line of cells (values) in ascending order ?

2012-03-14 Thread venkat1.sql
Hi ,
if you are using 2007 or 2010 you can use default sort option with multiple 
criterias.

 --
Sent from my Nokia phone

--Original message--
From: Jean PIERRE 
To: "MS EXCEL AND VBA MACROS" 
Date: Wednesday, March 14, 2012 2:53:17 PM GMT-0700
Subject: $$Excel-Macros$$ How to sort horizontaly a line of cells (values) in 
ascending order ?

EUROPE - Belgium

Hi,

I would like to do a sorting of cells (values) horizontaly in
ascending order !
There are many lines to sort !
Which is the VBA code ?
Thank you for your help !
Regards,

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Aivi
Congratulation Noorain..

On Thu, Mar 15, 2012 at 9:38 AM, Seraj Alam  wrote:

> Congrats noorain bhai.
> [?][?][?][?][?]
>
>
>
> On Wed, Mar 14, 2012 at 3:49 PM, Ayush Jain  wrote:
>
>>  Hello Everyone,
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>> of Feb'12
>> He has posted 156 posts in Feb'12 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum but has
>> acheived this recognition for third time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
>> !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Thanks & Regards
*
*Aivran kumar
*E-mail:- aivran...@gmail.com
http://facebook.aivik1

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<><>

RE: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Asa Rossoff
Congratulations Noorain!

Great contribution!

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Wednesday, March 14, 2012 3:50 PM
To: excel-macros
Subject: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

 

Hello Everyone,


Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many people through his
expertise. He has been consistent contributor to this excel forum but has
acheived this recognition for third time.

 

About Noorain Ansari :

noorain.jpg

 

Noorain is a great poet and keep sharing his thoughts on different topics
throgh cool poems. Professionally, he is a Excel aficionado and presently
working as senior business analyst in One97 Communication Ltd. He is a MS
excel - vba expert and keep sharing his thoughts with this forum. You can
follow his blogs for Excel knowledge and cool poems :
www.excel-macro.blogspot.com   &
www.noorain-ansari.blogspot.com  

 

Noorain, Many thanks for all your great support to group. Keep it up


Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up !!
 
Keep posting.
 
Regards
Ayush Jain
Group Manager

Microsoft MVP

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Subhash Yadav
Congrats Noorain Keep it up

On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain  wrote:

>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
> !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Subhash Chand Yadav

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Muhammad Arslan
congratulation noorain ansari
may allah good reward for this.

On Thu, Mar 15, 2012 at 9:40 AM, Subhash Yadav  wrote:

> Congrats Noorain Keep it up
>
> On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain  wrote:
>
>>  Hello Everyone,
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>> of Feb'12
>> He has posted 156 posts in Feb'12 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum but has
>> acheived this recognition for third time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
>> !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Subhash Chand Yadav
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ Macro for format table

2012-03-14 Thread Rajesh K R
Hi
Thank u for ur reply, still I need some more changes in the code, pls
check the attached xl file, it will show step by step what to do.pls
make the necessary change in the code for getting the result.
Sub CopyColumnsToTableSAS()
Dim i As Integer
Dim fr As Long
Dim lr As Long
'col A
Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, "g")
'other columns
For i = 2 To 5
fr = Cells(2, i).End(xlDown).Row
lr = Cells(Rows.Count, i).End(xlUp).Row
r = Cells(Rows.Count, i).End(xlUp).Row
'two lines below added.
MsgBox fr - 2
Cells(1, i + 6) = fr - 2
'===
Cells(fr, i).Resize(lr).Copy Cells(2, i + 6)
Next i
End Sub


Regards

Rajesh Kainikkara

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


TallY(3).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12


Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Sanjib Chatterjee
Congratulation for you achievement. Hoping for a good luck.

sanjib

On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain  wrote:

>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
> !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Maries
Congrats Brother..

On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

> Congratulation for you achievement. Hoping for a good luck.
>
> sanjib
>
> On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain  wrote:
>
>>  Hello Everyone,
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>> of Feb'12
>> He has posted 156 posts in Feb'12 and helped many people through his
>> expertise. He has been consistent contributor to this excel forum but has
>> acheived this recognition for third time.
>>
>> *About Noorain Ansari :*
>> [image: noorain.jpg]
>>
>> Noorain is a great poet and keep sharing his thoughts on different topics
>> throgh cool poems. Professionally, he is a Excel aficionado and presently
>> working as senior business analyst in One97 Communication Ltd. He is a MS
>> excel - vba expert and keep sharing his thoughts with this forum. You can
>> follow his blogs for Excel knowledge and cool poems :
>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>
>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>
>> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
>> !!
>> **
>> *Keep posting.
>>
>> Regards
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> -
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Abhishek Jain
Many congratulations Noorain bro!

Keep up the good work and keep helping us mere mortals in excelling our
lives. :)

God bless

On Thu, Mar 15, 2012 at 11:23 AM, Maries  wrote:

> Congrats Brother..
>
>
> On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Congratulation for you achievement. Hoping for a good luck.
>>
>> sanjib
>>
>> On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote:
>>
>>>  Hello Everyone,
>>>
>>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>>> of Feb'12
>>> He has posted 156 posts in Feb'12 and helped many people through his
>>> expertise. He has been consistent contributor to this excel forum but has
>>> acheived this recognition for third time.
>>>
>>> *About Noorain Ansari :*
>>> [image: noorain.jpg]
>>>
>>> Noorain is a great poet and keep sharing his thoughts on different
>>> topics throgh cool poems. Professionally, he is a Excel aficionado and
>>> presently working as senior business analyst in One97 Communication Ltd. He
>>> is a MS excel - vba expert and keep sharing his thoughts with this forum.
>>> You can follow his blogs for Excel knowledge and cool poems :
>>> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>>>
>>> *Noorain, Many thanks for all your great support to group. Keep it up*
>>>
>>> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it
>>> up !!
>>> **
>>> *Keep posting.
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> -
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Dilip Pandey
Congratulations Noorain

Keep up the good work and keep helping :)

Regards,
DILIPandey

On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain wrote:

> Many congratulations Noorain bro!
>
> Keep up the good work and keep helping us mere mortals in excelling our
> lives. :)
>
> God bless
>
>
> On Thu, Mar 15, 2012 at 11:23 AM, Maries  wrote:
>
>> Congrats Brother..
>>
>>
>> On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>> Congratulation for you achievement. Hoping for a good luck.
>>>
>>> sanjib
>>>
>>> On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote:
>>>
  Hello Everyone,

 Noorain Ansari has been selected as 'Most Helpful Member' for the month
 of Feb'12
 He has posted 156 posts in Feb'12 and helped many people through his
 expertise. He has been consistent contributor to this excel forum but has
 acheived this recognition for third time.

 *About Noorain Ansari :*
 [image: noorain.jpg]

 Noorain is a great poet and keep sharing his thoughts on different
 topics throgh cool poems. Professionally, he is a Excel aficionado and
 presently working as senior business analyst in One97 Communication Ltd. He
 is a MS excel - vba expert and keep sharing his thoughts with this forum.
 You can follow his blogs for Excel knowledge and cool poems :
 www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com

 *Noorain, Many thanks for all your great support to group. Keep it up*

 *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it
 up !!
 **
 *Keep posting.

 Regards
 Ayush Jain
 Group Manager
 Microsoft MVP

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>
>>>
>>> --
>>> -
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4)

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread jmothilal
Congratulation Noorain.


Mothilal.J
Universal Computer\
Vellore -2





On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey  wrote:

> Congratulations Noorain
>
> Keep up the good work and keep helping :)
>
> Regards,
> DILIPandey
>
>
> On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain wrote:
>
>> Many congratulations Noorain bro!
>>
>> Keep up the good work and keep helping us mere mortals in excelling our
>> lives. :)
>>
>> God bless
>>
>>
>> On Thu, Mar 15, 2012 at 11:23 AM, Maries  wrote:
>>
>>> Congrats Brother..
>>>
>>>
>>> On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
 Congratulation for you achievement. Hoping for a good luck.

 sanjib

 On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote:

>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the
> month of Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different
> topics throgh cool poems. Professionally, he is a Excel aficionado and
> presently working as senior business analyst in One97 Communication Ltd. 
> He
> is a MS excel - vba expert and keep sharing his thoughts with this forum.
> You can follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it
> up !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



 --
 -

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like 

$$Excel-Macros$$

2012-03-14 Thread Aivi
Hi Excel group,
I want to know that in MS-Access have automatic backup option acutaly i am
working in access file daily wise so i want to take backup daily wise
automatically

anybody help

Thanks in Advance

Noorain Sir,Please solve my problem

-- 
*Thanks & Regards
*
*Aivran kumar
*E-mail:- aivran...@gmail.com
http://facebook.aivik1

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Re: $$Excel-Macros$$ Help:Open all excel files in folder

2012-03-14 Thread NOORAIN ANSARI
Dear Venkat,

Please use

First goto VB Editor and Select Tools-Reference-Microsfot Scripting Runtime
then run Macro

Change red color Folder Path...

Sub OpenFile_Of_Folder()
 Dim MyFile As File
 Dim MyFolder As Folder
 Dim fso As Scripting.FileSystemObject
 Set fso = New Scripting.FileSystemObject
 Set MyFolder = fso.GetFolder("D:\VBA_Class\")
 For Each MyFile In MyFolder.Files
 Workbooks.Open Filename:=MyFile
Next
End Sub

-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/* 
*http://excelmacroworld.blogspot.com/*
On Thu, Mar 15, 2012 at 9:35 AM,  wrote:

> Dear All,
>
> i want to get opened all excel files in certain folder by using vba coding.
>
>
> Regards
> venkat
> Chennai
>  --
> Sent from my Nokia phone
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com