$$Excel-Macros$$ Require function for lookup value on condition.
Dear experts, I require function to lookup value on consider of two particular condition. Pls. see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. query of lookup value.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Data handling
Dear Vaibhav Thankls very much working fine problem solved Thanks once again Regards Shrinivas On Wed, Feb 4, 2015 at 12:12 PM, Vaibhav Joshi wrote: > Hi Sri > > Check this... > > > You need to delete column B once you get data from Macro.. > > Cheers!! > > On Wed, Feb 4, 2015 at 10:30 AM, Shrinivas Shevde > wrote: > >> Dear Paul/Vaibhav >> Thanks for reply. >> >> *To Vaibhav,* >> Macro you send is just merging the data from all sheets in one sheet.My >> requirement is something different which I tried to explain below >> >> To Paul, >> Do you have any experience with macros? *Yes but I can write very basic >> macro.* >> or are you asking one of us to CREATE one and show you how to use it? *As >> i answerd first question it will be better if someone write and give it to >> me * >> (which is POSSIBLE, but implies more of a time commitment) >> *.Ok * >> to do either, we'd need to know what your two worksheets look like and >> what exactly you want the results to look like. >> >> *About My requirement.(To vaibhav and Paul)* >> Threae are 2/3 sheets Trial 1 and Trial 2 and so on which contents same >> no of rows basically sheets are exactly same only data will be vary.For >> exapmle we will consider there are 2 sheets. >> Now I want data of both sheets in one sheet in following way. >> Suppose there are 10 rows in each sheet (Rows 1 to rows 10),then there >> will be 20 rows in results sheet. >> In resuts sheet there will be 1st row from 1st sheet then 1st row from >> 2nd sheet then 2nd row from 1st sheet then 2nd row from 2nd sheet and so >> on. >> >> In case of any more doubt please ask >> >> Thanks once again >> >> Regards >> Shrinivas >> >> >> >> >> On Tue, Feb 3, 2015 at 6:42 PM, Vaibhav Joshi wrote: >> >>> Hi >>> >>> Use this sheet to merge all sheets data in one sheet.. >>> >>> Cheers!! >>> >>> On Tue, Feb 3, 2015 at 1:02 PM, Shrinivas Shevde >> > wrote: >>> Dear All Please help me for following problem I used to get the data in 2 sheets Trial1 and Trial 2 I need to conoslidate this data in 3rd sheet "results" It is very time consuming process.As I need to insert row after every row of Trial 1 and copy paste from Trial 2 (there are more than 150 lines ) So can any one give me macro for this activity. Thanks in advance Regards -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For mo
Re: $$Excel-Macros$$ Move Sheets by Worksheet Index
Thanks a lot sir. It works perfectly.
*Thanks,*
*Nilkanth Raval*
*+91 900 428 0 428*
*+91 808 000 1620*
*Think Before You Print.Consider ENVIRONMENT.*
*“SAVE TREES, SAVE EARTH” *
*“All appears to change when we change!”*
On 6 February 2015 at 00:42, Paul Schreiner wrote:
> The problem is that the first time a duplicate is encountered, instead of
> ADDING it to an existing workbook, you're trying to create a new one.
>
> Instead, I'd wait until they're all done before closing the workbooks.
> Then, within the code, only create a workbook if it isn't already open.
>
> I'd modify the code to look like:
>
> Option Explicit
> Sub movesheets()
> Dim Mainrng As Range
> Dim LR As Double
> Dim i As Integer
> Dim Oldwkb As Workbook
> Dim Newwkb As Workbook
> Dim srt As String
>
> Set Oldwkb = ActiveWorkbook
>
> LR = Cells(Rows.Count, 1).End(xlUp).Row
>
> 'Set Mainrng = Range("a1").Offset(0, 1).Resize(LR, 1)
>
> Application.DisplayAlerts = False
> i = 2
> On Error Resume Next
> Do Until Cells(i, "B") = ""
>
> srt = Cells(i, "C").Value
> Err.Clear
> Workbooks(srt & ".xlsx").Activate
> If (Err.Number <> 0) Then
> Set Newwkb = Workbooks.Add
> Else
> Set Newwkb = ActiveWorkbook
> End If
> Oldwkb.Activate
> Worksheets(Cells(i, "A").Value).Copy Before:=Newwkb.Worksheets(1)
> If (Newwkb.Name <> srt & ".xlsx") Then
> Newwkb.SaveAs Oldwkb.Path & "\" & srt & ".xlsx"
> Else
> Newwkb.Save
> End If
> 'Newwkb.Close True
> Oldwkb.Activate
> If (Cells(i, "B").Value = "Move") Then Sheets(Cells(i,
> "A").Value).Delete
> i = i + 1
> Loop
>
> For i = 2 To 100
> If (Cells(i, "B").Value = "") Then Exit For
> Workbooks(Cells(i, "C").Value & ".xlsx").Close savechanges:=True
> Next i
> Application.DisplayAlerts = True
> End Sub
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Nilkanth Raval
> *To:* excel-macros@googlegroups.com; Vaibhav Joshi
> *Sent:* Thursday, February 5, 2015 1:19 PM
> *Subject:* $$Excel-Macros$$ Move Sheets by Worksheet Index
>
> Hello Sir,
>
> I have attached the excel file which contains sheets & worksheet index i.e
> Summary
>
> In Worksheet Index tab
>
> Column A contains the sheet name
> Column B contains move or copy sheet
> Column C contains Workbook name to be created.
>
> I want to move or copy sheet based on table.
>
> I wrote the code but this work only if workbook name in Column C is
> different but does not work if column C contains the same workbook name.
>
> Please help.
>
> *Thanks,*
> *Nilkanth Raval*
> *+91 900 428 0 428*
> *+91 808 000 1620*
> *Think Before You Print.Consider ENVIRONMENT.*
> *“SAVE TREES, SAVE EARTH” *
>
> *“All appears to change when we change!”*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>--
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, 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) Ackn
Re: $$Excel-Macros$$ Move Sheets by Worksheet Index
The problem is that the first time a duplicate is encountered, instead of
ADDING it to an existing workbook, you're trying to create a new one.
Instead, I'd wait until they're all done before closing the workbooks.
Then, within the code, only create a workbook if it isn't already open.
I'd modify the code to look like:
Option Explicit
Sub movesheets()
Dim Mainrng As Range
Dim LR As Double
Dim i As Integer
Dim Oldwkb As Workbook
Dim Newwkb As Workbook
Dim srt As String
Set Oldwkb = ActiveWorkbook
LR = Cells(Rows.Count, 1).End(xlUp).Row
'Set Mainrng = Range("a1").Offset(0, 1).Resize(LR, 1)
Application.DisplayAlerts = False
i = 2
On Error Resume Next
Do Until Cells(i, "B") = ""
srt = Cells(i, "C").Value
Err.Clear
Workbooks(srt & ".xlsx").Activate
If (Err.Number <> 0) Then
Set Newwkb = Workbooks.Add
Else
Set Newwkb = ActiveWorkbook
End If
Oldwkb.Activate
Worksheets(Cells(i, "A").Value).Copy Before:=Newwkb.Worksheets(1)
If (Newwkb.Name <> srt & ".xlsx") Then
Newwkb.SaveAs Oldwkb.Path & "\" & srt & ".xlsx"
Else
Newwkb.Save
End If
'Newwkb.Close True
Oldwkb.Activate
If (Cells(i, "B").Value = "Move") Then Sheets(Cells(i,
"A").Value).Delete
i = i + 1
Loop
For i = 2 To 100
If (Cells(i, "B").Value = "") Then Exit For
Workbooks(Cells(i, "C").Value & ".xlsx").Close savechanges:=True
Next i
Application.DisplayAlerts = True
End Sub
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Nilkanth Raval
>To: excel-macros@googlegroups.com; Vaibhav Joshi
>Sent: Thursday, February 5, 2015 1:19 PM
>Subject: $$Excel-Macros$$ Move Sheets by Worksheet Index
>
>
>
>Hello Sir,
>
>
>I have attached the excel file which contains sheets & worksheet index i.e
>Summary
>
>
>In Worksheet Index tab
>
>
>Column A contains the sheet name
>Column B contains move or copy sheet
>Column C contains Workbook name to be created.
>
>
>I want to move or copy sheet based on table.
>
>
>I wrote the code but this work only if workbook name in Column C is different
>but does not work if column C contains the same workbook name.
>
>
>Please help.
>
>
>Thanks,
>Nilkanth Raval
>+91 900 428 0 428
>+91 808 000 1620
>Think Before You Print.Consider ENVIRONMENT.
>“SAVE TREES, SAVE EARTH”
>
>“All appears to change when we change!”
>
>
--
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>https://www.facebook.com/discussexcel
>
>FORUM RULES
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
>Urgent, 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) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
>
>NOTE : Don't ever post confidential data in a workbook. Forum owners and
>members are not responsible for any loss.
>---
>You received this message because you are subscribed to the Google Groups "MS
>EXCEL AND VBA MACROS" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, 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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving
$$Excel-Macros$$ Move Sheets by Worksheet Index
Hello Sir, I have attached the excel file which contains sheets & worksheet index i.e Summary In Worksheet Index tab Column A contains the sheet name Column B contains move or copy sheet Column C contains Workbook name to be created. I want to move or copy sheet based on table. I wrote the code but this work only if workbook name in Column C is different but does not work if column C contains the same workbook name. Please help. *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE EARTH” * *“All appears to change when we change!”* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Move Sheets by Index.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Date not Correct, List of Tabs, Hide Exit X
This time code is working ok, what exactly you want please share in Excel
Sheet..
On Thu, Feb 5, 2015 at 8:35 PM, Vaibhav Joshi wrote:
> Check this on how to disable close button:
>
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=164
>
> http://www.contextures.com/xlUserForm01.html
>
> Cheers!!
>
>
> On Mon, Feb 2, 2015 at 7:11 AM, sswcharlie wrote:
>
>> Hi
>> Excel 2000
>> Three small questions as to these small codes not working.
>>
>> Want to make a new sheet and list all sheets with hyperlink to each sheet.
>>
>> Code curteosy of member of this group. (slips my mind at the moment
>> apologies)
>>
>>
>> Sub MakeHyperlinkIndex()
>>
>> Dim ndx As Worksheet, X As Integer
>>
>> Set ndx = Sheets.Add(before:=Sheets(1))
>>
>> ndx.Name = "Index"
>>
>> ndx.Cells(1) = "Worksheets"
>>
>> For X = 2 To Worksheets.Count
>>
>> ndx.Hyperlinks.Add
>>
>> Anchor:=ndx.Cells(X, 1), Address:=""_
>>
>> SubAddress:="'" &
>> Worksheets(X).Name & "'!A1",_
>>
>> TextToDisplay:=Worksheets(X).Name
>>
>> Next X
>>
>> End Sub
>>
>> Gets to thendx.HyperLinks.Add
>>
>>
>> **
>>
>> With this I am trying to hide the exit cross button. Not sure if I have
>> the 'select' correct.
>>
>> Private Sub UserForm_Initialize()
>>
>> Dim UserForm As Integer
>>
>> Dim HideCloseButton As Integer
>>
>> UserForm("RegArea").Select
>>
>>HideCloseButton Me
>>
>> End With
>>
>> End Sub
>>
>>
>>
>> This is working ok with the vba but the date that shows in the formatted
>> date column is
>> 00Jan00!. The clock in Windows 7 shows correct time. Is there anything in
>> XL that I need to check?
>>
>> Private Sub Worksheet_Change(ByVal Target As
>> Range)
>>
>> If Target.Column = 3 And Target.Offset(0,
>> -1).Value = "" Then
>>
>> Target.Offset(0, -1) = Format(Now(),
>> "DD:MM:YY")
>> End If
>>
>>
>> End Sub
>> *
>>
>> Thankyou
>>
>> Charles Harris
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, 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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Date not Correct, List of Tabs, Hide Exit X
Check this on how to disable close button:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=164
http://www.contextures.com/xlUserForm01.html
Cheers!!
On Mon, Feb 2, 2015 at 7:11 AM, sswcharlie wrote:
> Hi
> Excel 2000
> Three small questions as to these small codes not working.
>
> Want to make a new sheet and list all sheets with hyperlink to each sheet.
>
> Code curteosy of member of this group. (slips my mind at the moment
> apologies)
>
>
> Sub MakeHyperlinkIndex()
>
> Dim ndx As Worksheet, X As Integer
>
> Set ndx = Sheets.Add(before:=Sheets(1))
>
> ndx.Name = "Index"
>
> ndx.Cells(1) = "Worksheets"
>
> For X = 2 To Worksheets.Count
>
> ndx.Hyperlinks.Add
>
> Anchor:=ndx.Cells(X, 1), Address:=""_
>
> SubAddress:="'" &
> Worksheets(X).Name & "'!A1",_
>
> TextToDisplay:=Worksheets(X).Name
>
> Next X
>
> End Sub
>
> Gets to thendx.HyperLinks.Add
>
>
> **
>
> With this I am trying to hide the exit cross button. Not sure if I have
> the 'select' correct.
>
> Private Sub UserForm_Initialize()
>
> Dim UserForm As Integer
>
> Dim HideCloseButton As Integer
>
> UserForm("RegArea").Select
>
>HideCloseButton Me
>
> End With
>
> End Sub
>
>
>
> This is working ok with the vba but the date that shows in the formatted date
> column is
> 00Jan00!. The clock in Windows 7 shows correct time. Is there anything in
> XL that I need to check?
>
> Private Sub Worksheet_Change(ByVal Target As
> Range)
>
> If Target.Column = 3 And Target.Offset(0,
> -1).Value = "" Then
>
> Target.Offset(0, -1) = Format(Now(),
> "DD:MM:YY")
> End If
>
>
> End Sub
> *
>
> Thankyou
>
> Charles Harris
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, 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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ MOS Certificate Query
HI MV, Check this : http://education-portal.com/microsoft_office_specialist_certification_online.html Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Date not Correct, List of Tabs, Hide Exit X
Hi
Use following code for creating Index:
Worksheet Index
First add a new sheet to the Workbook and call it "Index" (optional).
Next right click on the sheet name tab of the "Index" sheet and select
"View Code". In here you should paste the code as shown below
Private Sub Worksheet_Activate()
Dim wSheet As Worksheet
Dim l As Long
l = 1
With Me
.Columns(1).ClearContents
.Cells(1, 1) = "INDEX"
.Cells(1, 1).Name = "Index"
End With
For Each wSheet In Worksheets
If wSheet.Name <> Me.Name Then
l = l + 1
With wSheet
.Range("A1").Name = "Start_" & wSheet.Index
.Hyperlinks.Add Anchor:=.Range("A1"), Address:="", _
SubAddress:="Index", TextToDisplay:="Back to Index"
End With
Me.Hyperlinks.Add Anchor:=Me.Cells(l, 1), Address:="", _
SubAddress:="Start_" & wSheet.Index, TextToDisplay:=wSheet.Name
End If
Next wSheet
End Sub
Cheers!!
On Mon, Feb 2, 2015 at 7:11 AM, sswcharlie wrote:
> Hi
> Excel 2000
> Three small questions as to these small codes not working.
>
> Want to make a new sheet and list all sheets with hyperlink to each sheet.
>
> Code curteosy of member of this group. (slips my mind at the moment
> apologies)
>
>
> Sub MakeHyperlinkIndex()
>
> Dim ndx As Worksheet, X As Integer
>
> Set ndx = Sheets.Add(before:=Sheets(1))
>
> ndx.Name = "Index"
>
> ndx.Cells(1) = "Worksheets"
>
> For X = 2 To Worksheets.Count
>
> ndx.Hyperlinks.Add
>
> Anchor:=ndx.Cells(X, 1), Address:=""_
>
> SubAddress:="'" &
> Worksheets(X).Name & "'!A1",_
>
> TextToDisplay:=Worksheets(X).Name
>
> Next X
>
> End Sub
>
> Gets to thendx.HyperLinks.Add
>
>
> **
>
> With this I am trying to hide the exit cross button. Not sure if I have
> the 'select' correct.
>
> Private Sub UserForm_Initialize()
>
> Dim UserForm As Integer
>
> Dim HideCloseButton As Integer
>
> UserForm("RegArea").Select
>
>HideCloseButton Me
>
> End With
>
> End Sub
>
>
>
> This is working ok with the vba but the date that shows in the formatted date
> column is
> 00Jan00!. The clock in Windows 7 shows correct time. Is there anything in
> XL that I need to check?
>
> Private Sub Worksheet_Change(ByVal Target As
> Range)
>
> If Target.Column = 3 And Target.Offset(0,
> -1).Value = "" Then
>
> Target.Offset(0, -1) = Format(Now(),
> "DD:MM:YY")
> End If
>
>
> End Sub
> *
>
> Thankyou
>
> Charles Harris
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, 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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at ht
$$Excel-Macros$$ MOS Certificate Query
Hi All, I would like to go for a MOS Certificate in excel 2007. I need some support for the following queries. how to approach on this exam? What would be the syllabus? Is there any fees details available? Please share your thoughts and comments. Wish you all a Great day. Thank you MV -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Unable to run macro in attached excel file
I opened the file and it opened as I would expect. Your error message implies that your computer "profile" is set to NOT allow something here to happen. Can you run macros in ANY workbook using this computer? Can you open the VB Editor and look at the macros in this workbook? Can you step through the Workbook_Open event macro in the ThisWorkbook module? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Pravin Gunjal >To: Excel Macros >Sent: Thursday, February 5, 2015 3:26 AM >Subject: $$Excel-Macros$$ Unable to run macro in attached excel file > > > >Hi, > > >Getting the following error in attached file and unable to run macro. > > >Pl help to resolve. >> >> >> >> >> >> >> >> >> >> >>Regards >> >>Pravin Gunjal >> >> >> >> >-- >Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, 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) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To unsubscribe from this group and stop receiving emails from it, send an >email to excel-macros+unsubscr...@googlegroups.com. >To post to this group, send email to excel-macros@googlegroups.com. >Visit this group at http://groups.google.com/group/excel-macros. >For more options, visit https://groups.google.com/d/optout. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Macro Required
yes, you an do it... On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna wrote: > Ok Vaibhav. Even though I have very little idea about VB (Just read the > codes and try to understand them) I will give it a shot. > > On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote: > >> i want you to work on present requirement... >> >> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna < >> kanwal...@gmail.com> wrote: >> >>> Ok Sir, I will do that. >>> >>> I hope I am clear on my present question. >>> >>> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: >>> You want to learn VBA then start modifying last code which i sent to you to accommodate it.. Start & letus know when you get error.. Cheers!! On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < kanwal...@gmail.com> wrote: > Hi Experts, > > I have attached a sheet. > I wish there could be a macro which when run > --assess the website given in column A1, > --copy the value given in cell A4 in the input box > --wait for me to enter the Captcha MANUALLY (as I have learnt that it > is quite a tedious process via code) > --copy the resulting values and paste them into the required columns > in the sheet (if the input value is invalid then only Mark INVALIDPAN in > column B) > --copy and value given in Next Cell i.e., A5 and so on till the List > is exhausted. > > Hope I am clear ! > > > -- > Sincere Regards > CA Kanwaljit Singh Dhunna > +91-987 6739 911 > +91-950 1031 007 > P*Please don't print this e-mail unless you really need to.* > *IF U LOSE, DON'T LOSE THE LESSON.* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? > It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners > and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. >>> >>> >>> >>> -- >>> Sincere Regards >>> CA Kanwaljit Singh Dhunna >>> +91-987 6739 911 >>> +91-950 1031 007 >>> P*Please don't print this e-mail unless you really need to.* >>> *IF U LOSE, DON'T LOSE THE LESSON.* >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Ur
Re: $$Excel-Macros$$ Macro Required
Ok Vaibhav. Even though I have very little idea about VB (Just read the codes and try to understand them) I will give it a shot. On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi wrote: > i want you to work on present requirement... > > On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Ok Sir, I will do that. >> >> I hope I am clear on my present question. >> >> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: >> >>> You want to learn VBA then start modifying last code which i sent to you >>> to accommodate it.. >>> >>> Start & letus know when you get error.. >>> >>> Cheers!! >>> >>> >>> On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < >>> kanwal...@gmail.com> wrote: >>> Hi Experts, I have attached a sheet. I wish there could be a macro which when run --assess the website given in column A1, --copy the value given in cell A4 in the input box --wait for me to enter the Captcha MANUALLY (as I have learnt that it is quite a tedious process via code) --copy the resulting values and paste them into the required columns in the sheet (if the input value is invalid then only Mark INVALIDPAN in column B) --copy and value given in Next Cell i.e., A5 and so on till the List is exhausted. Hope I am clear ! -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Sincere Regards >> CA Kanwaljit Singh Dhunna >> +91-987 6739 911 >> +91-950 1031 007 >> P*Please don't print this e-mail unless you really need to.* >> *IF U LOSE, DON'T LOSE THE LESSON.* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, 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 br
Re: $$Excel-Macros$$ Macro Required
i want you to work on present requirement... On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna wrote: > Ok Sir, I will do that. > > I hope I am clear on my present question. > > On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: > >> You want to learn VBA then start modifying last code which i sent to you >> to accommodate it.. >> >> Start & letus know when you get error.. >> >> Cheers!! >> >> >> On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < >> kanwal...@gmail.com> wrote: >> >>> Hi Experts, >>> >>> I have attached a sheet. >>> I wish there could be a macro which when run >>> --assess the website given in column A1, >>> --copy the value given in cell A4 in the input box >>> --wait for me to enter the Captcha MANUALLY (as I have learnt that it is >>> quite a tedious process via code) >>> --copy the resulting values and paste them into the required columns in >>> the sheet (if the input value is invalid then only Mark INVALIDPAN in >>> column B) >>> --copy and value given in Next Cell i.e., A5 and so on till the List is >>> exhausted. >>> >>> Hope I am clear ! >>> >>> >>> -- >>> Sincere Regards >>> CA Kanwaljit Singh Dhunna >>> +91-987 6739 911 >>> +91-950 1031 007 >>> P*Please don't print this e-mail unless you really need to.* >>> *IF U LOSE, DON'T LOSE THE LESSON.* >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, 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) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Sincere Regards > CA Kanwaljit Singh Dhunna > +91-987 6739 911 > +91-950 1031 007 > P*Please don't print this e-mail unless you really need to.* > *IF U LOSE, DON'T LOSE THE LESSON.* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You rec
$$Excel-Macros$$ Re: How to convert PDF file to Excel file using excel vba?
Thank u... Paul... & Vabz... On Thursday, February 5, 2015 at 1:25:18 AM UTC+5:30, michael vinoth wrote: > > Dear All, > > I have a doubt. > > How to convert PDF file to Excel file using excel vba? > > It is very useful to me. > > Thanks in advance... > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Macro Required
Ok Sir, I will do that. I hope I am clear on my present question. On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi wrote: > You want to learn VBA then start modifying last code which i sent to you > to accommodate it.. > > Start & letus know when you get error.. > > Cheers!! > > > On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hi Experts, >> >> I have attached a sheet. >> I wish there could be a macro which when run >> --assess the website given in column A1, >> --copy the value given in cell A4 in the input box >> --wait for me to enter the Captcha MANUALLY (as I have learnt that it is >> quite a tedious process via code) >> --copy the resulting values and paste them into the required columns in >> the sheet (if the input value is invalid then only Mark INVALIDPAN in >> column B) >> --copy and value given in Next Cell i.e., A5 and so on till the List is >> exhausted. >> >> Hope I am clear ! >> >> >> -- >> Sincere Regards >> CA Kanwaljit Singh Dhunna >> +91-987 6739 911 >> +91-950 1031 007 >> P*Please don't print this e-mail unless you really need to.* >> *IF U LOSE, DON'T LOSE THE LESSON.* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, 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) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send emai
Re: $$Excel-Macros$$ Macro Required
You want to learn VBA then start modifying last code which i sent to you to accommodate it.. Start & letus know when you get error.. Cheers!! On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna wrote: > Hi Experts, > > I have attached a sheet. > I wish there could be a macro which when run > --assess the website given in column A1, > --copy the value given in cell A4 in the input box > --wait for me to enter the Captcha MANUALLY (as I have learnt that it is > quite a tedious process via code) > --copy the resulting values and paste them into the required columns in > the sheet (if the input value is invalid then only Mark INVALIDPAN in > column B) > --copy and value given in Next Cell i.e., A5 and so on till the List is > exhausted. > > Hope I am clear ! > > > -- > Sincere Regards > CA Kanwaljit Singh Dhunna > +91-987 6739 911 > +91-950 1031 007 > P*Please don't print this e-mail unless you really need to.* > *IF U LOSE, DON'T LOSE THE LESSON.* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Macro Required
Hi Experts, I have attached a sheet. I wish there could be a macro which when run --assess the website given in column A1, --copy the value given in cell A4 in the input box --wait for me to enter the Captcha MANUALLY (as I have learnt that it is quite a tedious process via code) --copy the resulting values and paste them into the required columns in the sheet (if the input value is invalid then only Mark INVALIDPAN in column B) --copy and value given in Next Cell i.e., A5 and so on till the List is exhausted. Hope I am clear ! -- Sincere Regards CA Kanwaljit Singh Dhunna +91-987 6739 911 +91-950 1031 007 P*Please don't print this e-mail unless you really need to.* *IF U LOSE, DON'T LOSE THE LESSON.* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Auto-Fetch-EM.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Little Macro
That Was Amazing Indeed ! How do you do it ! Kindly share what should be the First step in Learning VBA. I am seriously into this now... On Thu, Feb 5, 2015 at 12:19 PM, Vaibhav Joshi wrote: > Yes, check this... > > Cheers!! > > > On Wed, Feb 4, 2015 at 11:49 PM, Kanwaljit Singh Dhunna < > kanwal...@gmail.com> wrote: > >> Hi Vaibhav, >> >> A little tweak would do wonders ! >> >> In Column F1 I have a Validation List "Yes,No" >> If I select Yes, then the result is printed, but I have selected No, then >> only Status is updated in Sheet but no printing is done. >> >> On Sun, Feb 1, 2015 at 4:21 PM, Vaibhav Joshi wrote: >> >>> It gives status. Even if you dont do, excel will overwrite it. >>> >>> Cheers!! >>> On Feb 1, 2015 4:13 PM, "Kanwaljit Singh Dhunna" >>> wrote: >>> :)) You can see the smile ! May God bless you with Bigger Smiley Moments in Yours Life ! A curious point. Why the column C needs to be blanked *manually* before running anything ! Is there some issue in doing it via Coding ? On Sun, Feb 1, 2015 at 12:12 PM, Vaibhav Joshi wrote: > Dear Kanwaljit Singh Dhunna, > > Check attachment, you need to fill data in col. A & B, keep col C > blank b4 running macro. > > Check that you have set correct printer as your default printer as > data will be sent directly for print. > > Press blue button to run Macro & Macro will one Internet Explorer & by > one open send data to page & do as you wanted. > > Cheers!! > > On 1/31/15, Kanwaljit Singh Dhunna wrote: > > Hi Vaibhav, > > > > Thanks for the reply. > > > > I found some sample values. > > AGRS11370C - 01026025086 > > AGRS11370C - 01174026662 > > AGRS11370C - 01026053751 > > > > Above are correct values with me. You can use any incremental number > with > > AGRS11370C to check for incorrect values. > > > > On Sat, Jan 31, 2015 at 8:02 PM, Vaibhav Joshi wrote: > > > >> hi > >> > >> can you send combination of sample data which has value to create > macro > >> for sending result to printer.. > >> > >> On Sat, Jan 31, 2015 at 7:35 PM, Kanwaljit Singh Dhunna < > >> kanwal...@gmail.com> wrote: > >> > >>> Dear Experts, > >>> > >>> I am assessing the following site for a pre-defined list by > entering the > >>> requited two field like > >>> > >>> *PTLP10490E and 091189600169286.* > >>> > >>> > >>> > https://onlineservices.tin.egov-nsdl.com/TIN/JSP/tds/linktoUnAuthorizedInput.jsp > >>> > >>> The resuting page returns No Records found. But if the result is > found > >>> then I need to print the page otherwise I will move to the next > page. > >>> If the values are correct the resulting page contains the string > >>> "*Assessment > >>> Year*" > >>> > >>> I request a macro so that if the string "*Assessment Year"* is > found on > >>> the page there is some alerting sound and the page is sent to > printer > >>> automatically. Otherwise the page is not sent to printer and I can > feed > >>> the > >>> next value. > >>> > >>> Sincere Regards > >>> CA Kanwaljit Singh Dhunna > >>> +91-987 6739 911 > >>> +91-950 1031 007 > >>> P*Please don't print this e-mail unless you really need to.* > >>> *IF U LOSE, DON'T LOSE THE LESSON.* > >>> > >>> -- > >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna > be? > >>> It’s > >>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > >>> https://www.facebook.com/discussexcel > >>> > >>> FORUM RULES > >>> > >>> 1) Use concise, accurate thread titles. Poor thread titles, like > Please > >>> Help, Urgent, 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) Jobs posting is not allowed. > >>> 6) Sharing copyrighted material and their links is not allowed. > >>> > >>> NOTE : Don't ever post confidential data in a workbook. Forum > owners and > >>> members are not responsible for any loss. > >>> --- > >>> You received this message because you are subscribed to the Google > >>> Groups > >>> "MS EXCEL AND VBA MACROS" group. > >>> To unsubscribe from this group and stop receiving emails from it, > send > >>> an > >>> email to excel-macros+unsubscr...@googlegroups.com. > >>> To post to this group, send email to excel-macros@googlegroups.com > . > >>> Visit this group at http://groups.google.com/group/exc
Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007
Hi I tried this one and un-ticked MISSING from libraries and tried to Save As the file with existing. Then it says: The file is already exists. Do you want to replace with existing file? When I click on Yes it again says: Unable to remove existing file.. Kindly look in to this please. Thanks, Pravin Gunjal. On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote: > > That usually is a problem with "References". > > try these steps: > > Stop execution of macro > in VB Editor, select Tools-> References... > > you'll find several libraries selected. > But you might see one that says "Missing" (or something like that). > > The problem is that once the compiler hits this missing library, it stops > looking at the others. > > The string manipulation functions like Left() and Right() are in one of > the object libraries and are not being found. > > You won't need all of the ones I have but the references I have selected > in Excel 2010 are: > > Visual Basic for Applications > Microsoft Excel 14.0 Object Library > OLE Automation > Microsoft Office 14.0 Object Library > Microsoft Word 14.0 Object Library > Microsoft Forms 2.0 Object LIbrary > > > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Pravin Gunjal > > *To:* Excel Macros > > *Sent:* Tuesday, February 3, 2015 8:33 AM > *Subject:* $$Excel-Macros$$ Error on saving the DBF file in Excel 2007 > > Hi > > I have downloaded the DBF save add-in but while saving got the attached > error in VB. > Could anyone please check and update me on this issue. > > Thank you > Pravin Gunjal > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros...@googlegroups.com . > To post to this group, send email to excel-...@googlegroups.com > . > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
