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

[NOORAIN ANSARI]

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

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

[NOORAIN ANSARI]

Dear Selva,

Please use below code to add message

Sub Send_Email()
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim mailbody As String
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
With olMail
.To = "noorain.ans...@gmail.com"
.CC = "noorain.ans...@one97.net"
.Subject = "Try it"
.Body = "Dear " & Application.UserName & "," & vbCrLf & vbCrLf & "Please
find the - below -" & vbCrLf & vbCrLf & "Regards," & vbCrLf &
vbCrLf & "Noorain Ansari"
.Attachments.Add ActiveWorkbook.FullName
.Display
'.Send
End With
mailbody = vbNullString
End Sub

-- 
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$$ Email Sheet with message

[LearnExcel]

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

RE: $$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

[Mohammed Muneer]

U r Welcome!

 

Regards,

Muneer,

CC..

 



From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Ferry H Sitohang
Sent: Tuesday, March 13, 2012 3:27 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Goal Seek option from Tools
menu(little urgent)

 

Thanks Muneer..this is good for me

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI
Sent: 12 March, 2012 05:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Goal Seek option from Tools
menu(little urgent)

 

Dear Muneer,

See attached pdf, hope it will help to you

On Mon, Mar 12, 2012 at 1:42 PM, Mohammed Muneer 
wrote:

Dear Group, I want to select multiple cell values(a1 & b1) to change the
target cell "C1".

 

Can I do it like this? Plz suggest?

 

If any formula or code, anyway that can do well plz send.

 

 

Regards,

Muneer,

CC...

 

 

-- 
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,

Noorain Ansari

http://noorainansari.com/

http://excelmacroworld.blogspot.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
<>

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

[Jim]

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

Re: $$Excel-Macros$$ Turn Tab Order on/off

[Cab Boose]

Hi Asa
 At the moment the H1 setting makes no difference. The sheet works like
normal with the setting at activate or deactivate, and not in tab order.
 Thanks
  Charlie


On Sun, Mar 4, 2012 at 10:09 PM, Asa Rossoff  wrote:

> Hi Charlie,
>
> The "button" is actually just a cell that is colored.  It has Data
> Validation enabled for that cell that restricts values to "Activate" and
> "Deactivate".
>
> ** **
>
> The "tab order" macro seems to be pretty straightforward and I would
> expect it to work with Excel 2000, but I am not an expert at what is and is
> not supported.
>
> ** **
>
> The macro moves the selection to the next data entry cell only when a cell
> is edited.  *Not* particularly when tab is pressed.
>
> ** **
>
> Can you confirm that when cell "H1" says "Activate" and you edit one of
> the cells listed at the end of this sentence and hit either tab or enter to
> leave the cell that the selection does not go to the next cell in this
> list: h8, h9, h10, h11, h13, l11, l12, h17, k17, h18, k18, k21, k22, n26,
> n27, n31, k37, e82, f82, h82, j82, e83, f83, h83, j83, e84, f84, h84, j84,
> e85, f85, h85, j85, e86, f86, h86, j86, e87, f87, h87, j87, e88, f88, h88,
> j88, e89, f89, h89, j89?
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Cab Boose
> *Sent:* Saturday, March 03, 2012 10:07 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Turn Tab Order on/off
>
> ** **
>
> HI
>
>  
>
> In attached workbook Ashish has produced a great macro but he is not use
> to XL2000, only later ones.
>
>  
>
> There is a button at top of worksheet to turn on/off the macro that sets
> the tab order.  Not working currently, is there an adjustment to make for
> XL2000 ?
>
> Once going, please check when in tab order mode that if a entry is
> incorrect and user hits delete for that cell that it does not delete info
> in all tabbed cells.
>
>  
>
> Your assistance appreciated.
>
>  
>
> Charlie
>
> --
> 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$$ Saving Excel Macro file to Xls format

[dguillett1]

Just save it as .xls and hope that your macros are BACKWARD compatible. Some 
are NOT. Test!




Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Avinash Daga

Sent: Tuesday, March 13, 2012 10:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Saving Excel Macro file to Xls format

How can I save excel macro file (.XLSM) file to XLS format? and macro
still working in that file?


Thanks and Regards,
Avinash Daga

--
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

[BNS kumar]

Hi,

Please find the attached text file. Copy and paste in that excel file and
run.

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 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
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 

Re: $$Excel-Macros$$ Help Needed

[BNS kumar]

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 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

$$Excel-Macros$$ Saving Excel Macro file to Xls format

[Avinash Daga]

How can I save excel macro file (.XLSM) file to XLS format? and macro
still working in that file?


Thanks and Regards,
Avinash Daga

-- 
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$$ Format data from Tally 7.2

[dguillett1]

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

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

[dguillett1]

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

$$Excel-Macros$$ Macro for format table

[Rajesh K R]

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 & Deletethem
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


TallY Data.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Rajesh K R]

Hi
Thanks for ur reply, but i need a format like which add in attached file.


Regards

Rajesh Kainikkara

On 3/13/12, Aivi  wrote:
> PFA..
>
> ReGaRdS
> AiVrAn kUmAr
>
> On Tue, Mar 13, 2012 at 9:46 AM, Rajesh K R
> wrote:
>
>> 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
>>
>
>
>
> --
> *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
>

-- 
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(2).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

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

[hilary lomotey]

thanks Don

On Mon, Mar 12, 2012 at 7:39 PM, dguillett1  wrote:

>   See if this simpler approach is helpful
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* hilary lomotey 
> *Sent:* Monday, March 12, 2012 10:22 AM
> *To:* excel-macros 
> *Subject:* $$Excel-Macros$$ Logical Formula Problem
>
> 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
>
> --
> 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

[Patil MG]

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